private void LoadData()
{
HR_KONTRAK_DAL _dalHR_KONTRAK_DAL = null;
Hashtable _htParameters = null;
try
{
_dalHR_KONTRAK_DAL = new HR_KONTRAK_DAL();
_htParameters = new Hashtable();
_htParameters["p_ID"] = Request.Params["id"];
DataTable _dt = _dalHR_KONTRAK_DAL.GetRow(_htParameters);
if (_dt.Rows[0]["STATUS_PEGAWAI"].ToString() == "True")
{
cbStatus.Checked = true;
}
if (_dt.Rows[0]["is_shift"].ToString() == "1")
{
cbShift.Checked = true;
}
if (_dt.Rows[0]["is_cuti"].ToString() == "1")
{
cbCuti.Checked = true;
}
MPF23.Shared.Mapper.DBToUI.Map(pnlBody.Controls, _dt.Rows[0]);
}
catch (Exception ex)
{
Utility.ShowMessageBox(this, Utility.LOAD_DATA_FAIL_MESSAGE, ex, null);
}
}
private void SaveData()
{
HR_KONTRAK_DAL _dalHR_KONTRAK_DAL = null;
Hashtable _htParameters = null;
int iNextID = 0;
try
{
_dalHR_KONTRAK_DAL = new HR_KONTRAK_DAL();
_htParameters = new Hashtable();
_htParameters["p_DOKUMEN_PATH"] = filepath;
if (cbStatus.Checked)
{
_htParameters["p_STATUS_PEGAWAI"] = "1";
}
else
{
_htParameters["p_STATUS_PEGAWAI"] = "0";
}
if (cbShift.Checked)
{
_htParameters["p_IS_SHIFT"] = "1";
}
else
{
_htParameters["p_IS_SHIFT"] = "0";
}
if (cbCuti.Checked)
{
_htParameters["p_IS_CUTI"] = "1";
}
else
{
_htParameters["p_IS_CUTI"] = "0";
}
MPF23.Shared.Mapper.UIToDB.Map(pnlBody.Controls, _htParameters);
Utility.ApplyDefaultProp(_htParameters);
if (Request.Params["action"] == "add")
{
_dalHR_KONTRAK_DAL.Insert(_htParameters, ref iNextID);
}
else
{
_dalHR_KONTRAK_DAL.Update(_htParameters);
iNextID = Int32.Parse(lblID.Text);
}
Utility.ShowMessageBox(this, Utility.SAVE_DATA_SUCCESS_MESSAGE, null, "kontrakdtl.aspx?action=edt&id=" + iNextID.ToString());
}
catch (Exception ex)
{
Utility.ShowMessageBox(this, Utility.SAVE_DATA_FAIL_MESSAGE, ex, null);
}
}
private void BindGrid()
{
HR_KONTRAK_DAL _dalHR_KONTRAK_DAL = null;
Hashtable _htParameters = null;
try
{
_dalHR_KONTRAK_DAL = new HR_KONTRAK_DAL();
_htParameters = new Hashtable();
_htParameters["p_keywords"] = txtSearch.Text;
gvwList.DataSource = _dalHR_KONTRAK_DAL.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)
{
int rowIndex = Convert.ToInt32(e.CommandArgument) - 1;
string p_ID = gvwList.DataKeys[rowIndex].Values[1].ToString();
switch (e.CommandName)
{
case "Edit":
Response.Redirect("kontrakdtl.aspx?action=edt&id=" + p_ID);
break;
case "Delete":
HR_KONTRAK_DAL _dalHR_KONTRAK_DAL = null;
Hashtable _htParameters = null;
try
{
string filename = gvwList.DataKeys[rowIndex].Values[2].ToString();
string savefile = Path.Combine(Server.MapPath("~/FileAttachments/"), filename);
_dalHR_KONTRAK_DAL = new HR_KONTRAK_DAL();
_htParameters = new Hashtable();
_htParameters["p_ID"] = p_ID;
_dalHR_KONTRAK_DAL.Delete(_htParameters);
if (System.IO.File.Exists(savefile))
{
System.IO.File.Delete(savefile);
}
this.BindGrid();
Response.Redirect("kontraklist.aspx");
}
catch (Exception ex)
{
Utility.ShowMessageBox(this, Utility.LOAD_DATA_FAIL_MESSAGE, ex, null);
}
break;
}
}
