Hi, I am trying to give an alert message using "WebMethod",where my conditions are as follows 1.I am trying to restrict the user applying leave on "Monday" when he/She has already taken Leave on the previous friday. 2.I am geeting the details from my Database where the employees leave Details and trying to code this in WebMethod.
<pre>My cs page code: [System.Web.Services.WebMethod] public string GetCurrentTime() { SqlConnection con = new SqlConnection(conString); con.Open(); SqlCommand cn = new SqlCommand(); DateTime date3 = System.DateTime.Now; DateTime date4 = System.DateTime.Now; DateTime date1 = System.DateTime.Now.AddDays(-6); ; DateTime date2 = System.DateTime.Now.AddDays(-6); DateTime.TryParse(txtFromDate.Text, out date1); DateTime.TryParse(txtToDate.Text, out date2); // string val; // var EmpID = "SS212"; SqlDataAdapter da = new SqlDataAdapter(scmd); DataTable dt=new DataTable(); da.Fill(dt); sdr = scmd.ExecuteReader(); if (date1.DayOfWeek == DayOfWeek.Monday && date2.DayOfWeek == DayOfWeek.Monday) { string Leave = "Select EmpID ,LeaveType,LeaveFromDate,LeaveToDate,LeaveStatus from LeaveApplication Where LeaveFromDate = '" + date1 + "' and LeaveToDate = '" + date2 + "'"; scmd = new SqlCommand(Leave, scon); } for(int i = 0; i < dt.Rows.Count; i++) { String value ; if ((dt.Rows[i]["LeaveStatus"].ToString() == "Accepted") || (dt.Rows[i]["LeaveStatus"].ToString() == "Pending")) { value=""; } else { value = ""; } } return ""; } My aspx: <script src="http://ajax.googleapis.com/ajax/libs/jquery/1.8.3/jquery.min.js" type="text/javascript"></script> <script type="text/javascript"> function ShowCurrentDate() { $.ajax({ type: "POST", url: "LMSEmployee.aspx/GetCurrentTime", data: params, contentType: "application/json; charset=utf-8", dataType: "json", success: OnSuccess, failure: function (response) { alert("Please"); } }); } function OnSuccess(response) { alert("Please"); } </script>
static
[System.Web.Services.WebMethod] public string GetDetails() { DateTime date3 = System.DateTime.Now; DateTime date4 = System.DateTime.Now; // DateTime date1 = System.DateTime.Now.AddDays(-7); ; // DateTime date2 = System.DateTime.Now.AddDays(-7); DateTime.TryParse(txtFromDate.Text, out date3); DateTime.TryParse(txtToDate.Text, out date4); string Id = "SS472"; string Leave = "Select EmpID ,LeaveType,LeaveFromDate,LeaveToDate,LeaveStatus from LeaveApplication Where LeaveFromDate >= '" + date3.AddDays(-7) + "' and LeaveToDate <= '" + date4.AddDays(-7) + "' and EmpID = '" + Id + "' "; scon = new SqlConnection(conString); scmd = new SqlCommand(Leave, scon); scon.Open(); sda = new SqlDataAdapter(scmd); ds = new DataSet(); ds.Clear(); sda.Fill(ds, "LeaveApplication"); table = ds.Tables[0]; String Value=""; for (int i = 0; i < table.Rows.Count; i++) { if ((table.Rows[i]["LeaveStatus"].ToString() == "Accepted") || (table.Rows[i]["LeaveStatus"].ToString() == "Pending") || (table.Rows[i]["LeaveHalfDayFrom"].ToString() == "FN")) { Value = "Leave Not Allowed"; } else if (table.Rows[i]["LeaveStatus"].ToString()=="Rejected") { } } scon.Close(); return Value; }
<input id="btnGetResponses" type="button" value="Show Current Time" /> <script src="http://ajax.googleapis.com/ajax/libs/jquery/1.8.3/jquery.min.js" type="text/javascript"></script> <script type="text/javascript"> $(function () { $("#btnGetResponses").click(function () { $.ajax({ type: "POST", url: "LMSEmployee.aspx/GetDetails", data: '{}', contentType: "application/json; charset=utf-8", dataType: "json", success: function (response) { if (response.d == true) { alert("Abc"); } }, failure: function (response) { alert(response.d); } }); }); }); </script>
[System.Web.Services.WebMethod] public static string GetDetails(DateTime date3, DateTime date4) { string conString = System.Configuration.ConfigurationManager.ConnectionStrings["TimeSheetConnectionString2"].ConnectionString; SqlConnection scon; SqlCommand scmd; SqlDataAdapter sda; SqlDataReader sdr; DataSet ds; DataTable dtab; DataTable table; if (HttpContext.Current != null) { date3 = System.DateTime.Now; date4 = System.DateTime.Now; // DateTime date1 = System.DateTime.Now.AddDays(-7); ; // DateTime date2 = System.DateTime.Now.AddDays(-7); //DateTime.TryParse(txtFromDate.Text, out date3); //DateTime.TryParse(txtToDate.Text, out date4); } string Id = "SS472"; string Leave = "Select EmpID ,LeaveType,LeaveFromDate,LeaveToDate,LeaveStatus from LeaveApplication Where LeaveFromDate >= '" + date3.AddDays(-7) + "' and LeaveToDate <= '" + date4.AddDays(-7) + "' and EmpID = '" + Id + "' "; scmd = new SqlCommand(Leave); sda = new SqlDataAdapter(scmd); ds = new DataSet(); ds.Clear(); sda.Fill(ds, "LeaveApplication"); table = ds.Tables[0]; string message = string.Empty; for (int i = 0; i < table.Rows.Count; i++) { if ((table.Rows[i]["LeaveStatus"].ToString() == "Accepted") || (table.Rows[i]["LeaveStatus"].ToString() == "Pending")) { message = "Leave Not Allowed"; } else if (table.Rows[i]["LeaveStatus"].ToString() == "Rejected") { message = ""; } } return message; }
DataRow row = table.Rows[0]; if ((row["LeaveStatus"].ToString() == "Accepted" || row["LeaveStatus"].ToString() == "Pending" || row["Status"].ToString() == "Absent") && (row["ShiftDetails"].ToString() == "false")) { }
$(document).ready(function () { $("[id*=txtFromDate],[id*=txtToDate],[id*=chkHalfFrom]").blur(function () { var obj = {}; obj.date3 = $.trim($("[id*=txtFromDate]").val()); obj.date4 = $.trim($("[id*=txtToDate]").val()); obj.chek1 = chek1 = $('[id*=chkHalfFrom]').is(":checked"); if (obj.date3 != '' && obj.date4 != '' && !obj.chek1) { var temp = $.ajax({ type: "POST", url: 'LMSEmployee.aspx/GetCurrentTime', data: JSON.stringify(obj), contentType: "application/json; charset=utf-8", dataType: "json", }); temp.success(function (response) { if (response.d == "Apply") { $("[id *= btnApply]").attr('disabled', false); } else { $("[id *= btnApply]").attr('disabled', true); $("[id *= txtToDate]").val(''); alert(response.d); } if (obj.chek1) { $("[id *= btnApply]").attr('disabled', false); } }) } return false; }); });
protected void btnSubmit_Click(object sender, EventArgs e) { try { string lnkdServerName = ""; showErrorMsg.Visible = false; //if (chkOldDB.Checked == true) //{ // lnkdServerName = ConfigurationManager.AppSettings["LnkdSeverOld"]; // conn = connnew; //} //else // lnkdServerName = ConfigurationManager.AppSettings["LnkdSever"]; if (txtStartDate.Text == "") { txtStartDate.Focus(); return; } if (txtEndDate.Text == "") { txtEndDate.Focus(); return; } DateTime sd = Convert.ToDateTime(txtStartDate.Text); DateTime ed = Convert.ToDateTime(txtEndDate.Text); int countDate = Convert.ToInt32((ed - sd).TotalDays); showErrorMsg.Text = ""; if (countDate >= 31) { showErrorMsg.Style.Add("margin-left", "0px"); showErrorMsg.Visible = true; showErrorMsg.Text = "Date Range should not greater than 45 days"; showErrorMsg.ForeColor = Color.Red; return; } if (ed < sd) { Response.Write("<script>alert('From Date should be less than To Date')</script>"); return; } DataTable dtwithDates = new DataTable(); if (ddlStatus.SelectedIndex == 0) { if (ddlDept.SelectedIndex == 0 && ddlEmp.SelectedIndex == 0) { if (txtStartDate.Text != string.Empty && txtEndDate.Text != string.Empty) { if (txtStartDate.Text.Length == 10 && txtStartDate.Text.ToString().Substring(2, 1) == "/" && txtStartDate.Text.ToString().Substring(5, 1) == "/" && txtEndDate.Text.Length == 10 && txtEndDate.Text.ToString().Substring(2, 1) == "/" && txtEndDate.Text.ToString().Substring(5, 1) == "/") { if (ed > sd) { dtwithDates.Clear(); if (conn.State == ConnectionState.Closed) { conn.Open(); } } } } } } else if (ddlStatus.SelectedIndex == 1) { if (ddlDept.SelectedIndex == 0 && ddlEmp.SelectedIndex == 0) { if (txtStartDate.Text != string.Empty && txtEndDate.Text != string.Empty) { if (txtStartDate.Text.Length == 10 && txtStartDate.Text.ToString().Substring(2, 1) == "/" && txtStartDate.Text.ToString().Substring(5, 1) == "/" && txtEndDate.Text.Length == 10 && txtEndDate.Text.ToString().Substring(2, 1) == "/" && txtEndDate.Text.ToString().Substring(5, 1) == "/") { if (ed > sd) { dtwithDates.Clear(); if (conn.State == ConnectionState.Closed) { conn.Open(); } SqlCommand cmdwit
float TotDur = int.Parse(e.Row.Cells[7].Text); foreach (TableCell cell in e.Row.Cells) { if (TotDur <= 9.0) { cell.BackColor = Color.Red; } }
protected void gridEmpList_RowDataBound(object sender, GridViewRowEventArgs e) { if (e.Row.RowType == DataControlRowType.DataRow) { e.Row.Cells[10].Text = "9:5"; float Record = int.Parse(e.Row.Cells[10].Text); // String Record = e.Row.Cells[10].Text; foreach (TableCell cell in e.Row.Cells) { if (Record > 9) { cell.BackColor = Color.Orange; } } } }
Select DISTINCT LeaveFromDate,LeaveToDate, EmpID ,LeaveType,LeaveStatus from IntranetRelease.dbo.LeaveApplication Where LeaveFromDate >='2017-06-30' and LeaveToDate <= '2017-06-30' and EmpID = 'SS525'
lblLeaveApplyErrorMsg.Visible = false; string strLAEmpid = lblEmpID.Text; string strLAEmpName = lblEmpName.Text; string strLAEmpOffMailID = Session["offId"].ToString(); string strLALeaveType = ddlLeaveType.SelectedItem.Text; string strLALeaveFromDate = txtFromDate.Text; string strLALeaveHalfDayFrom; string strMP = txtmisspunchfrom.Text; string submit_cc = null; string submitTo = null; string CCmailid = string.Empty; ///////////Code To Restrict Duplicate Entry///////////////// if (ddlLeaveType.SelectedItem.Text == "Casual Leave" || ddlLeaveType.SelectedItem.Text == "Earned Leave" || ddlLeaveType.SelectedItem.Text == "Sick Leave" || ddlLeaveType.SelectedItem.Text == "Comp Off" || ddlLeaveType.SelectedItem.Text == "Comp Off" || ddlLeaveType.SelectedItem.Text == "Wedding Leave" || ddlLeaveType.SelectedItem.Text == "Maternity Leave" || ddlLeaveType.SelectedItem.Text == "Bereavement Leave" || ddlLeaveType.SelectedItem.Text == "Paternity Leave" || ddlLeaveType.SelectedItem.Text == "Floating Leave") { string chkalreadyapplied = "( Select DISTINCT LeaveFromDate,LeaveToDate, EmpID ,LeaveType,LeaveStatus from IntranetRelease.dbo.LeaveApplication Where LeaveFromDate >= '" + strLALeaveFromDate + "' and LeaveToDate <= '" + strLALeaveFromDate + "' and EmpID = 'SS525' )"; //// MessageBox.Show(strLAEmpid + strLAEmpName + strLAEmpOffMailID + strLALeaveType + strLALeaveFromDate + strLALeaveHalfDayFrom + strLALeaveToDate + strLALeaveHalfDayTo + douLANoOfDays + strLAReason + strLALeaveStatus + strLALeaveAppliedOn + strLeaveAppliedTo); scon = new SqlConnection(conString); scmd = new SqlCommand(chkalreadyapplied, scon); scon.Open(); scmd.ExecuteNonQuery(); scon.Close(); if (ddlLeaveType.SelectedItem.Text == "Permission") { string permissionapply = "Insert into [Emp_Permission] ([Empid],[Empname],[Date of Permission],[Reason],[Fromtime],[Totime],[TimeDuration],[PerAppliedOn],[PerAppliedTo]) values ('" + strLAEmpid + "','" + strLAEmpName + "','" + strLALeaveFromDate + "','" + strLAReason + "','" + ViewState["Pertimefrom"] + "','" + ViewState["Pertotime"] + "','" + ViewState["tmper"] + "','" + strLALeaveAppliedOn + "', '" + strLeaveAppliedTo + "' )"; SqlConnection percon = new SqlConnection(conString); SqlCommand percmd = new SqlCommand(permissionapply, percon); percon.Open(); percmd.ExecuteNonQuery(); percon.Close(); } if (ddlLeaveType.SelectedItem.Text == "Miss Punch") { string misspunchapply = "Insert into IntranetReleaseNew.dbo.Emp_MissPunch ([Empid],[Empname],[DateofMissPunch],[Reason],[TimeDurInHours],[MisspunchAppliedOn],[MisspunchAppliedTo]) values ('" + strLAEmpid + "','" + strLAEmpName + "','" + strLALeaveFromDate + "','" + strLAReason + "','" + strMP + "','" + strLALeaveAppliedOn + "', '" + strLeaveAppliedTo + "' )"; SqlConnection misspuncon = new SqlConnection(conString); SqlCommand misspunchcmd = new SqlCommand(misspunchapply, misspuncon); misspuncon.Open(); misspunchcmd.ExecuteNonQuery(); misspuncon.Close(); } if (ddlLeaveType.SelectedItem.Text == "Work from Home") { string WFHapply = "Insert into [WorkFromHome] ([Empid],[Empname],[Date of WFH],[Reason],[Fromtime],[Totime],[TimeDuration],[WFHAppliedOn],[WFHAppliedTo]) values ('" + strLAEmpid + "','" + strLAEmpName + "','" + strLALeaveFromDate + "','" + strLAReason + "','" + ViewState["Pertimefrom"] + "','" + ViewState["Pertotime"] + "','" + ViewState["tmper"] + "','" + strLA
string strLALeaveFromDate = txtFromDate.Text; string strLALeaveToDate = txtToDate.Text; string strLALeaveHalfDayFrom; string strMP = txtmisspunchfrom.Text; string submit_cc = null; string submitTo = null; string CCmailid = string.Empty; ///////////Code To Restrict Duplicate Entry///////////////// if (ddlLeaveType.SelectedItem.Text == "Casual Leave" || ddlLeaveType.SelectedItem.Text == "Earned Leave" || ddlLeaveType.SelectedItem.Text == "Sick Leave" || ddlLeaveType.SelectedItem.Text == "Comp Off" || ddlLeaveType.SelectedItem.Text == "Comp Off" || ddlLeaveType.SelectedItem.Text == "Wedding Leave" || ddlLeaveType.SelectedItem.Text == "Maternity Leave" || ddlLeaveType.SelectedItem.Text == "Bereavement Leave" || ddlLeaveType.SelectedItem.Text == "Paternity Leave" || ddlLeaveType.SelectedItem.Text == "Floating Leave") { string chkalreadyapplied = "( Select LeaveFromDate,LeaveToDate, EmpID ,LeaveType,LeaveStatus from IntranetRelease.dbo.LeaveApplication Where LeaveFromDate >= '" + strLALeaveFromDate + "' and LeaveToDate <= '" + strLALeaveToDate + "' and EmpID = 'SS525' )"; //// MessageBox.Show(strLAEmpid + strLAEmpName + strLAEmpOffMailID + strLALeaveType + strLALeaveFromDate + strLALeaveHalfDayFrom + strLALeaveToDate + strLALeaveHalfDayTo + douLANoOfDays + strLAReason + strLALeaveStatus + strLALeaveAppliedOn + strLeaveAppliedTo); scon = new SqlConnection(conString); scmd = new SqlCommand(chkalreadyapplied, scon); scon.Open(); scmd.ExecuteNonQuery(); scon.Close(); if (txtFromDate.Text != strLALeaveFromDate) { } } else { MessageBox.Show("You Have Already Applied Leave on the Selected Date"); btnApply.Visible = false; }
Select DISTINCT LeaveFromDate,LeaveToDate, EmpID ,LeaveType,LeaveStatus from IntranetRelease.dbo.LeaveApplication Where LeaveFromDate >='2017-06-30' and LeaveToDate <= '2017-06-30'
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)