public static CategoryRatingGroup GetQuilifiedGroup(long CRID) { List <CategoryRatingGroup> groups = GetCollectionForCRID(CRID); CategoryRatingGroup group = groups.SingleOrDefault(g => g.ScoringRangeGroupTypeID == (int)enumScoringRangeGroupType.Qualified); return(group); }
public static long Add(CategoryRatingGroup crGroup, int userID) { long crGroupid = -1; try { DbCommand commandWrapper = GetDbCommand("spr_AddCategoryRatingGroup"); SqlParameter returnParam = new SqlParameter("@CategoryRatingGroupID", SqlDbType.BigInt); returnParam.Direction = ParameterDirection.Output; // get the new CRID of the record commandWrapper.Parameters.Add(returnParam); commandWrapper.Parameters.Add(new SqlParameter("@CRID", crGroup.CRID)); commandWrapper.Parameters.Add(new SqlParameter("@ScoringRangeGroupTypeID", crGroup.ScoringRangeGroupTypeID)); commandWrapper.Parameters.Add(new SqlParameter(" @ScoringRangeGroupTypeName", crGroup.ScoringRangeGroupTypeName)); commandWrapper.Parameters.Add(new SqlParameter("@RangeMin", crGroup.RangeMin)); commandWrapper.Parameters.Add(new SqlParameter("@RangeMax", crGroup.RangeMax)); commandWrapper.Parameters.Add(new SqlParameter("@RangeMax", crGroup.RangeMax)); commandWrapper.Parameters.Add(new SqlParameter("@QualifyingStatements", crGroup.QualifyingStatements)); commandWrapper.Parameters.Add(new SqlParameter("@userID", userID)); ExecuteNonQuery(commandWrapper); crGroupid = (long)returnParam.Value; } catch (Exception ex) { HandleException(ex); } return(crGroupid); }
private static CategoryRatingGroup loadData(DataTable returnTable) { CategoryRatingGroup currentcrgroup = new CategoryRatingGroup(); if (returnTable.Rows.Count > 0) { DataRow returnRow = returnTable.Rows[0]; currentcrgroup = FillObjectFromRowData(returnRow); } return(currentcrgroup); }
public static void Delete(CategoryRatingGroup crGroup, int userID) { DbCommand commandWrapper = GetDbCommand("spr_DeleteCategoryRatingGroup"); try { commandWrapper.Parameters.Add(new SqlParameter("@CategoryRatingGroupID", crGroup.CategoryRatingGroupID)); commandWrapper.Parameters.Add(new SqlParameter("@CRID", crGroup.CRID)); commandWrapper.Parameters.Add(new SqlParameter("@userID", userID)); ExecuteNonQuery(commandWrapper); } catch (Exception ex) { HandleException(ex); } }
public static CategoryRatingGroup GetByID(long CategoryRatingGroupID) { CategoryRatingGroup item = null; try { DataTable dataTable = ExecuteDataTable("spr_GetCategoryRatingGroupByID", CategoryRatingGroupID); item = loadData(dataTable); } catch (Exception ex) { item = null; ExceptionBase.HandleException(ex); } return(item); }
public static void Update(CategoryRatingGroup crGroup, int userID) { try { DbCommand commandWrapper = GetDbCommand("spr_UpdateCategoryRatingGroup"); commandWrapper.Parameters.Add(new SqlParameter("@CategoryRatingGroupID", crGroup.CategoryRatingGroupID)); commandWrapper.Parameters.Add(new SqlParameter("@CRID", crGroup.CRID)); commandWrapper.Parameters.Add(new SqlParameter("@ScoringRangeGroupTypeID", crGroup.ScoringRangeGroupTypeID)); commandWrapper.Parameters.Add(new SqlParameter("@ScoringRangeGroupTypeName", crGroup.ScoringRangeGroupTypeName)); commandWrapper.Parameters.Add(new SqlParameter("@RangeMin", crGroup.RangeMin)); commandWrapper.Parameters.Add(new SqlParameter("@RangeMax", crGroup.RangeMax)); commandWrapper.Parameters.Add(new SqlParameter("@QualifyingStatements", crGroup.QualifyingStatements)); commandWrapper.Parameters.Add(new SqlParameter("@userID", userID)); ExecuteNonQuery(commandWrapper); } catch (Exception ex) { HandleException(ex); } }
private static List <CategoryRatingGroup> GetCollection(DataTable table) { List <CategoryRatingGroup> list = new List <CategoryRatingGroup>(); try { if (table != null) { for (int i = 0; i < table.Rows.Count; i++) { CategoryRatingGroup item = FillObjectFromRowData(table.Rows[i]); list.Add(item); } } } catch (Exception ex) { HandleException(ex); } return(list); }
private static CategoryRatingGroup FillObjectFromRowData(DataRow dataRow) { CategoryRatingGroup crgroup = new CategoryRatingGroup(); try { crgroup.CategoryRatingGroupID = (long)dataRow["CategoryRatingGroupID"]; crgroup.CRID = (long)dataRow["CRID"]; crgroup.ScoringRangeGroupTypeID = (int)dataRow["ScoringRangeGroupTypeID"]; crgroup.ScoringRangeGroupTypeName = (string)dataRow["ScoringRangeGroupTypeName"]; crgroup.RangeMin = (int)dataRow["RangeMin"]; crgroup.RangeMax = (int)dataRow["RangeMax"]; if (dataRow["QualifyingStatements"] != DBNull.Value) { crgroup.QualifyingStatements = (string)dataRow["QualifyingStatements"]; } } catch (Exception ex) { crgroup = null; ExceptionBase.HandleException(ex); } return(crgroup); }
/// <summary> /// Determines whether the specified System.Object is equal to the current object. /// </summary> /// <param name="obj">The System.Object to compare with the current object.</param> /// <returns>Returns true if the specified System.Object is equal to the current object; otherwise, false.</returns> public override bool Equals(Object obj) { CategoryRatingGroup CategoryRatingGroupobj = obj as CategoryRatingGroup; return((CategoryRatingGroupobj == null) ? false : (this.CategoryRatingGroupID == CategoryRatingGroupobj.CategoryRatingGroupID)); }