//protected void Page_Unload(object sender, EventArgs e) //{ // this.OpenRecord(); // // your code //} private void OpenRecord() { grLeaveList.DataSource = null; grLeaveList.DataBind(); string strStartYear = DateTime.Now.Year.ToString(); string strStartMonth = DateTime.Now.Month.ToString(); if (Convert.ToInt32(strStartMonth) >= 1) { strStartDate = Convert.ToString(Convert.ToInt32(strStartYear) - 1); strEndDate = Convert.ToString(Convert.ToInt32(strStartDate) + 1); strStartDate = strStartDate + "-" + "07" + "-" + "01"; strEndDate = strEndDate + "-" + "12" + "-" + "31"; } if (Session["ISADMIN"].ToString() == "N") { grLeaveList.DataSource = objLeaveMgr.SelectRequestLeaveAppMst(0, "", "R", strStartDate, strEndDate, Session["EMPID"].ToString().Trim()); } else { grLeaveList.DataSource = objLeaveMgr.SelectRequestLeaveAppMst(0, "", "R", strStartDate, strEndDate, ""); } grLeaveList.DataBind(); this.FormatGridDate(); }
private void OpenRecord() { grPendingLeaveList.DataSource = null; grPendingLeaveList.DataBind(); string strStartDate = DateTime.Now.Year.ToString(); string strEndDate = Convert.ToString(Convert.ToInt32(strStartDate) + 1); strStartDate = strStartDate + "-" + "01" + "-" + "01"; strEndDate = strEndDate + "-" + "12" + "-" + "31"; DataTable dtLeaveDeny = new DataTable(); if (Session["ISADMIN"].ToString() == "N") { //dtLeaveDeny = objLeaveMgr.SelectRequestLeaveAppMst(0, "", "P", strStartDate, strEndDate, Session["EMPID"].ToString().Trim()); dtLeaveDeny = objLeaveMgr.SelectRequestLeaveAppMst(0, Session["EMPID"].ToString().Trim(), "PRDCA", strStartDate, strEndDate, ""); } else { // dtLeaveDeny = objLeaveMgr.SelectRequestLeaveAppMst(0, "", "P", strStartDate, strEndDate, ""); dtLeaveDeny = objLeaveMgr.SelectRequestLeaveAppMst(0, "N", "PR", strStartDate, strEndDate, ""); } grPendingLeaveList.DataSource = dtLeaveDeny; grPendingLeaveList.DataBind(); this.FormatDenyGridDate(); dtLeaveDeny.Rows.Clear(); dtLeaveDeny.Dispose(); }
protected void btnApprove_Click(object sender, EventArgs e) { string strPreYrLv = ""; personTable = ViewState["dt"] as DataTable; DataTable dtLeaveApp = new DataTable(); dtLeaveApp = objLeaveMgr.SelectRequestLeaveAppMst(Convert.ToInt32(personTable.Rows[0]["LvAppID"].ToString().Trim()), personTable.Rows[0]["EmpId"].ToString().Trim(), "", Common.ReturnDateTimeInString(Common.DisplayDateTime(personTable.Rows[0]["LeaveStart"].ToString().Trim(), false, Constant.strDateFormat), false, Constant.strDateFormat), Common.ReturnDateTimeInString(Common.DisplayDateTime(personTable.Rows[0]["LeaveEnd"].ToString().Trim(), false, Constant.strDateFormat), false, Constant.strDateFormat), ""); if (dtLeaveApp.Rows.Count > 0) { this.AvailableLeave("A", dtLeaveApp.Rows[0]["EmpId"].ToString().Trim(), dtLeaveApp.Rows[0]["LTypeId"].ToString().Trim(), dtLeaveApp.Rows[0]["LDurInDays"].ToString().Trim()); this.GetLeaveDates(dtLeaveApp.Rows[0]["LvAppID"].ToString().Trim(), "A", dtLeaveApp.Rows[0]["LeaveStart"].ToString().Trim(), dtLeaveApp.Rows[0]["LeaveEnd"].ToString().Trim()); objLeaveMgr.UpdateLeaveAppMstForApprove(dtLeaveApp.Rows[0]["LvAppID"].ToString().Trim(), dtLeaveApp.Rows[0]["EmpId"].ToString().Trim(), "Y", "N", "A", hfLEnjoyed.Value.ToString(), hfLDates.Value.ToString(), dtLeaveApp.Rows[0]["LAbbrName"].ToString().Trim(), dtLeaveApp.Rows[0]["LTypeId"].ToString().Trim(), dtLeaveApp.Rows[0]["LTReason"].ToString().Trim(), Session["USERID"].ToString(), Common.ReturnDateTimeInString(Common.DisplayDateTime(DateTime.Now.ToString(), false, Constant.strDateFormat), false, Constant.strDateFormat), strPreYrLv, dtLeaveApp.Rows[0]["LDurInDays"].ToString().Trim()); ScriptManager.RegisterClientScriptBlock(Page, typeof(string), Guid.NewGuid().ToString(), "ReLoadPreviousPage();", true); SiteMaster.ShowClientMessage(Page, "Leave has been approved successfully.", "success"); ScriptManager.RegisterClientScriptBlock(Page, typeof(string), Guid.NewGuid().ToString(), "CloseWindow(3200);", true); } else { SiteMaster.ShowClientMessage(Page, "No Leave Information to Approve.", "warn"); } }