private void LoadData() { EmpExclaimDAL _dalEmpExclaimDAL = null; Hashtable _htParameters = null; try { //System.Diagnostics.Debugger.Break(); //ddlSPD_Code.SelectedValue = SessionKey.CURRENT_USER_HRMS_EMP_CODE.ToString(); txtTrx_Date.Text = Utility.CurrentDate; //GET ROLE Response.Write(Session[SessionKey.CURRENT_USER_HRMS_ROLE]); _dalEmpExclaimDAL = new EmpExclaimDAL(); _htParameters = new Hashtable(); if (Request.Params["action"] == "edt") { _htParameters["p_ID"] = Request.Params["id"]; pnlshow.Visible = true; panelDetail.Visible = false; DataTable _dt = _dalEmpExclaimDAL.GetRow(_htParameters); MPF23.Shared.Mapper.DBToUI.Map(pnlBody.Controls, _dt.Rows[0]); BindGridClaim(); if (ddlStatus.SelectedValue == "0") { btnSave.Visible = true; btnAddExpenseClaimDetail.Visible = true; grvExpenseClaimDetail.Columns[grvExpenseClaimDetail.Rows[0].Cells.Count - 1].Visible = true; grvExpenseClaimDetail.Columns[grvExpenseClaimDetail.Rows[0].Cells.Count - 2].Visible = true; } else { if (ddlStatus.SelectedValue == "1" && Session[SessionKey.CURRENT_USER_HRMS_ROLE].ToString() == "2") { btnSave.Visible = true; btnAddExpenseClaimDetail.Visible = true; grvExpenseClaimDetail.Columns[grvExpenseClaimDetail.Rows[0].Cells.Count - 1].Visible = true; grvExpenseClaimDetail.Columns[grvExpenseClaimDetail.Rows[0].Cells.Count - 2].Visible = true; } else { btnSave.Visible = false; btnAddExpenseClaimDetail.Visible = false; grvExpenseClaimDetail.Columns[grvExpenseClaimDetail.Rows[0].Cells.Count - 1].Visible = false; grvExpenseClaimDetail.Columns[grvExpenseClaimDetail.Rows[0].Cells.Count - 2].Visible = false; } } } else { pnlshow.Visible = false; //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 gvwList_RowCommand(object sender, GridViewCommandEventArgs e) { switch (e.CommandName) { case "Edit": Response.Redirect("exclaimdtl.aspx?action=edt&id=" + e.CommandArgument); break; case "Delete": EmpExclaimDAL _dalEmpExclaim = null; Hashtable _htParameters = null; try { _dalEmpExclaim = new EmpExclaimDAL(); _htParameters = new Hashtable(); _htParameters["p_ID"] = e.CommandArgument.ToString(); _dalEmpExclaim.Delete(_htParameters); this.BindGrid(); Response.Redirect("exclaimlst.aspx"); } catch (Exception ex) { Utility.ShowMessageBox(this, Utility.LOAD_DATA_FAIL_MESSAGE, ex, null, null); } break; } }
private void BindGrid() { EmpExclaimDAL _dalEmpExclaim = null; Hashtable _htParameters = null; try { _dalEmpExclaim = new EmpExclaimDAL(); _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 = _dalEmpExclaim.GetRows(_htParameters); gvwList.DataBind(); } catch (Exception ex) { Utility.ShowMessageBox(this, Utility.LOAD_DATA_FAIL_MESSAGE, ex, null, null); } }
private void Reject_Claim(GridView grv, string TabKe) { mdlPopupRejectValidate.Hide(); if (approvemtd(txtPasswordReject.Text) == 1) { int adaData = 0; EmpExclaimDAL _dalEmpExclaimDAL = new EmpExclaimDAL(); Hashtable _htParameters = new Hashtable(); foreach (GridViewRow row in grv.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(grv.DataKeys[row.RowIndex][0].ToString()); _htParameters["p_Employee_Code"] = lblEmployee_Code.Text; _dalEmpExclaimDAL.Reject(_htParameters); adaData = +1; } catch (Exception ex) { Utility.ShowMessageBox(this, Utility.REJECT_DATA_FAIL_MESSAGE, ex, null); } } } } if (adaData > 0) { Utility.ShowMessageBox(this, Utility.REJECT_DATA_SUCCESS_MESSAGE, null, "appexclaimlst.aspx?action=edt&page=" + TabKe + "&id=" + Request.Params["id"]); } } else { Utility.ShowMessageBox(this, "Wrong Password, or unauthorized user", null, null); mdlPopupRejectValidate.Hide(); } }
private void BindGridRejected() { EmpExclaimDAL _dalEmpExclaim = null; Hashtable _htParameters = null; try { _dalEmpExclaim = new EmpExclaimDAL(); _htParameters = new Hashtable(); _htParameters["p_keywords"] = txtSearchRejected.Text; _htParameters["p_status"] = "9"; _htParameters["p_Employee_Code"] = lblEmployee_Code.Text; gvwListRejected.DataSource = _dalEmpExclaim.GetRowsApproval(_htParameters); gvwListRejected.DataBind(); } catch (Exception ex) { Utility.ShowMessageBox(this, Utility.LOAD_DATA_FAIL_MESSAGE, ex, null, null); } }
private void LoadData() { EmpExclaimDAL _dalEmpExclaimDAL = null; Hashtable _htParameters = null; try { _dalEmpExclaimDAL = new EmpExclaimDAL(); _htParameters = new Hashtable(); if (Request.Params["action"] == "edt") { _htParameters["p_ID"] = Request.Params["id"]; DataTable _dt = _dalEmpExclaimDAL.GetRow(_htParameters); MPF23.Shared.Mapper.DBToUI.Map(pnlBody.Controls, _dt.Rows[0]); BindGridClaim(); } } catch (Exception ex) { Utility.ShowMessageBox(this, Utility.LOAD_DATA_FAIL_MESSAGE, ex, null); } }
private void SaveData() { EmpExclaimDAL _dalEmpExclaimDAL = null; Hashtable _htParameters = null; int iNextID = 0; try { _dalEmpExclaimDAL = new EmpExclaimDAL(); _htParameters = new Hashtable(); MPF23.Shared.Mapper.UIToDB.Map(pnlBody.Controls, _htParameters); Utility.ApplyDefaultProp(_htParameters); if (Request.Params["action"] == "edt") { string abc = lbl_ID.Text; _htParameters["p_TotalClaimAmount"] = grvExpenseClaimDetail.FooterRow.Cells[15].Text; _dalEmpExclaimDAL.Update(_htParameters); iNextID = Int32.Parse(lbl_ID.Text); } else { _htParameters["p_Employee_Code"] = txtEmployee_Code.Text; _htParameters["p_TotalClaimAmount"] = 0; _dalEmpExclaimDAL.Insert(_htParameters, ref iNextID); } Utility.ShowMessageBox(this, Utility.SAVE_DATA_SUCCESS_MESSAGE, null, "exclaimdtl.aspx?action=edt&id=" + iNextID.ToString()); //Utility.ShowMessageBox(this, Utility.SAVE_DATA_SUCCESS_MESSAGE, null, "Emppermitdtl.aspx?action=edt&id=" + iNextID.ToString()); } catch (Exception ex) { Utility.ShowMessageBox(this, Utility.SAVE_DATA_FAIL_MESSAGE, ex, null, null); } }
public void btnMail_Click(object sender, EventArgs e) { EmpExclaimDAL _dalEmpExclaimDAL = new EmpExclaimDAL(); 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"] = "EXC"; Utility.ApplyDefaultProp(_htParameters); if (row.Cells[8].Text != "Send") { _dalEmpExclaimDAL.Mail(_htParameters); Utility.ShowMessageBox(this, Utility.MAIL_SENDING_SUCCESS_MESSAGE, null, "exclaimlst.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); } } } } }