public void DeleteEventRatingContext(sp_EventRating_DM InputRating) { using (VolTeerEntities context = new VolTeerEntities()) { var RatingToRemove = (from n in context.tblEventRatings where n.RatingID == InputRating.RatingID select n).FirstOrDefault(); context.tblEventRatings.Remove(RatingToRemove); context.SaveChanges(); } }
public void DeleteEventRatingContext(sp_EventRating_DM _cRating) { System.Web.Caching.Cache cache = HttpRuntime.Cache; sp_EventRating_DM cacheRating; cacheRating = (sp_EventRating_DM)cache[_cRating.RatingID.ToString()]; if (cacheRating != null) { cache.Remove(_cRating.RatingID.ToString()); } BLL.DeleteEventRatingContext(_cRating); }
public void UpdateEventRatingContext(sp_EventRating_DM _cRating) { System.Web.Caching.Cache cache = HttpRuntime.Cache; sp_EventRating_DM cacheRating; cacheRating = (sp_EventRating_DM)cache[_cRating.RatingID.ToString()]; if (cacheRating != null) { cache.Remove(_cRating.RatingID.ToString()); } cache.Insert(_cRating.RatingID.ToString(), _cRating, null, DateTime.Now.AddSeconds(60), System.Web.Caching.Cache.NoSlidingExpiration, CacheItemPriority.High, null); BLL.UpdateEventRatingContext(_cRating); }
public void TestEventRatingCreate() { DateTime StartDate = new DateTime(2014, 05, 01, 10, 0, 0); DateTime EndDate = new DateTime(2014, 05, 02, 11, 0, 0); var EventRating_bll = new sp_EventRating_BLL(); var EventRating_dm = new sp_EventRating_DM(); var Event_bll = new sp_ProjectEvent_BLL(); var allEvents = Event_bll.ListEvents(); Assert.IsTrue(allEvents.Count > 0, "The ListEventRatings() is broken, or no data in DB"); EventRating_dm.EventID = allEvents[0].EventID; EventRating_dm.ActiveFlg = true; int RatingID = EventRating_bll.InsertEventRatingContext(EventRating_dm).RatingID; EventRating_dm.RatingID = RatingID; var EventRating_dm_selected = EventRating_bll.ListEventRatings(RatingID); Assert.IsTrue(Equals(EventRating_dm, EventRating_dm_selected)); }
public sp_EventRating_DM InsertEventRatingContext(sp_EventRating_DM InputRating) { using (VolTeerEntities context = new VolTeerEntities()) { var NewEventRating = new tblEventRating { RatingID = InputRating.RatingID, EventID = InputRating.EventID, VolID = InputRating.VolID, RatingValue = InputRating.RatingValue, ActiveFlg = InputRating.ActiveFlg }; context.tblEventRatings.Add(NewEventRating); context.SaveChanges(); InputRating.RatingID = NewEventRating.RatingID; return InputRating; } }
/// <summary> /// ListEventRatings - There's a good chance the same record may be requested often. Cache the event rating object... /// /// </summary> /// <param name="EventRating"></param> /// <returns></returns> public sp_EventRating_DM ListEventRatings(int? EventRating) { sp_EventRating_DM cRating = new sp_EventRating_DM(); //Cache cache = HttpRuntime.Cache; System.Web.Caching.Cache cache = HttpRuntime.Cache; sp_EventRating_DM cacheRating; cacheRating = (sp_EventRating_DM)cache[EventRating.ToString()]; if (cacheRating == null) { cRating = BLL.ListEventRatings(EventRating); cache.Insert(cRating.RatingID.ToString(), cRating, null, DateTime.Now.AddSeconds(60), System.Web.Caching.Cache.NoSlidingExpiration, CacheItemPriority.High, null); } else { cRating = cacheRating; } return cRating; }
public void UpdateEventRatingContext(sp_EventRating_DM InputRating) { using (VolTeerEntities context = new VolTeerEntities()) { var ExistingRating = context.tblEventRatings.Find(InputRating.RatingID); if (ExistingRating != null) { ExistingRating.EventID = InputRating.EventID; ExistingRating.RatingID = InputRating.RatingID; ExistingRating.RatingValue = InputRating.RatingValue; ExistingRating.ActiveFlg = InputRating.ActiveFlg; context.SaveChanges(); } } }
public void UpdateEventRatingContext(sp_EventRating_DM _cEventRating) { DAL.UpdateEventRatingContext(_cEventRating); }
public sp_EventRating_DM InsertEventRatingContext(sp_EventRating_DM _cEventRating) { return DAL.InsertEventRatingContext(_cEventRating); }
public void DeleteEventRatingContext(sp_EventRating_DM _cEventRating) { DAL.DeleteEventRatingContext(_cEventRating); }
private static bool Equals(sp_EventRating_DM dm1, sp_EventRating_DM dm2) { return (dm1.RatingID == dm2.RatingID && dm1.EventID == dm2.EventID && dm1.VolID == dm2.VolID && dm1.RatingValue == dm2.RatingValue && dm1.ActiveFlg == dm2.ActiveFlg ); }
private static List<sp_EventRating_DM> DMsFrom(DataTable dataTable) { var DMs = new List<sp_EventRating_DM>(); for (int i = 0; i < dataTable.Rows.Count; i++) { var returnEventRating = new sp_EventRating_DM(); returnEventRating.RatingID = Convert.ToInt32(dataTable.Rows[i]["RatingID"]); returnEventRating.EventID = new Guid((String)dataTable.Rows[i]["EventID"]); returnEventRating.VolID = new Guid((String)dataTable.Rows[i]["VolID"]); returnEventRating.RatingValue = Convert.ToInt32(dataTable.Rows[i]["RatingValue"]); returnEventRating.ActiveFlg = Convert.ToBoolean(dataTable.Rows[i]["ActiveFlg"]); DMs.Add(returnEventRating); } return DMs; }
public void InsertEventRatingContext(sp_EventRating_DM _cRating) { BLL.InsertEventRatingContext(_cRating); System.Web.Caching.Cache cache = HttpRuntime.Cache; cache.Insert(_cRating.RatingID.ToString(), _cRating, null, DateTime.Now.AddSeconds(60), System.Web.Caching.Cache.NoSlidingExpiration, CacheItemPriority.High, null); }