public int Update(ML_CategoryGroupMaster objML_CategoryGroupMaster) { int results = 0; try { sbTraceInformation = new StringBuilder(); sbTraceInformation.Append("Entered:-Inside BusinessClasses-CategoryGroupMaster:Update(ML_CategoryGroupMaster"); sbTraceInformation.Remove(0, sbTraceInformation.Length); SqlParameter ReturnObj = new SqlParameter("@ReturnObj", ParameterDirection.Output); ReturnObj.Direction = ParameterDirection.Output; SqlParameter[] parameters = { #region Update Properties new SqlParameter("@CategoryGroupCode", objML_CategoryGroupMaster.CategoryGroupCode), new SqlParameter("@CanteenCode", objML_CategoryGroupMaster.CanteenCode), new SqlParameter("@CategoryGroupName", objML_CategoryGroupMaster.CategoryGroupName), new SqlParameter("@CategoryGroupActive", objML_CategoryGroupMaster.CategoryGroupActive), ReturnObj #endregion }; this.Parameters = parameters; SqlHelper.ExecuteNonQuery(ML_Connection.CreateConnection().ToString(), CommandType.StoredProcedure, StoredProcedure.Name.usp_UpdateCategoryGroupMaster.ToString(), this.Parameters); sbTraceInformation.Append("Exit:-From BusinessClasses-CategoryGroupMaster:Update(ML_CategoryGroupMaster"); sbTraceInformation.Remove(0, sbTraceInformation.Length); if (ReturnObj.Value != null) { results = ML_Common.string2int32(ReturnObj.Value.ToString()); } } catch (SqlException sqlExc) { int errNumber = int.MinValue; //LogManager.LogManager.WriteErrorLog(sqlExc); foreach (SqlError error in sqlExc.Errors) { errNumber = error.Number; } if (errNumber == 50000) { results = 999; throw; } } catch (Exception ex) { results = 0; Exception exc = ex;// Exception exc=ex;// LogManager.LogManager.WriteErrorLog(ex); throw; } finally { //LogManager.LogManager.WriteTraceLog(sbTraceInformation.ToString()); } return(results); }
public DataSet GetCategoryGroupMasterByLoginName(string loginName) { DataSet ds = null; try { sbTraceInformation = new StringBuilder(); sbTraceInformation.Append("Entered:-Inside BusinessClasses-CategoryGroupMaster:GetCategoryGroupMasterByLoginName(string loginName)"); sbTraceInformation.Remove(0, sbTraceInformation.Length); objML_CategoryGroupMaster = new ML_CategoryGroupMaster(); SqlParameter[] parameters = { #region Get Properties new SqlParameter("@loginName", loginName) #endregion }; this.Parameters = parameters; ds = SqlHelper.ExecuteDataset(ML_Connection.CreateConnection().ToString(), CommandType.StoredProcedure, StoredProcedure.Name.usp_GetCategoryGroupMasterByLoginName.ToString(), this.Parameters); sbTraceInformation.Append("Exit:-From BusinessClasses-CategoryGroupMaster:GetCategoryGroupMasterByLoginName(string loginName)"); sbTraceInformation.Remove(0, sbTraceInformation.Length); } catch (Exception ex) { Exception exc = ex;// Exception exc=ex;// LogManager.LogManager.WriteErrorLog(ex); throw; } finally { //LogManager.LogManager.WriteTraceLog(sbTraceInformation.ToString()); } return(ds); }
public DataSet GetCategoryGroupMasterBySeacrh(ML_CategoryGroupMaster objML_CategoryGroupMaster) { DataSet ds = null; try { sbTraceInformation = new StringBuilder(); sbTraceInformation.Append("Entered:-Inside BusinessClasses-CategoryGroupMaster:GetCategoryGroupMasterBySeacrh(ML_CategoryGroupMaster objML_CategoryGroupMaster"); sbTraceInformation.Remove(0, sbTraceInformation.Length); DateTime?dtFromdate = null; DateTime objFromdate; if (DateTime.TryParse(objML_CategoryGroupMaster.FromDate.ToString(), out objFromdate)) { if (objFromdate.ToString() != "1/1/1900 12:00:00 AM") { dtFromdate = objFromdate; } } DateTime?dtTodate = null; DateTime objdtTodate; if (DateTime.TryParse(objML_CategoryGroupMaster.ToDate.ToString(), out objdtTodate)) { if (objdtTodate.ToString() != "1/1/1900 12:00:00 AM") { dtTodate = objdtTodate; } } SqlParameter[] parameters = { #region Search Properties new SqlParameter("@CategoryGroupCode", objML_CategoryGroupMaster.CategoryGroupCode), new SqlParameter("@CanteenCode", objML_CategoryGroupMaster.CanteenCode), new SqlParameter("@CategoryGroupName", objML_CategoryGroupMaster.CategoryGroupName), new SqlParameter("@CategoryGroupActive", objML_CategoryGroupMaster.CategoryGroupActive), new SqlParameter("@FromDate", dtFromdate), new SqlParameter("@ToDate", dtTodate) #endregion }; this.Parameters = parameters; ds = SqlHelper.ExecuteDataset(ML_Connection.CreateConnection().ToString(), CommandType.StoredProcedure, StoredProcedure.Name.usp_GetCategoryGroupMasterBySearch.ToString(), this.Parameters); sbTraceInformation.Append("Exit:-From BusinessClasses-CategoryGroupMaster:GetCategoryGroupMasterBySeacrh(ML_CategoryGroupMaster objML_CategoryGroupMaster"); sbTraceInformation.Remove(0, sbTraceInformation.Length); } catch (Exception ex) { Exception exc = ex;// Exception exc=ex;// LogManager.LogManager.WriteErrorLog(ex); throw; } finally { //LogManager.LogManager.WriteTraceLog(sbTraceInformation.ToString()); } return(ds); }
public ML_CategoryGroupMaster GetCategoryGroupMasterByCategoryGroupActive(long CategoryGroupActive) { try { sbTraceInformation = new StringBuilder(); sbTraceInformation.Append("Entered:-Inside BusinessClasses-CategoryGroupMaster:GetCategoryGroupMasterById(long Id)"); sbTraceInformation.Remove(0, sbTraceInformation.Length); objML_CategoryGroupMaster = new ML_CategoryGroupMaster(); SqlParameter[] parameters = { #region Get Properties new SqlParameter("@CategoryGroupActive", CategoryGroupActive) #endregion }; this.Parameters = parameters; DataSet ds = SqlHelper.ExecuteDataset(ML_Connection.CreateConnection().ToString(), CommandType.StoredProcedure, StoredProcedure.Name.usp_GetCategoryGroupMasterByCategoryGroupActive.ToString(), this.Parameters); sbTraceInformation.Append("Exit:-From BusinessClasses-CategoryGroupMaster:GetCategoryGroupMasterById(long Id)"); sbTraceInformation.Remove(0, sbTraceInformation.Length); if (ds.Tables.Count > 0) { DataTable dt = ds.Tables[0]; if (dt.Rows.Count > 0) { DataRow dr = dt.Rows[0]; objML_CategoryGroupMaster.CategoryGroupCode = ML_Common.string2int32(ML_Common.clean(dr["CategoryGroupCode"].ToString())); objML_CategoryGroupMaster.CanteenCode = ML_Common.string2int32(ML_Common.clean(dr["CanteenCode"].ToString())); objML_CategoryGroupMaster.CategoryGroupName = ML_Common.clean(dr["CategoryGroupName"].ToString()); objML_CategoryGroupMaster.CategoryGroupActive = ML_Common.string2int32(ML_Common.clean(dr["CategoryGroupActive"].ToString())); } } } catch (Exception ex) { Exception exc = ex;// Exception exc=ex;// LogManager.LogManager.WriteErrorLog(ex); throw; } finally { //LogManager.LogManager.WriteTraceLog(sbTraceInformation.ToString()); } return(objML_CategoryGroupMaster); }
protected void btnSave_Click(object sender, EventArgs e) { if (IsValid) { errNumber = -1; try { objBusinessClass = new BusinessLayer.BusinessClass(); objML_CategoryGroupMaster = new ML_CategoryGroupMaster(); string strAdminLoginName = string.Empty; if (Session["AdminLoginName"] != null) { strAdminLoginName = Session["AdminLoginName"].ToString(); } // objML_CategoryGroupMaster.CategoryGroupCode = ML_Common.string2int32(ML_Common.clean(txtCategoryGroupCode.Text)); objML_CategoryGroupMaster.CanteenCode = ML_Common.string2int32(ML_Common.clean(txtCanteenCode.Text)); objML_CategoryGroupMaster.CategoryGroupName = ML_Common.clean(txtCategoryGroupName.Text); // objML_CategoryGroupMaster.CategoryGroupActive = ML_Common.string2int32(ML_Common.clean(txtCategoryGroupActive.Text)); // objML_CategoryGroupMaster.IsActive = ML_Common.clean(ML_Common.bit2int(chkIsActive.Checked).ToString()); // objML_CategoryGroupMaster.IsArchive = ML_Common.clean(ML_Common.bit2int(chkIsArchive.Checked).ToString()); // objML_CategoryGroupMaster.CreatedDate = ML_Common.ToDateTimeSafe(System.DateTime.Now.ToString()); // objML_CategoryGroupMaster.CreatedBy = ML_Common.clean(string.Empty); // objML_CategoryGroupMaster.ModifiedDate = ML_Common.ToDateTimeSafe(System.DateTime.Now.ToString()); // objML_CategoryGroupMaster.ModifiedBy = ML_Common.clean(string.Empty); int obhReturn = objBusinessClass.AddCategoryGroupMaster(objML_CategoryGroupMaster); if (obhReturn == 1) { lblMsg.Visible = true; lblMsg.Text = "Record Saved Successfully"; } else if (obhReturn == 2) { lblMsg.Text = "Record Already Exists!"; lblMsg.Visible = true; } } catch (SqlException sqlExc) { // LogManager.LogManager.WriteErrorLog(sqlExc); foreach (SqlError error in sqlExc.Errors) { errNumber = error.Number; } if (errNumber == 50000) { } return; } catch (Exception ex) { Exception exc = ex;// Exception exc=ex;// LogManager.LogManager.WriteErrorLog(ex); } } }