protected void gvwList_RowCommand(object sender, GridViewCommandEventArgs e) { switch (e.CommandName) { case "Edit": Response.Redirect("appspddtl.aspx?action=edt&id=" + e.CommandArgument); break; case "Delete": EmpSPDDAL _dalEmpSPD = null; Hashtable _htParameters = null; try { _dalEmpSPD = new EmpSPDDAL(); _htParameters = new Hashtable(); _htParameters["p_ID"] = e.CommandArgument.ToString(); _dalEmpSPD.Delete(_htParameters); this.BindGrid(); Response.Redirect("appspdlst.aspx"); } catch (Exception ex) { Utility.ShowMessageBox(this, Utility.LOAD_DATA_FAIL_MESSAGE, ex, null, null); } break; } }
//-------------------------- asfor SPD 20161215_Anas ------------------------------------------- private void BindGridPopUp() { EmpSPDDAL _dalEmpSPD = null; Hashtable _htParameters = null; try { _dalEmpSPD = new EmpSPDDAL(); _htParameters = new Hashtable(); _htParameters["p_keywords"] = txtSearchSPD.Text; _htParameters["p_status"] = "3"; if (Session[SessionKey.CURRENT_USER_HRMS_ROLE].ToString() == "1") { _htParameters["p_Employee_Code"] = Session[SessionKey.CURRENT_USER_HRMS_EMP_CODE].ToString(); } gvwListSPD.DataSource = _dalEmpSPD.GetRowsForClaim(_htParameters); gvwListSPD.DataBind(); } catch (Exception ex) { Utility.ShowMessageBox(this, Utility.LOAD_DATA_FAIL_MESSAGE, ex, null, null); } }
private void BindGrid() { EmpSPDDAL _dalEmpSPD = null; Hashtable _htParameters = null; try { _dalEmpSPD = new EmpSPDDAL(); _htParameters = new Hashtable(); _htParameters["p_keywords"] = txtSearch.Text; _htParameters["p_status"] = "0"; _htParameters["p_Employee_Code"] = lblEmployee_Code.Text; gvwList.DataSource = _dalEmpSPD.GetRowsApproval(_htParameters); gvwList.DataBind(); if (Session[SessionKey.CURRENT_USER_HRMS_ROLE].ToString() == "2") { btnApprove.Visible = true; btnReject.Visible = true; } else { btnApprove.Visible = false; btnReject.Visible = false; } } catch (Exception ex) { Utility.ShowMessageBox(this, Utility.LOAD_DATA_FAIL_MESSAGE, ex, null, null); } }
private void LoadData() { EmpSPDDAL _dalEmpSPDDAL = null; Hashtable _htParameters = null; try { _dalEmpSPDDAL = new EmpSPDDAL(); _htParameters = new Hashtable(); if (Request.Params["action"] == "edt") { _htParameters["p_ID"] = Request.Params["id"]; pnlshow.Visible = true; DataTable _dt = _dalEmpSPDDAL.GetRow(_htParameters); MPF23.Shared.Mapper.DBToUI.Map(pnlBody.Controls, _dt.Rows[0]); MPF23.Shared.Mapper.DBToUI.Map(pnlBody1.Controls, _dt.Rows[0]); LoadDataTask(); LoadDataCost(); } } catch (Exception ex) { Utility.ShowMessageBox(this, Utility.LOAD_DATA_FAIL_MESSAGE, ex, null); } }
private void SaveData() { EmpSPDDAL _dalEmpSPDDAL = null; Hashtable _htParameters = null; int iNextID = 0; try { _dalEmpSPDDAL = new EmpSPDDAL(); _htParameters = new Hashtable(); MPF23.Shared.Mapper.UIToDB.Map(pnlBody.Controls, _htParameters); Utility.ApplyDefaultProp(_htParameters); MPF23.Shared.Mapper.UIToDB.Map(pnlBody1.Controls, _htParameters); if (Request.Params["action"] == "edt") { //string abc = lbl_ID.Text; _dalEmpSPDDAL.Update(_htParameters); iNextID = Int32.Parse(lbl_ID.Text); } else { _htParameters["p_Employee_Code"] = txtEmployee_Code.Text; _dalEmpSPDDAL.Insert(_htParameters, ref iNextID); } Utility.ShowMessageBox(this, Utility.SAVE_DATA_SUCCESS_MESSAGE, null, "SPDdtl.aspx?action=edt&id=" + iNextID.ToString()); //Utility.ShowMessageBox(this, Utility.SAVE_DATA_SUCCESS_MESSAGE, null, "spddtl.aspx?action=edt&page=0&id=" + Request.Params["id"]); } catch (Exception ex) { Utility.ShowMessageBox(this, Utility.SAVE_DATA_FAIL_MESSAGE, ex, null); } }
public static void Bind_HRMS_PopUp_SPD(string refName, GridView gvw, string parameternya) { try { var dal = new EmpSPDDAL(); var htParameters = new Hashtable(); var tableName = refName; htParameters["p_keywords"] = parameternya; gvw.DataSource = dal.GetRows(htParameters); gvw.DataBind(); } catch (Exception ex) { throw ex; } }
private void Approve_SPD(GridView grv) { mdlPopupApproveValidate.Hide(); if (approvemtd(txtPassword.Text) == 1) { EmpSPDDAL _dalEmpSPDDAL = new EmpSPDDAL(); 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; _dalEmpSPDDAL.Approve(_htParameters); } catch (Exception ex) { Utility.ShowMessageBox(this, Utility.SAVE_DATA_FAIL_MESSAGE, ex, null); } } } } BindGrid(); BindGridHRD(); BindGridApproved(); BindGridApproved2(); BindGridRejected(); } else { Utility.ShowMessageBox(this, "Wrong Password, or unauthorized user", null, null); } }
private void BindGridRejected() { EmpSPDDAL _dalEmpSPD = null; Hashtable _htParameters = null; try { _dalEmpSPD = new EmpSPDDAL(); _htParameters = new Hashtable(); _htParameters["p_keywords"] = txtSearchRejected.Text; _htParameters["p_status"] = "9"; _htParameters["p_Employee_Code"] = lblEmployee_Code.Text; gvwListRejected.DataSource = _dalEmpSPD.GetRowsApproval(_htParameters); gvwListRejected.DataBind(); } catch (Exception ex) { Utility.ShowMessageBox(this, Utility.LOAD_DATA_FAIL_MESSAGE, ex, null, null); } }
public void btnMail_Click(object sender, EventArgs e) { EmpSPDDAL _DALpelamarDAL = new EmpSPDDAL(); 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"] = "SPD"; Utility.ApplyDefaultProp(_htParameters); if (row.Cells[8].Text != "Send") { _DALpelamarDAL.Mail(_htParameters); Utility.ShowMessageBox(this, Utility.MAIL_SENDING_SUCCESS_MESSAGE, null, "spdlst.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); } BindGrid(); BindGridApproved(); BindGridApproved2(); BindGridRejected(); } } } }
private void LoadData() { EmpSPDDAL _dalEmpSPDDAL = null; Hashtable _htParameters = null; try { //System.Diagnostics.Debugger.Break(); //ddlEmployee_Code.SelectedValue = SessionKey.CURRENT_USER_HRMS_EMP_CODE.ToString(); txtSPD_Date.Text = Utility.CurrentDate; //GET ROLE Response.Write(Session[SessionKey.CURRENT_USER_HRMS_ROLE]); _dalEmpSPDDAL = new EmpSPDDAL(); _htParameters = new Hashtable(); if (Request.Params["action"] == "edt") { _htParameters["p_ID"] = Request.Params["id"]; lbl_ID.Text = Request.Params["id"]; pnlshow.Visible = true; DataTable _dt = _dalEmpSPDDAL.GetRow(_htParameters); MPF23.Shared.Mapper.DBToUI.Map(pnlBody.Controls, _dt.Rows[0]); MPF23.Shared.Mapper.DBToUI.Map(pnlBody1.Controls, _dt.Rows[0]); LoadDataTask(); LoadDataCost(); if (ddlStatus.SelectedValue == "0") { btnSave.Visible = true; btnAddTask.Visible = true; btnAddCost.Visible = true; grvTask.Columns[grvTask.Rows[0].Cells.Count - 1].Visible = true; grvTask.Columns[grvTask.Rows[0].Cells.Count - 2].Visible = true; grvCost.Columns[grvCost.Rows[0].Cells.Count - 1].Visible = true; grvCost.Columns[grvCost.Rows[0].Cells.Count - 2].Visible = true; } else { if (Session[SessionKey.CURRENT_USER_HRMS_ROLE].ToString() == "2") { btnSave.Visible = true; btnAddTask.Visible = true; btnAddCost.Visible = true; grvTask.Columns[grvTask.Rows[0].Cells.Count - 1].Visible = true; grvTask.Columns[grvTask.Rows[0].Cells.Count - 2].Visible = true; grvCost.Columns[grvCost.Rows[0].Cells.Count - 1].Visible = true; grvCost.Columns[grvCost.Rows[0].Cells.Count - 2].Visible = true; } else { btnSave.Visible = false; btnAddTask.Visible = false; btnAddCost.Visible = false; grvTask.Columns[grvTask.Rows[0].Cells.Count - 1].Visible = false; grvTask.Columns[grvTask.Rows[0].Cells.Count - 2].Visible = false; grvCost.Columns[grvCost.Rows[0].Cells.Count - 1].Visible = false; grvCost.Columns[grvCost.Rows[0].Cells.Count - 2].Visible = false; } } //if(Session[SessionKey.CURRENT_USER_HRMS_ROLE].ToString()=="2") //{ // txtCost_Value.Enabled = true; //} //else //{ // txtCost_Value.Enabled = false; //} } else { pnlshow.Visible = false; txtEmployee_Code.Text = Session[SessionKey.CURRENT_USER_HRMS_EMP_CODE].ToString().Trim(); txtEmployee_Descs.Text = Session[SessionKey.CURRENT_USER_HRMS_EMP_NAME].ToString().Trim(); } } catch (Exception ex) { Utility.ShowMessageBox(this, Utility.LOAD_DATA_FAIL_MESSAGE, ex, null); } }