public static bool IsInitialCall(RvPreviousVisitData call) { // using (var db = new RvPreviousVisitsContext(RvPreviousVisitsContext.DBConnectionString)) { try { var qry = from x in db.RvPreviousVisitItems where x.RvItemId == call.RvItemId orderby x.Date select x; if (qry.Any()) { if (qry.Count() <= 1) { return(true); } var c = qry.ToArray().First(); if (c.ItemId == call.ItemId) { return(true); } } return(false); } catch (Exception) { return(false); } } }
/// <summary> /// Saves the call. /// </summary> /// <param name="call">The call.</param> /// <exception cref="System.ArgumentNullException">rvItemId;Rv Item Id can't be null</exception> public static bool AddOrUpdateCall(ref RvPreviousVisitData call) { if (call.RvItemId < 0) { throw new ArgumentNullException("call", "Rv Item Id can't be null"); } int itemId = call.ItemId; using (var db = new RvPreviousVisitsContext(RvPreviousVisitsContext.DBConnectionString)) { if (itemId > 0 && db.RvPreviousVisitItems.Any(s => s.ItemId == itemId)) { RvPreviousVisitItem c = db.RvPreviousVisitItems.Single(s => s.ItemId == itemId); c.RvItemId = call.RvItemId; c.Magazines = call.Magazines; c.Books = call.Books; c.Brochures = call.Brochures; c.Date = call.Date; c.Notes = call.Notes; c.Tracts = call.Tracts; db.SubmitChanges(); return(c.ItemId > 0 && ReturnVisitsInterface.UpdateLastVisitDate(call.RvItemId, call.Date)); // existing call saved. } var cc = RvPreviousVisitData.Copy(call); db.RvPreviousVisitItems.InsertOnSubmit(cc); db.SubmitChanges(); call.ItemId = cc.ItemId; return(call.ItemId >= 0 && ReturnVisitsInterface.UpdateLastVisitDate(call.RvItemId, call.Date)); } }
/// <summary> /// Saves the call. /// </summary> /// <param name="call">The call.</param> /// <exception cref="System.ArgumentNullException">rvItemId;Rv Item Id can't be null</exception> public static bool AddOrUpdateCall(ref RvPreviousVisitData call) { if (call.RvItemId < 0) throw new ArgumentNullException("call", "Rv Item Id can't be null"); int itemId = call.ItemId; using (var db = new RvPreviousVisitsContext(RvPreviousVisitsContext.DBConnectionString)) { if (itemId > 0 && db.RvPreviousVisitItems.Any(s => s.ItemId == itemId)) { RvPreviousVisitItem c = db.RvPreviousVisitItems.Single(s => s.ItemId == itemId); c.RvItemId = call.RvItemId; c.Magazines = call.Magazines; c.Books = call.Books; c.Brochures = call.Brochures; c.Date = call.Date; c.Notes = call.Notes; c.Tracts = call.Tracts; db.SubmitChanges(); return c.ItemId > 0 && ReturnVisitsInterface.UpdateLastVisitDate(call.RvItemId, call.Date); // existing call saved. } var cc = RvPreviousVisitData.Copy(call); db.RvPreviousVisitItems.InsertOnSubmit(cc); db.SubmitChanges(); call.ItemId = cc.ItemId; return call.ItemId >= 0 && ReturnVisitsInterface.UpdateLastVisitDate(call.RvItemId, call.Date); } }
internal static RvPreviousVisitItem Copy(RvPreviousVisitData call) { return(new RvPreviousVisitItem { RvItemId = call.RvItemId, Magazines = call.Magazines, Books = call.Books, Brochures = call.Brochures, Tracts = call.Tracts, Date = call.Date, Notes = call.Notes }); }
/// <summary> /// Gets the call. /// </summary> /// <param name="callId">The call id.</param> /// <returns>RvPreviousVisitData.</returns> /// <exception cref="MyTimeDatabaseLib.RvPreviousVisitNotFoundException">The Call was not found.</exception> /// <exception cref="RvPreviousVisitNotFoundException">The Call was not found.</exception> public static RvPreviousVisitData GetCall(int callId) { using (var db = new RvPreviousVisitsContext(RvPreviousVisitsContext.DBConnectionString)) { try { RvPreviousVisitItem call = db.RvPreviousVisitItems.Single(s => s.ItemId == callId); return(RvPreviousVisitData.Copy(call)); } catch { throw new RvPreviousVisitNotFoundException("The Call was not found."); } } }
public static RvPreviousVisitData[] GetCallsByDate(DateTime @from, DateTime tod) { // using (var db = new RvPreviousVisitsContext(RvPreviousVisitsContext.DBConnectionString)) { try { //new DateTime(tod.Year, tod.Month, tod.Day, 0,0,0).AddDays(1) @from = new DateTime(@from.Year, @from.Month, @from.Day, 0, 0, 0); tod = new DateTime(tod.Year, tod.Month, tod.Day, 0, 0, 0).AddDays(1); var calls = from x in db.RvPreviousVisitItems where x.Date >= @from && x.Date < tod select x; if (calls.Any()) { return(calls.Select(c => RvPreviousVisitData.Copy(c)).ToArray()); } } catch { return(null); } } return(null); }
/// <summary> /// Gets the previous visits. /// </summary> /// <param name="rvItemId">The rv item id.</param> /// <param name="so">The Sort Order.</param> /// <returns>RvPreviousVisitData[].</returns> public static RvPreviousVisitData[] GetPreviousVisits(int rvItemId, SortOrder so) { var rvVists = new List <RvPreviousVisitData>(); using (var db = new RvPreviousVisitsContext(RvPreviousVisitsContext.DBConnectionString)) { IOrderedQueryable <RvPreviousVisitItem> qry = from x in db.RvPreviousVisitItems where x.RvItemId == rvItemId orderby x.Date select x; if (qry.Any()) { IEnumerable <RvPreviousVisitItem> visits = so == SortOrder.DateNewestToOldest ? qry.ToArray().Reverse() : qry.ToArray(); foreach (RvPreviousVisitItem v in visits) { rvVists.Add(RvPreviousVisitData.Copy(v)); } return(rvVists.ToArray()); } return(new RvPreviousVisitData[0]); } }
public static bool IsInitialCall(RvPreviousVisitData call) { // using (var db = new RvPreviousVisitsContext(RvPreviousVisitsContext.DBConnectionString)) { try { var qry = from x in db.RvPreviousVisitItems where x.RvItemId == call.RvItemId orderby x.Date select x; if (qry.Any()) { if (qry.Count() <= 1) return true; var c = qry.ToArray().First(); if (c.ItemId == call.ItemId) return true; } return false; } catch (Exception) { return false; } } }
internal static RvPreviousVisitItem Copy(RvPreviousVisitData call) { return new RvPreviousVisitItem { RvItemId = call.RvItemId, Magazines = call.Magazines, Books = call.Books, Brochures = call.Brochures, Tracts = call.Tracts, Date = call.Date, Notes = call.Notes }; }