private void LoadData()
{
EmpLeaveDAL _dalEmpLeaveDAL = null;
Hashtable _htParameters = null;
try
{
_dalEmpLeaveDAL = new EmpLeaveDAL();
_htParameters = new Hashtable();
if (Request.Params["action"] == "edt")
{
_htParameters["p_ID"] = Request.Params["id"];
DataTable _dt = _dalEmpLeaveDAL.GetRow(_htParameters);
MPF23.Shared.Mapper.DBToUI.Map(pnlBody.Controls, _dt.Rows[0]);
if (txtTotDay.Text == "0.5")
{
CheckHAlf.Checked = true;
HitungHari();
}
}
}
catch (Exception ex)
{
Utility.ShowMessageBox(this, Utility.LOAD_DATA_FAIL_MESSAGE, ex, null);
}
}
private void BindGrid()
{
EmpLeaveDAL _dalEmpLeave = null;
Hashtable _htParameters = null;
try
{
_dalEmpLeave = new EmpLeaveDAL();
_htParameters = new Hashtable();
_htParameters["p_keywords"] = txtSearch.Text;
_htParameters["p_status"] = "0";
if (Session[SessionKey.CURRENT_USER_HRMS_ROLE].ToString() == "1")
{
_htParameters["p_Employee_Code"] = lblEmployee_Code.Text;
}
gvwList.DataSource = _dalEmpLeave.GetRows(_htParameters);
gvwList.DataBind();
}
catch (Exception ex)
{
Utility.ShowMessageBox(this, Utility.LOAD_DATA_FAIL_MESSAGE, ex, null, null);
}
}
protected void gvwList_RowCommand(object sender, GridViewCommandEventArgs e)
{
switch (e.CommandName)
{
case "Edit":
Response.Redirect("leavedtl.aspx?action=edt&id=" + e.CommandArgument);
break;
case "Delete":
EmpLeaveDAL _dalEmpLeave = null;
Hashtable _htParameters = null;
try
{
_dalEmpLeave = new EmpLeaveDAL();
_htParameters = new Hashtable();
_htParameters["p_ID"] = e.CommandArgument.ToString();
_dalEmpLeave.Delete(_htParameters);
this.BindGrid();
Response.Redirect("leavelst.aspx");
}
catch (Exception ex)
{
Utility.ShowMessageBox(this, Utility.LOAD_DATA_FAIL_MESSAGE, ex, null);
}
break;
}
}
private void SaveData()
{
EmpLeaveDAL _dalEmpLeaveDAL = null;
Hashtable _htParameters = null;
int iNextID = 0;
try
{
_dalEmpLeaveDAL = new EmpLeaveDAL();
_htParameters = new Hashtable();
MPF23.Shared.Mapper.UIToDB.Map(pnlBody.Controls, _htParameters);
Utility.ApplyDefaultProp(_htParameters);
if (Request.Params["action"] == "edt")
{
_dalEmpLeaveDAL.Update(_htParameters);
iNextID = Int32.Parse(lbl_ID.Text);
}
else
{
_dalEmpLeaveDAL.Insert(_htParameters, ref iNextID);
}
Utility.ShowMessageBox(this, Utility.SAVE_DATA_SUCCESS_MESSAGE, null, "leavedtl.aspx?action=edt&id=" + iNextID.ToString());
}
catch (Exception ex)
{
Utility.ShowMessageBox(this, Utility.SAVE_DATA_FAIL_MESSAGE, ex, null);
}
}
private void LoadData()
{
EmpLeaveDAL _dalEmpLeaveDAL = null;
Hashtable _htParameters = null;
try
{
//System.Diagnostics.Debugger.Break();
//ddlEmployee_Code.SelectedValue = SessionKey.CURRENT_USER_HRMS_EMP_CODE.ToString();
txtSubmissionDate.Text = Utility.CurrentDate;
//GET ROLE Response.Write(Session[SessionKey.CURRENT_USER_HRMS_ROLE]);
_dalEmpLeaveDAL = new EmpLeaveDAL();
_htParameters = new Hashtable();
if (Request.Params["action"] == "edt")
{
_htParameters["p_ID"] = Request.Params["id"];
DataTable _dt = _dalEmpLeaveDAL.GetRow(_htParameters);
MPF23.Shared.Mapper.DBToUI.Map(pnlBody.Controls, _dt.Rows[0]);
if (ddlStatus.SelectedValue == "0")
{
btnSave.Visible = true;
}
else
{
btnSave.Visible = false;
}
if (txtTotDay.Text == "0.5")
{
CheckHAlf.Checked = true;
HitungHari();
}
}
else
{
txtEmployee_code.Text = Session[SessionKey.CURRENT_USER_HRMS_EMP_CODE].ToString().Trim();
txtEmployee_Name.Text = Session[SessionKey.CURRENT_USER_HRMS_EMP_NAME].ToString().Trim();
}
}
catch (Exception ex)
{
Utility.ShowMessageBox(this, Utility.LOAD_DATA_FAIL_MESSAGE, ex, null);
}
}
protected void btnApproval_Click(object sender, EventArgs e)
{
mdlPopupApproveValidate.Hide();
if (approvemtd(txtPassword.Text) == 1)
{
EmpLeaveDAL _dalEmpLeaveDAL = new EmpLeaveDAL();
Hashtable _htParameters = new Hashtable();
foreach (GridViewRow row in gvwList.Rows)
{
if (row.RowType == DataControlRowType.DataRow)
{
CheckBox chb = (CheckBox)row.Cells[1].Controls[1];
if (chb.Checked)
{
try
{
_htParameters.Clear();
_htParameters["p_id"] = Int32.Parse(gvwList.DataKeys[row.RowIndex][0].ToString());
_htParameters["p_Employee_Code"] = lblEmployee_Code.Text;
_dalEmpLeaveDAL.Approve(_htParameters);
}
catch (Exception ex)
{
Utility.ShowMessageBox(this, Utility.SAVE_DATA_FAIL_MESSAGE, ex, null);
}
}
}
}
BindGrid();
BindGridApproved();
BindGridRejected();
}
else
{
Utility.ShowMessageBox(this, "Wrong Password, or unauthorized user", null, null);
}
}
private void BindGrid()
{
EmpLeaveDAL _dalEmpLeave = null;
Hashtable _htParameters = null;
try
{
_dalEmpLeave = new EmpLeaveDAL();
_htParameters = new Hashtable();
_htParameters["p_keywords"] = txtSearch.Text;
_htParameters["p_status"] = "0";
_htParameters["p_Employee_Code"] = lblEmployee_Code.Text;
gvwList.DataSource = _dalEmpLeave.GetRowsApproval(_htParameters);
gvwList.DataBind();
}
catch (Exception ex)
{
Utility.ShowMessageBox(this, Utility.LOAD_DATA_FAIL_MESSAGE, ex, null, null);
}
}
public void btnMail_Click(object sender, EventArgs e)
{
EmpLeaveDAL _dalEmpLeave = new EmpLeaveDAL();
Hashtable _htParameters = new Hashtable();
foreach (GridViewRow row in gvwList.Rows)
{
if (row.RowType == DataControlRowType.DataRow)
{
CheckBox chb = (CheckBox)row.Cells[1].Controls[1];
if (chb.Checked)
{
try
{
_htParameters.Clear();
_htParameters["p_ID"] = Int32.Parse(gvwList.DataKeys[row.RowIndex][0].ToString());
_htParameters["p_ACT"] = "LEV";
Utility.ApplyDefaultProp(_htParameters);
if (row.Cells[8].Text != "Send")
{
_dalEmpLeave.Mail(_htParameters);
Utility.ShowMessageBox(this, Utility.MAIL_SENDING_SUCCESS_MESSAGE, null, "leavelst.aspx");
}
else
{
Utility.ShowMessageBoxAnas(this, "Tidak dapat mengirim, <br>Status email saat ini sudah terkirim [send]", "Gagal");
}
}
catch (Exception ex)
{
Utility.ShowMessageBox(this, Utility.MAIL_SENDING_FAIL_MESSAGE, ex, null);
}
}
}
}
}
