protected void grdUsers_RowUpdating(object sender, GridViewUpdateEventArgs e) { try { EmployeeBL obj = new EmployeeBL(); int PaidLeaveID = 0; if (grdUsers.DataKeys[e.RowIndex].Value.ToString().Trim()!= "") { PaidLeaveID = Convert.ToInt32(grdUsers.DataKeys[e.RowIndex].Value); } HiddenField hdnUserid = (HiddenField)grdUsers.Rows[e.RowIndex].FindControl("hdnUserid"); int PaidLeaveUserID = Convert.ToInt32(hdnUserid.Value); TextBox txtLeavesStartDt = (TextBox)grdUsers.Rows[e.RowIndex].FindControl("txtLeavesStartDt"); TextBox txtLevAvail = (TextBox)grdUsers.Rows[e.RowIndex].FindControl("txtLeavAvailable"); TextBox txtLeavesUsed = (TextBox)grdUsers.Rows[e.RowIndex].FindControl("txtLeavesUsed"); TextBox txtLeavBalanced = (TextBox)grdUsers.Rows[e.RowIndex].FindControl("txtLeavBalanced"); //TextBox txtMAxLevAvail = (TextBox)grdUsers.Rows[e.RowIndex].FindControl("txtMaxEligible"); TextBox txtNotes = (TextBox)grdUsers.Rows[e.RowIndex].FindControl("txtNotes"); string timezone = ""; if (Convert.ToInt32(Session["TimeZoneID"]) == 2) { timezone = "Eastern Standard Time"; } else { timezone = "India Standard Time"; } DateTime StartDate = Convert.ToDateTime(ViewState["PaidStartDate"]); DateTime CurrentDate = TimeZoneInfo.ConvertTime(DateTime.UtcNow, TimeZoneInfo.FindSystemTimeZoneById(timezone)); int LeaveAvail =txtLevAvail.Text==""?0:Convert.ToInt32(txtLevAvail.Text); // int MaxLeaveAvail = Convert.ToInt32(txtMAxLevAvail.Text); int LeavesUsed =txtLeavesUsed.Text==""?0:Convert.ToInt32(txtLeavesUsed.Text); int LeavesBalanced =txtLeavBalanced.Text==""?0:Convert.ToInt32(txtLeavBalanced.Text); DateTime LeavesStartDt =txtLeavesStartDt.Text==""?Convert.ToDateTime("01/01/1900"): Convert.ToDateTime(txtLeavesStartDt.Text); string notes = txtNotes.Text.Trim() == "" ? "" : GeneralFunction.ToProperNotes(txtNotes.Text) + "<br>" + "-------------------------------------<br>" + "Updated by " + Session["EmpName"].ToString().Trim() + " at " + CurrentDate + "<br>" + "***********************************" + "<br>"; int userid = Convert.ToInt32(Session["UserID"]); String strHostName = Request.UserHostAddress.ToString(); string strIp = System.Net.Dns.GetHostAddresses(strHostName).GetValue(0).ToString(); bool bnew = obj.UpdatePaidLeaveByLeaveID(LeaveAvail, LeavesUsed, LeavesBalanced, PaidLeaveID, userid, notes, StartDate, LeavesStartDt, strIp, PaidLeaveUserID, CurrentDate); grdUsers.EditIndex = -1; DateTime EndDate = Convert.ToDateTime(ViewState["PaidEndDate"]); GetpaidLeavesData(Convert.ToInt32(ddlLocation.SelectedItem.Value), StartDate, EndDate, Convert.ToInt32(ddlShift.SelectedValue)); } catch (Exception ex) { } }