protected void btnSave_Click(object sender, EventArgs e) { try { ApplicationResult objResults = new ApplicationResult(); MaterialGroupBO objMaterialGroupBO = new MaterialGroupBO(); MaterialGroupBL objMaterialGroupBL = new MaterialGroupBL(); objMaterialGroupBO.MaterialGroupName = txtMGroupName.Text; objMaterialGroupBO.Description = txtDescription.Text; objMaterialGroupBO.LastModifiedDate = DateTime.UtcNow.AddHours(5.5).ToString(); objMaterialGroupBO.LastModifiedUserID = Convert.ToInt32(Session[ApplicationSession.USERID]); int intClear = 1; if (ViewState["Mode"].ToString() == "Save") { objMaterialGroupBO.CreatedDate = DateTime.UtcNow.AddHours(5.5).ToString(); objMaterialGroupBO.CreatedUserID = Convert.ToInt32(Session[ApplicationSession.USERID]); objResults = objMaterialGroupBL.MaterialGroup_Insert(objMaterialGroupBO); if (objResults.status == ApplicationResult.CommonStatusType.SUCCESS) { intClear = 1; ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script language='javascript'>alert('Material Group Created Successfully.');</script>"); } else { intClear = 0; ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script language='JavaScript'>alert('Material Group is already exist.');</script>"); } } else if (ViewState["Mode"].ToString() == "Edit") { objMaterialGroupBO.MaterialGroupID = Convert.ToInt32(ViewState["MaterialGroupID"].ToString()); objResults = objMaterialGroupBL.MaterialGroup_Update(objMaterialGroupBO); if (objResults.status == ApplicationResult.CommonStatusType.SUCCESS) { intClear = 1; ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script language='JavaScript'>alert('Material Group updated successfully.');</script>"); } else { intClear = 0; ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script language='JavaScript'>alert('Material Group is already exist.');</script>"); } } if (intClear == 1) { ClearAll(); GridDataBind(); PanelGrid_VisibilityMode(1); } else { txtMGroupName.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 MaterialGroup in tbl_MaterialGroup_M table /// Created By : Chintan, 10/7/2014 /// Modified By : /// </summary> /// <param name="objMaterialGroupBO"></param> /// <returns></returns> public ApplicationResult MaterialGroup_Update(MaterialGroupBO objMaterialGroupBO) { try { pSqlParameter = new SqlParameter[8]; pSqlParameter[0] = new SqlParameter("@MaterialGroupID", SqlDbType.Int); pSqlParameter[0].Direction = ParameterDirection.Input; pSqlParameter[0].Value = objMaterialGroupBO.MaterialGroupID; pSqlParameter[1] = new SqlParameter("@MaterialGroupName", SqlDbType.VarChar); pSqlParameter[1].Direction = ParameterDirection.Input; pSqlParameter[1].Value = objMaterialGroupBO.MaterialGroupName; pSqlParameter[2] = new SqlParameter("@Description", SqlDbType.VarChar); pSqlParameter[2].Direction = ParameterDirection.Input; pSqlParameter[2].Value = objMaterialGroupBO.Description; pSqlParameter[3] = new SqlParameter("@IsDeleted", SqlDbType.Int); pSqlParameter[3].Direction = ParameterDirection.Input; pSqlParameter[3].Value = objMaterialGroupBO.IsDeleted; pSqlParameter[4] = new SqlParameter("@CreatedUserID", SqlDbType.Int); pSqlParameter[4].Direction = ParameterDirection.Input; pSqlParameter[4].Value = objMaterialGroupBO.CreatedUserID; pSqlParameter[5] = new SqlParameter("@CreatedDate", SqlDbType.VarChar); pSqlParameter[5].Direction = ParameterDirection.Input; pSqlParameter[5].Value = objMaterialGroupBO.CreatedDate; pSqlParameter[6] = new SqlParameter("@LastModifiedUserID", SqlDbType.Int); pSqlParameter[6].Direction = ParameterDirection.Input; pSqlParameter[6].Value = objMaterialGroupBO.LastModifiedUserID; pSqlParameter[7] = new SqlParameter("@LastModifiedDate", SqlDbType.VarChar); pSqlParameter[7].Direction = ParameterDirection.Input; pSqlParameter[7].Value = objMaterialGroupBO.LastModifiedDate; sSql = "usp_tbl_MaterialGroup_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 { objMaterialGroupBO = null; } }