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;
}
}
