protected void btnSave_Click(object sender, EventArgs e)
{
try
{
ApplicationResult objResults = new ApplicationResult();
UOMBO objUOMBO = new UOMBO();
UOMBL objUOMBL = new UOMBL();
objUOMBO.UOMName = txtUnitName.Text;
objUOMBO.Description = txtDescription.Text;
objUOMBO.LastModifiedDate = DateTime.UtcNow.AddHours(5.5).ToString();
objUOMBO.LastModifiedUserId = Convert.ToInt32(Session[ApplicationSession.USERID]);
int intClear = 1;
if (ViewState["Mode"].ToString() == "Save")
{
objUOMBO.CreatedDate = DateTime.UtcNow.AddHours(5.5).ToString();
objUOMBO.CreatedUserID = Convert.ToInt32(Session[ApplicationSession.USERID]);
objResults = objUOMBL.UOM_Insert(objUOMBO);
if (objResults.status == ApplicationResult.CommonStatusType.SUCCESS)
{
intClear = 1;
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script language='javascript'>alert('UOM Created Successfully.');</script>");
}
else
{
intClear = 0;
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script language='JavaScript'>alert('Unit Name is already exist.');</script>");
}
}
else if (ViewState["Mode"].ToString() == "Edit")
{
objUOMBO.UOMID = Convert.ToInt32(ViewState["UOMID"].ToString());
objResults = objUOMBL.UOM_Update(objUOMBO);
if (objResults.status == ApplicationResult.CommonStatusType.SUCCESS)
{
intClear = 1;
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script language='JavaScript'>alert('UOM updated successfully.');</script>");
}
else
{
intClear = 0;
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script language='JavaScript'>alert('Unit Name is already exist.');</script>");
}
}
if (intClear == 1)
{
ClearAll();
GridDataBind();
}
else
{
txtUnitName.Text = "";
}
}
catch (Exception ex)
{
logger.Error("Error", ex);
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Oops! There is some technical issue. Please Contact to your administrator.');</script>");
}
}
/// <summary>
/// To Update details of UOM in tbl_UOM_M table
/// Created By : Chintan, 10/9/2014
/// Modified By :
/// </summary>
/// <param name="objUOMBO"></param>
/// <returns></returns>
public ApplicationResult UOM_Update(UOMBO objUOMBO)
{
try
{
pSqlParameter = new SqlParameter[8];
pSqlParameter[0] = new SqlParameter("@UOMID", SqlDbType.Int);
pSqlParameter[0].Direction = ParameterDirection.Input;
pSqlParameter[0].Value = objUOMBO.UOMID;
pSqlParameter[1] = new SqlParameter("@UOMName", SqlDbType.VarChar);
pSqlParameter[1].Direction = ParameterDirection.Input;
pSqlParameter[1].Value = objUOMBO.UOMName;
pSqlParameter[2] = new SqlParameter("@Description", SqlDbType.VarChar);
pSqlParameter[2].Direction = ParameterDirection.Input;
pSqlParameter[2].Value = objUOMBO.Description;
pSqlParameter[3] = new SqlParameter("@IsDeleted", SqlDbType.Int);
pSqlParameter[3].Direction = ParameterDirection.Input;
pSqlParameter[3].Value = objUOMBO.IsDeleted;
pSqlParameter[4] = new SqlParameter("@CreatedDate", SqlDbType.VarChar);
pSqlParameter[4].Direction = ParameterDirection.Input;
pSqlParameter[4].Value = objUOMBO.CreatedDate;
pSqlParameter[5] = new SqlParameter("@CreatedUserID", SqlDbType.Int);
pSqlParameter[5].Direction = ParameterDirection.Input;
pSqlParameter[5].Value = objUOMBO.CreatedUserID;
pSqlParameter[6] = new SqlParameter("@LastModifiedDate", SqlDbType.VarChar);
pSqlParameter[6].Direction = ParameterDirection.Input;
pSqlParameter[6].Value = objUOMBO.LastModifiedDate;
pSqlParameter[7] = new SqlParameter("@LastModifiedUserId", SqlDbType.Int);
pSqlParameter[7].Direction = ParameterDirection.Input;
pSqlParameter[7].Value = objUOMBO.LastModifiedUserId;
sSql = "usp_tbl_UOM_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
{
objUOMBO = null;
}
}
