protected void btnSave_Click(object sender, EventArgs e) { PayItemBo objPayItemBo = new PayItemBo(); ApplicationResult objResults = new ApplicationResult(); PayItemBl objPayItemBl = new PayItemBl(); Controls objControls = new Controls(); objPayItemBo.TrustMID = Convert.ToInt32(Session[ApplicationSession.TRUSTID]); objPayItemBo.Name = txtPayItemName.Text; objPayItemBo.Description = txtPayItemDescription.Text; objPayItemBo.Type = Convert.ToInt32(rdEraningDeductionList.SelectedValue); if (rdEraningDeductionList.SelectedValue != "0") { objPayItemBo.Deduction = Convert.ToInt32(rbtnDeduction.SelectedValue); } objPayItemBo.LastModifiedDate = DateTime.UtcNow.AddHours(5.5).ToString(); objPayItemBo.LastModifiedUserID = Convert.ToInt32(Session[ApplicationSession.USERID]); if (ViewState["Mode"].ToString() == "Save") { objPayItemBo.CreatedDate = DateTime.UtcNow.AddHours(5.5).ToString(); objPayItemBo.CreatedUserID = Convert.ToInt32(Session[ApplicationSession.USERID]); objResults = objPayItemBl.PayItem_Insert(objPayItemBo); if (objResults.status == ApplicationResult.CommonStatusType.SUCCESS) { ClearAll(); ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script language='javascript'>alert('Pay Item Created Successfully.');</script>"); GridDataBind(); PanelGrid_VisibilityMode(1); } else { ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script language='javascript'>alert('Pay Item already Exists.');</script>"); } } else { objPayItemBo.PayItemMID = Convert.ToInt32(ViewState["PayItemMID"].ToString()); objResults = objPayItemBl.PayItem_Update(objPayItemBo); if (objResults.status == ApplicationResult.CommonStatusType.SUCCESS) { ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script language='JavaScript'>alert('Pay Item updated successfully.');</script>"); GridDataBind(); ClearAll(); //objControls.ClearForm(Master.FindControl("ContentPlaceHolder1")); ViewState["Mode"] = "Save"; btnSave.Text = "Save"; } else { ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script language='javascript'>alert('Pay Item already Exists.');</script>"); } } }
/// <summary> /// To Update details of PayItem in tbl_PayItem_M table /// Created By : NafisaMulla, 09-04-2015 /// Modified By : /// </summary> /// <param name="objPayItemBO"></param> /// <returns></returns> public ApplicationResult PayItem_Update(PayItemBo objPayItemBO) { try { pSqlParameter = new SqlParameter[11]; pSqlParameter[0] = new SqlParameter("@PayItemMID", SqlDbType.Int); pSqlParameter[0].Direction = ParameterDirection.Input; pSqlParameter[0].Value = objPayItemBO.PayItemMID; pSqlParameter[1] = new SqlParameter("@TrustMID", SqlDbType.Int); pSqlParameter[1].Direction = ParameterDirection.Input; pSqlParameter[1].Value = objPayItemBO.TrustMID; pSqlParameter[2] = new SqlParameter("@Name", SqlDbType.VarChar); pSqlParameter[2].Direction = ParameterDirection.Input; pSqlParameter[2].Value = objPayItemBO.Name; pSqlParameter[3] = new SqlParameter("@Description", SqlDbType.VarChar); pSqlParameter[3].Direction = ParameterDirection.Input; pSqlParameter[3].Value = objPayItemBO.Description; pSqlParameter[4] = new SqlParameter("@Type", SqlDbType.Int); pSqlParameter[4].Direction = ParameterDirection.Input; pSqlParameter[4].Value = objPayItemBO.Type; pSqlParameter[5] = new SqlParameter("@Deduction", SqlDbType.Int); pSqlParameter[5].Direction = ParameterDirection.Input; pSqlParameter[5].Value = objPayItemBO.Deduction; pSqlParameter[6] = new SqlParameter("@IsDeleted", SqlDbType.Int); pSqlParameter[6].Direction = ParameterDirection.Input; pSqlParameter[6].Value = objPayItemBO.IsDeleted; pSqlParameter[7] = new SqlParameter("@CreatedUserID", SqlDbType.Int); pSqlParameter[7].Direction = ParameterDirection.Input; pSqlParameter[7].Value = objPayItemBO.CreatedUserID; pSqlParameter[8] = new SqlParameter("@CreatedDate", SqlDbType.VarChar); pSqlParameter[8].Direction = ParameterDirection.Input; pSqlParameter[8].Value = objPayItemBO.CreatedDate; pSqlParameter[9] = new SqlParameter("@LastModifiedUserID", SqlDbType.Int); pSqlParameter[9].Direction = ParameterDirection.Input; pSqlParameter[9].Value = objPayItemBO.LastModifiedUserID; pSqlParameter[10] = new SqlParameter("@LastModifiedDate", SqlDbType.VarChar); pSqlParameter[10].Direction = ParameterDirection.Input; pSqlParameter[10].Value = objPayItemBO.LastModifiedDate; sSql = "usp_tbl_PayItem_M_Update"; int iResult = Database.ExecuteNonQuery(CommandType.StoredProcedure, sSql, pSqlParameter); if (iResult > 0) { ApplicationResult objResults = new ApplicationResult(); objResults.status = ApplicationResult.CommonStatusType.SUCCESS; return(objResults); } else { ApplicationResult objResults = new ApplicationResult(); objResults.status = ApplicationResult.CommonStatusType.FAILURE; return(objResults); } } catch (Exception ex) { throw ex; } finally { objPayItemBO = null; } }