private void SaveData(int id, string masuk, string pulang, string nik, string TglAbsen, string keterangan)
{
HR_ABSENSI_DAL _dalHR_ABSENSI = null;
Hashtable _htParameters = null;
Hashtable _htParameters2 = null;
Hashtable _htParameters3 = null;
int isInsert = 0;
try
{
_dalHR_ABSENSI = new HR_ABSENSI_DAL();
_htParameters = new Hashtable();
_htParameters2 = new Hashtable();
_htParameters3 = new Hashtable();
_htParameters["p_id"] = id;
_htParameters["p_masuk"] = masuk;
_htParameters["p_pulang"] = pulang;
_htParameters["p_Keterangan"] = keterangan;
//if (cbShift.Checked)
// _htParameters["p_IS_SHIFT"] = "1";
//else
// _htParameters["p_IS_SHIFT"] = "0";
//Parameter Cek Insert
_htParameters2["p_NIK"] = nik;
_htParameters2["p_TANGGAL_ABSEN"] = TglAbsen;
//Parameter Insert
_htParameters3["p_NIK"] = nik;
_htParameters3["p_TANGGAL_ABSEN"] = TglAbsen;
_htParameters3["p_IN_TIME"] = "07:00";
_htParameters3["p_OUT_TIME"] = "15:00";
_htParameters3["p_ATTEND_TIME"] = (keterangan == "" ? masuk : ""); //"";
_htParameters3["p_LEAVE_TIME"] = (keterangan == "" ? pulang : ""); //"";
_htParameters3["p_KODE_JENIS_SHIFT"] = "1";
_htParameters3["p_ABNORMAL"] = (keterangan == "" ? "Normal" : "Absence"); //"Absence";
_htParameters3["p_WORK_TIME"] = 0;
_htParameters3["p_Keterangan"] = keterangan;
Utility.ApplyDefaultProp(_htParameters3);
_dalHR_ABSENSI.InsertCek(_htParameters2, ref isInsert);
if (isInsert == 0)
{
_dalHR_ABSENSI.Insert(_htParameters3);
}
else
{
_dalHR_ABSENSI.UpdateRekap(_htParameters);
}
}
catch (Exception ex)
{
Utility.ShowMessageBox(this, Utility.SAVE_DATA_FAIL_MESSAGE, ex, null);
}
}
protected void gvwList_RowCommand(object sender, GridViewCommandEventArgs e)
{
switch (e.CommandName)
{
case "Edit":
Response.Redirect("cutidtl.aspx?action=edt&id=" + e.CommandArgument);
break;
case "Delete":
HR_CUTI_PEGAWAI_DAL _dalHR_CUTI_PEGAWAI_DAL = null;
HR_ABSENSI_DAL _dalHR_ABSENSI = null;
Hashtable _htParameters = null;
Hashtable _htParameters2 = null;
try
{
_dalHR_CUTI_PEGAWAI_DAL = new HR_CUTI_PEGAWAI_DAL();
_dalHR_ABSENSI = new HR_ABSENSI_DAL();
_htParameters = new Hashtable();
_htParameters2 = new Hashtable();
_htParameters["p_ID"] = e.CommandArgument.ToString();
DataTable _dt = _dalHR_CUTI_PEGAWAI_DAL.GetRow(_htParameters); //TotDay
for (int i = 0; i < Convert.ToInt16(_dt.Rows[0]["TotDay"]); i++)
{
//Parameter Insert
_htParameters2["p_NIK"] = _dt.Rows[0]["NIK"].ToString();
_htParameters2["p_TANGGAL_ABSEN"] = Convert.ToDateTime(_dt.Rows[0]["StartDate"].ToString()).AddDays(i);
_dalHR_ABSENSI.DeleteAbsensi(_htParameters2);
}
_dalHR_CUTI_PEGAWAI_DAL.Delete(_htParameters);
this.BindGrid();
Response.Redirect("cutilist.aspx");
}
catch (Exception ex)
{
Utility.ShowMessageBox(this, Utility.LOAD_DATA_FAIL_MESSAGE, ex, null);
}
break;
}
}
private void BindGrid()
{
HR_ABSENSI_DAL _dalHR_ABSENSI = null;
Hashtable _htParameters = null;
try
{
_dalHR_ABSENSI = new HR_ABSENSI_DAL();
_htParameters = new Hashtable();
_htParameters["p_keywords"] = txtSearch.Text;
gvwList.DataSource = _dalHR_ABSENSI.GetRows(_htParameters);
gvwList.DataBind();
}
catch (Exception ex)
{
Utility.ShowMessageBox(this, Utility.LOAD_DATA_FAIL_MESSAGE, ex, null, null);
}
}
private void BindGrid()
{
HR_ABSENSI_DAL _dalHR_ABSENSI = null;
Hashtable _htParameters = null;
try
{
_dalHR_ABSENSI = new HR_ABSENSI_DAL();
_htParameters = new Hashtable();
_htParameters["p_nik"] = Session["nik_absen"].ToString();
_htParameters["p_TanggalAbsen"] = Session["tgl_absen"].ToString();
gvwList.DataSource = _dalHR_ABSENSI.GetRowRekapDetail(_htParameters);
gvwList.DataBind();
}
catch (Exception ex)
{
Utility.ShowMessageBox(this, Utility.LOAD_DATA_FAIL_MESSAGE, ex, null, null);
}
}
private void LoadData()
{
HR_ABSENSI_DAL _dalHR_ABSENSI = null;
Hashtable _htParameters = null;
try
{
_dalHR_ABSENSI = new HR_ABSENSI_DAL();
_htParameters = new Hashtable();
_htParameters["p_nik"] = Session["nik_absen"].ToString();
DataTable _dt = _dalHR_ABSENSI.GetRowShift(_htParameters);
if (_dt.Rows[0]["is_shift"].ToString() == "1")
{
cbShift.Checked = true;
}
}
catch (Exception ex)
{
Utility.ShowMessageBox(this, Utility.LOAD_DATA_FAIL_MESSAGE, ex, null);
}
}
private void BindGrid()
{
DataTable dt = new DataTable();
HR_ABSENSI_DAL _dalHR_ABSENSI = null;
Hashtable _htParameters = null;
Hashtable _htParameters2 = null;
string year = ddlYear.SelectedValue;
string month = ddlMonth.SelectedValue;
try
{
_dalHR_ABSENSI = new HR_ABSENSI_DAL();
_htParameters = new Hashtable();
_htParameters2 = new Hashtable();
_htParameters["p_TANGGAL_ABSEN1"] = year + "-" + month + "-21";
tgl1 = year + "-" + month + "-21";
tanggal1 = "21" + "-" + month + "-" + year;
if (Convert.ToInt16(month) + 1 == 13)
{
month = "01"; year = (Convert.ToInt16(year) + 1).ToString();
}
else
{
month = (Convert.ToInt16(month) + 1).ToString();
}
_htParameters["p_TANGGAL_ABSEN2"] = year + "-" + month + "-20";
tgl2 = year + "-" + month + "-20";
if (Convert.ToInt16(month) < 10)
{
tanggal2 = "20" + "-0" + month + "-" + year;
}
else
{
tanggal2 = "20" + "-" + month + "-" + year;
}
_htParameters["p_KODE_UNIT_KERJA"] = ddlUnitKerja.SelectedValue.ToString();
gvwList.DataSource = dt = _dalHR_ABSENSI.GetRowsRekap(_htParameters);
gvwList.DataBind();
foreach (DataRow dr in dt.Rows)
{
_htParameters2["p_NIK"] = dr["NIK"].ToString();
_htParameters2["p_NAMA"] = dr["NAMA"].ToString();
_htParameters2["p_TANGGAL_AWAL"] = tgl1;
_htParameters2["p_TANGGAL_AKHIR"] = tgl2;
_htParameters2["p_TELAT"] = dr["TELAT"].ToString();
_htParameters2["p_PULANGCEPAT"] = dr["PULANGCEPAT"].ToString();
_htParameters2["p_HADIR"] = dr["HADIR"].ToString();
_htParameters2["p_SAKIT"] = dr["SAKIT"].ToString();
_htParameters2["p_CUTI"] = dr["CUTI"].ToString();
_htParameters2["p_IJIN"] = dr["IJIN"].ToString();
_htParameters2["p_ALPHA"] = dr["ALPHA"].ToString();
Utility.ApplyDefaultProp(_htParameters2);
_dalHR_ABSENSI.DeleteInsert(_htParameters2);
}
}
catch (Exception ex)
{
Utility.ShowMessageBox(this, Utility.LOAD_DATA_FAIL_MESSAGE, ex, null, null);
}
}
private void SaveData()
{
HR_CUTI_PEGAWAI_DAL _dalHR_CUTI_PEGAWAI_DAL = null;
HR_ABSENSI_DAL _dalHR_ABSENSI = null;
Hashtable _htParameters = null;
Hashtable _htParameters3 = null;
int iNextID = 0;
try
{
_dalHR_CUTI_PEGAWAI_DAL = new HR_CUTI_PEGAWAI_DAL();
_htParameters = new Hashtable();
_dalHR_ABSENSI = new HR_ABSENSI_DAL();
_htParameters3 = new Hashtable();
MPF23.Shared.Mapper.UIToDB.Map(pnlBody.Controls, _htParameters);
Utility.ApplyDefaultProp(_htParameters);
if (Request.Params["action"] == "edt")
{
_dalHR_CUTI_PEGAWAI_DAL.Update(_htParameters);
iNextID = Int32.Parse(lbl_ID.Text);
for (int i = 0; i < Convert.ToInt16(txtTotDay.Text); i++)
{
//Parameter Insert
_htParameters3["p_NIK"] = txtNIK.Text;
_htParameters3["p_TANGGAL_ABSEN"] = Convert.ToDateTime(conversiDate(txtStartDate.Text)).AddDays(i);
_htParameters3["p_IN_TIME"] = "07:00";
_htParameters3["p_OUT_TIME"] = "15:00";
_htParameters3["p_ATTEND_TIME"] = "";
_htParameters3["p_LEAVE_TIME"] = "";
_htParameters3["p_KODE_JENIS_SHIFT"] = "1";
_htParameters3["p_ABNORMAL"] = "Absence";
_htParameters3["p_WORK_TIME"] = 0;
_htParameters3["p_Keterangan"] = "Cuti";
Utility.ApplyDefaultProp(_htParameters3);
_dalHR_ABSENSI.DeleteInsertAbsen(_htParameters3);
}
}
else
{
_dalHR_CUTI_PEGAWAI_DAL.Insert(_htParameters, ref iNextID);
if (txtStartDate.Text == txtEndDate.Text)
{
//Parameter Insert
_htParameters3["p_NIK"] = txtNIK.Text;
_htParameters3["p_TANGGAL_ABSEN"] = conversiDate(txtStartDate.Text);
_htParameters3["p_IN_TIME"] = "07:00";
_htParameters3["p_OUT_TIME"] = "15:00";
_htParameters3["p_ATTEND_TIME"] = "";
_htParameters3["p_LEAVE_TIME"] = "";
_htParameters3["p_KODE_JENIS_SHIFT"] = "1";
_htParameters3["p_ABNORMAL"] = "Absence";
_htParameters3["p_WORK_TIME"] = 0;
_htParameters3["p_Keterangan"] = "Cuti";
Utility.ApplyDefaultProp(_htParameters3);
_dalHR_ABSENSI.Insert(_htParameters3);
}
else
{
for (int i = 0; i < Convert.ToInt16(txtTotDay.Text); i++)
{
//Parameter Insert
_htParameters3["p_NIK"] = txtNIK.Text;
_htParameters3["p_TANGGAL_ABSEN"] = Convert.ToDateTime(conversiDate(txtStartDate.Text)).AddDays(i);
_htParameters3["p_IN_TIME"] = "07:00";
_htParameters3["p_OUT_TIME"] = "15:00";
_htParameters3["p_ATTEND_TIME"] = "";
_htParameters3["p_LEAVE_TIME"] = "";
_htParameters3["p_KODE_JENIS_SHIFT"] = "1";
_htParameters3["p_ABNORMAL"] = "Absence";
_htParameters3["p_WORK_TIME"] = 0;
_htParameters3["p_Keterangan"] = "Cuti";
Utility.ApplyDefaultProp(_htParameters3);
_dalHR_ABSENSI.Insert(_htParameters3);
}
}
}
Utility.ShowMessageBox(this, Utility.SAVE_DATA_SUCCESS_MESSAGE, null, "cutidtl.aspx?action=edt&id=" + iNextID.ToString());
}
catch (Exception ex)
{
Utility.ShowMessageBox(this, Utility.SAVE_DATA_FAIL_MESSAGE, ex, null);
}
}
private void SaveData()
{
HR_ABSENSI_DAL _dalHR_ABSENSI = null;
Hashtable _htParameters = null;
Hashtable _htParameters2 = null;
string InOut = "";
string InTime = "";
string OutTime = "";
string AttendLeave = "";
string AttendTime = "";
string LeaveTime = "";
string Abnormal = "";
string Abnormal0 = "";
string Abnormal1 = "";
int isInsert = 0;
try
{
_dalHR_ABSENSI = new HR_ABSENSI_DAL();
_htParameters = new Hashtable();
_htParameters2 = new Hashtable();
foreach (DataRow dr in dtx.Select("[Column 1] <> 'Date' and [Column 1] <> 'OutTime'"))
//foreach (DataRow dr in dtx.Rows)
{
InOut = dr["Column 6"].ToString().Replace("<br>", ",");
InTime = InOut.Split(',')[0];
OutTime = InOut.Split(',')[1];
AttendLeave = dr["Column 7"].ToString().Replace("<br>", ",");
AttendTime = AttendLeave.Split(',')[0];
if (AttendTime == " ")
{
AttendTime = "";
}
LeaveTime = AttendLeave.Split(',')[1];
if (LeaveTime == " ")
{
LeaveTime = "";
}
Abnormal = dr["Column 8"].ToString().Replace("<br>", ",").Replace("<font color=#FF0000 size=2>", "").Replace("</font>", "");
if (Abnormal.Contains(","))
{
if (Abnormal.Split(',')[0] == " ")
{
Abnormal0 = Abnormal.Split(',')[1];
}
if (Abnormal.Split(',')[1] == " ")
{
Abnormal1 = Abnormal.Split(',')[0];
}
Abnormal = Abnormal0 + ";" + Abnormal1;
}
//Parameter Cek Insert
_htParameters2["p_NIK"] = dr["Column 2"].ToString().Trim();
_htParameters2["p_TANGGAL_ABSEN"] = DateTime.Now.Year.ToString() + "-" + dr["Column 1"].ToString();
//Parameter Insert
_htParameters["p_NIK"] = dr["Column 2"].ToString().Trim();
_htParameters["p_TANGGAL_ABSEN"] = DateTime.Now.Year.ToString() + "-" + dr["Column 1"].ToString();
_htParameters["p_IN_TIME"] = InTime;
_htParameters["p_OUT_TIME"] = OutTime;
_htParameters["p_ATTEND_TIME"] = AttendTime;
_htParameters["p_LEAVE_TIME"] = LeaveTime;
_htParameters["p_KODE_JENIS_SHIFT"] = dr["Column 5"].ToString().Substring(dr["Column 5"].ToString().Length - 1, 1);
_htParameters["p_ABNORMAL"] = Abnormal.Trim();
_htParameters["p_WORK_TIME"] = Convert.ToInt16(dr["Column 9"].ToString().Replace("(Min)", ""));
_htParameters["p_Keterangan"] = "";
Utility.ApplyDefaultProp(_htParameters);
Utility.ApplyDefaultProp(_htParameters2);
_dalHR_ABSENSI.InsertCek(_htParameters2, ref isInsert);
if (isInsert == 0)
{
_dalHR_ABSENSI.Insert(_htParameters);
}
}
Utility.ShowMessageBoxAnas(this, Utility.SAVE_DATA_SUCCESS_MESSAGE, "Sukses");
}
catch (Exception ex)
{
Utility.ShowMessageBox(this, Utility.SAVE_DATA_FAIL_MESSAGE, ex, null);
}
}
