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;
}
}
}
