//-------------------------- asfor Cost 20161215_Anas ------------------------------------------- private void BindGridPopUpCost() { LStblGradeCostDAL _dalLStblGradeCostDAL = null; Hashtable _htParameters = null; try { _dalLStblGradeCostDAL = new LStblGradeCostDAL(); _htParameters = new Hashtable(); _htParameters["p_keywords"] = txtSearchCost.Text; _htParameters["p_Employee_Code"] = txtEmployee_Code.Text; //string abc = Session[SessionKey.CURRENT_USER_HRMS_ROLE].ToString(); //if (Session[SessionKey.CURRENT_USER_HRMS_ROLE].ToString() == "1") //{ // _htParameters["p_Employee_Code"] = Session[SessionKey.CURRENT_USER_HRMS_EMP_CODE].ToString(); //} gvwListCost.DataSource = _dalLStblGradeCostDAL.GetRowsbyGrade(_htParameters); gvwListCost.DataBind(); } catch (Exception ex) { Utility.ShowMessageBox(this, Utility.LOAD_DATA_FAIL_MESSAGE, ex, null, null); } }
protected void btnSave_Click(object sender, EventArgs e) { LStblGradeCostDAL _dalLStblGradeCostDAL = null; Hashtable _htParameters = null; int iNextID = 0; string message = ""; try { foreach (GridViewRow row in gvwList.Rows) { if (row.RowType == DataControlRowType.DataRow) { string p_GradeCode = row.Cells[1].Text; string p_ID = (row.Cells[3].FindControl("lblID") as Label).Text; string p_Cost = (row.Cells[3].FindControl("txtCost") as TextBox).Text; _dalLStblGradeCostDAL = new LStblGradeCostDAL(); _htParameters = new Hashtable(); _htParameters["p_GradeCode"] = p_GradeCode; _htParameters["p_CostCode"] = ddlCostCode.SelectedValue; _htParameters["p_Cost"] = double.Parse(string.IsNullOrEmpty(p_Cost) ? "0" : p_Cost); if (p_ID == "") { Utility.ApplyDefaultProp(_htParameters); _dalLStblGradeCostDAL.Insert(_htParameters, ref iNextID); message = "Add Successfully "; } else { _htParameters["p_ID"] = p_ID; Utility.ApplyDefaultProp(_htParameters); _dalLStblGradeCostDAL.Update(_htParameters); message = "Update Successfully"; } if (message != "") { Utility.ShowMessageBoxAnas(Page, message, "Success"); } } } } catch (Exception ex) { Utility.ShowMessageBox(this, Utility.LOAD_DATA_FAIL_MESSAGE, ex, null, null); } }
private void BindGrid() { LStblGradeCostDAL _dalLStblGradeCostDAL = null; Hashtable _htParameters = null; try { _dalLStblGradeCostDAL = new LStblGradeCostDAL(); _htParameters = new Hashtable(); _htParameters["p_keywords"] = txtSearch.Text; _htParameters["p_CostType"] = ddlCostCode.SelectedValue; gvwList.DataSource = _dalLStblGradeCostDAL.GetRows(_htParameters); gvwList.DataBind(); } catch (Exception ex) { Utility.ShowMessageBox(this, Utility.LOAD_DATA_FAIL_MESSAGE, ex, null, null); } }