public static CustomList <HourlyLeaveTrans> HourlyLeaveApproval(string empKey) { ConnectionManager conManager = new ConnectionManager(ConnectionName.HR); CustomList <HourlyLeaveTrans> HourlyLeaveTransCollection = new CustomList <HourlyLeaveTrans>(); IDataReader reader = null; String sql = "EXEC spGetHourlyLeaveTransReportiee '" + empKey + "'"; try { conManager.OpenDataReader(sql, out reader); while (reader.Read()) { HourlyLeaveTrans newHourlyLeaveTrans = new HourlyLeaveTrans(); newHourlyLeaveTrans.SetDataLeave(reader); HourlyLeaveTransCollection.Add(newHourlyLeaveTrans); } return(HourlyLeaveTransCollection); } catch (Exception ex) { throw (ex); } finally { if (reader != null && !reader.IsClosed) { reader.Close(); } } }
public static CustomList <HourlyLeaveTrans> GetAllHourlyLeaveTrans() { ConnectionManager conManager = new ConnectionManager(ConnectionName.HR); CustomList <HourlyLeaveTrans> HourlyLeaveTransCollection = new CustomList <HourlyLeaveTrans>(); IDataReader reader = null; const String sql = "select *from HourlyLeaveTrans"; try { conManager.OpenDataReader(sql, out reader); while (reader.Read()) { HourlyLeaveTrans newHourlyLeaveTrans = new HourlyLeaveTrans(); newHourlyLeaveTrans.SetData(reader); HourlyLeaveTransCollection.Add(newHourlyLeaveTrans); } HourlyLeaveTransCollection.InsertSpName = "spInsertHourlyLeaveTrans"; HourlyLeaveTransCollection.UpdateSpName = "spUpdateHourlyLeaveTrans"; HourlyLeaveTransCollection.DeleteSpName = "spDeleteHourlyLeaveTrans"; return(HourlyLeaveTransCollection); } catch (Exception ex) { throw (ex); } finally { if (reader != null && !reader.IsClosed) { reader.Close(); } } }
private void SetHourlyLeaveTransDataFromObjToControl(ASL.Hr.DAO.HourlyLeaveTrans objHourlyLeave) { try { if (objHourlyLeave.LeavePolicyID.IsNotNullOrEmpty()) { ddlLeaveType.SelectedValue = ddlLeaveType.Items.FindByValue(objHourlyLeave.LeavePolicyID) == null ? "" : ddlLeaveType.Items.FindByValue(objHourlyLeave.LeavePolicyID).Value; } txtWorkDate.Text = objHourlyLeave.LeaveDate.ToShortDateString(); txtFrom.Text = objHourlyLeave.LeaveFrom; txtTo.Text = objHourlyLeave.LeaveTo; txtLeaveHours.Text = objHourlyLeave.TotalHour.ToString(); txtReason.Text = objHourlyLeave.LeaveReason; txtAvailPlace.Text = objHourlyLeave.LeaveAvailPlace; txtAdditionalContact.Text = objHourlyLeave.ContactNo; } catch (Exception ex) { throw(ex); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { String eventTarget = Request["__EVENTTARGET"].IsNullOrEmpty() ? String.Empty : Request["__EVENTTARGET"]; InitializeSession(); InitializeControls(); leaveFromHome.Visible = false; string empcode = Request.QueryString.Get("empCodeForLeave"); if (empcode.IsNotNullOrEmpty()) { Header1.Visible = false; divTest.Style.Add("display", "none"); leaveFromHome.Visible = true; } } else { Page.ClientScript.GetPostBackEventReference(this, String.Empty); String eventTarget = Request["__EVENTTARGET"].IsNullOrEmpty() ? String.Empty : Request["__EVENTTARGET"]; if (eventTarget.Equals("SearchEmployee")) { string EmployeeCode = ((TextBox)this.Header1.FindControl("txtSearch")).Text.ToString(); this.IsPostBack.IsFalse(); } else if (eventTarget.Equals("SelectGridRow")) { String eventArgument = Request["__EVENTARGUMENT"].IsNullOrEmpty() ? String.Empty : Request["__EVENTARGUMENT"]; hidSelectedRow.Value = eventArgument; LeaveTransApproved leaveTrans = _LeaveTransactions.Find(item => item.VID == eventArgument.ToInt()); CustomList <LeaveTransApproved> obj = new CustomList <LeaveTransApproved>(); if (leaveTrans.IsNotNull()) { obj.Add(leaveTrans); } if (leaveTrans.IsNotNull()) { Session["SelectedGridRow"] = leaveTrans; _LeaveTransactionsToDelete = obj; SetLeaveTransDateFromObjToControl(ref obj); } } else if (eventTarget.Equals("SelectHourlyLeaveGridRow")) { String eventArgument = Request["__EVENTARGUMENT"].IsNullOrEmpty() ? String.Empty : Request["__EVENTARGUMENT"]; hidSelectedRow.Value = eventArgument; ASL.Hr.DAO.HourlyLeaveTrans HourlyLeaveTrans = _HourlyLeaveTransactions.Find(item => item.VID == eventArgument.ToInt()); CustomList <ASL.Hr.DAO.HourlyLeaveTrans> obj = new CustomList <ASL.Hr.DAO.HourlyLeaveTrans>(); if (HourlyLeaveTrans.IsNotNull()) { obj.Add(HourlyLeaveTrans); } if (HourlyLeaveTrans.IsNotNull()) { Session["SelectedGridRow"] = HourlyLeaveTrans; _HourlyLeaveTransactionsToDelete = obj; SetHourlyLeaveTransDataFromObjToControl(HourlyLeaveTrans); } } else if (eventTarget.Equals("SearchSupervisor")) { HRM_Emp searchEmp = Session[ASL.STATIC.StaticInfo.SearchSessionVarName] as HRM_Emp; txtLeaveSubstitute.Text = searchEmp.EmpName; hfLeaveSubstitute.Value = searchEmp.EmpCode; } } }