private static CategoryRating loadData(DataTable returnTable) { CategoryRating currentcr = new CategoryRating(); if (returnTable.Rows.Count > 0) { DataRow returnRow = returnTable.Rows[0]; currentcr = FillObjectFromRowData(returnRow); } return(currentcr); }
public static CategoryRating GetByJNPID(long JNPID) { CategoryRating item = null; try { DataTable dataTable = ExecuteDataTable("spr_GetCategoryRatingByJNPID", JNPID); item = loadData(dataTable); } catch (Exception ex) { item = null; ExceptionBase.HandleException(ex); } return(item); }
private static CategoryRating FillObjectFromRowData(DataRow dataRow) { CategoryRating currentcr = new CategoryRating(); try { currentcr.CRID = (long)dataRow["CRID"]; currentcr.JAID = (long)dataRow["JAID"]; currentcr.PayPlanID = (int)dataRow["PayPlanID"]; currentcr.SeriesID = (int)dataRow["SeriesID"]; currentcr.LowestAdvertisedGrade = (int)dataRow["LowestAdvertisedGrade"]; currentcr.HighestAdvertisedGrade = (int)dataRow["HighestAdvertisedGrade"]; if (dataRow["IsStandardCR"] != DBNull.Value) { currentcr.IsStandardCR = (bool)dataRow["IsStandardCR"]; } if (dataRow["CreatedByID"] != DBNull.Value) { currentcr.CreatedByID = (int)dataRow["CreatedByID"]; } if (dataRow["CreateDate"] != DBNull.Value) { currentcr.CreateDate = (DateTime)dataRow["CreateDate"]; } if (dataRow["UpdatedByID"] != DBNull.Value) { currentcr.UpdatedByID = (int)dataRow["UpdatedByID"]; } if (dataRow["UpdateDate"] != DBNull.Value) { currentcr.UpdateDate = (DateTime)dataRow["UpdateDate"]; } if (dataRow["IsActive"] != DBNull.Value) { currentcr.IsActive = (bool)dataRow["IsActive"]; } } catch (Exception ex) { currentcr = null; ExceptionBase.HandleException(ex); } return(currentcr); }
// disabled this method since is not being used anywhere in the system and it adds more overhead to this object //public static long AddCategoryRating(CategoryRating currentcr) //{ // long crid = -1; // try // { // DbCommand commandWrapper = GetDbCommand("spr_CreateCategoryRating"); // SqlParameter returnParam = new SqlParameter("@newCRID", SqlDbType.BigInt); // returnParam.Direction = ParameterDirection.Output; // // get the new CRID of the record // commandWrapper.Parameters.Add(returnParam); // commandWrapper.Parameters.Add(new SqlParameter("@jAID", currentcr.JAID )); // commandWrapper.Parameters.Add(new SqlParameter("@payPlanID", currentcr.PayPlanID)); // commandWrapper.Parameters.Add (new SqlParameter("@seriesID",currentcr.SeriesID )); // commandWrapper.Parameters.Add (new SqlParameter("@LowestAdvertisedGrade",currentcr.LowestAdvertisedGrade )); // commandWrapper.Parameters.Add (new SqlParameter("@HighestAdvertisedGrade",currentcr.HighestAdvertisedGrade )); // commandWrapper.Parameters.Add (new SqlParameter("@isStandardCR",currentcr.IsStandardCR )); // commandWrapper.Parameters.Add (new SqlParameter("@createdByID",currentcr.CreatedByID )); // commandWrapper.Parameters.Add (new SqlParameter("@createDate",currentcr.CreateDate )); // commandWrapper.Parameters.Add (new SqlParameter("@updatedByID",currentcr.UpdatedByID )); // commandWrapper.Parameters.Add (new SqlParameter("@updateDate",currentcr.UpdateDate )); // ExecuteNonQuery(commandWrapper); // crid = (long)returnParam.Value; // } // catch (Exception ex) // { // HandleException(ex); // } // return crid; //} public static void UpdateCategoryRating(CategoryRating currentcr) { try { DbCommand commandWrapper = GetDbCommand("spr_UpdateCategoryRating"); commandWrapper.Parameters.Add(new SqlParameter("@cRID", currentcr.CRID)); commandWrapper.Parameters.Add(new SqlParameter("@jAID", currentcr.JAID)); commandWrapper.Parameters.Add(new SqlParameter("@payPlanID", currentcr.PayPlanID)); commandWrapper.Parameters.Add(new SqlParameter("@seriesID", currentcr.SeriesID)); commandWrapper.Parameters.Add(new SqlParameter("@LowestAdvertisedGrade", currentcr.LowestAdvertisedGrade)); commandWrapper.Parameters.Add(new SqlParameter("@HighestAdvertisedGrade", currentcr.HighestAdvertisedGrade)); commandWrapper.Parameters.Add(new SqlParameter("@isStandardCR", currentcr.IsStandardCR)); commandWrapper.Parameters.Add(new SqlParameter("@updatedByID", currentcr.UpdatedByID)); commandWrapper.Parameters.Add(new SqlParameter("@IsActive", currentcr.IsActive)); ExecuteNonQuery(commandWrapper); } catch (Exception ex) { ExceptionBase.HandleException(ex); } }
/// <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) { CategoryRating CategoryRatingobj = obj as CategoryRating; return((CategoryRatingobj == null) ? false : (this.CRID == CategoryRatingobj.CRID)); }
public static int RestoreCategoryRating(CategoryRating currentcr, int currentUserID) { return(RestoreCategoryRating(currentcr.CRID, currentUserID)); }
public static int DeleteCategoryRating(CategoryRating currentcr, int currentUserID) { return(DeleteCategoryRating(currentcr.CRID, currentUserID)); }