public static List<CurrentDayPickup> GetPickupsForThisRoute(string tag) { var p = (from pp in CurrentDayPickup.All() where (pp.CDPDefaultRouteID == tag && pp.CDPDeleted == false) select pp); return p.ToList(); }
public static CurrentDayPickup GetOneCDP(int? cdpkey) { // return (CurrentDayPickup.All().Where(x => (x.CurrentDayPickupID == key))).FirstOrDefault(); var name = "GETOneCDP(int? cdpkey"; if (cdpkey.HasValue) { return (CurrentDayPickup.Find(x => x.CurrentDayPickupID == cdpkey.Value).First()); } else { CurrentDayPickup cdp = CurrentDayPickup.Find(x => x.CurrentDayPickupID == cdpkey.Value).DefaultIfEmpty( new CurrentDayPickup { CDPCustomerID = "QQQQQ", CDPCustomerName = name, CDPDispatched = false, CDPChecked = false, CDPDeleted = false, CDPSent = false, CDPSendConfirmed = false }).First(); return cdp; } }
public static void CopyPickupsToArchive() { List<CurrentDayPickup> cdpList = CurrentDayPickup.All().ToList(); foreach (var cdp in cdpList) { var m = new PickupArchive { PACustomerID = cdp.CDPCustomerID, PAComment = cdp.CDPComment, PACustomerName = cdp.CDPCustomerName, PADefaultRouteID = cdp.CDPDefaultRouteID, PADispatched = cdp.CDPDispatched, PADeleted = cdp.CDPDeleted, PADispatchTime = cdp.CDPDispatchTime, PADriverMessage = cdp.CDPDriverMessage, PADriverName = cdp.CDPDriverName, PANotes = cdp.CDPNotes, PAPickupDate = cdp.CDPPickupDate, PARouteName = cdp.CDPRouteName }; m.Save(); } }
public static bool CompareNewCDP(CurrentDayPickup currentDayPickup, Posting posting) { var pu = Helper.GetOneCDP(currentDayPickup.CurrentDayPickupID); return pu.Equals(currentDayPickup); }
public static int GetUndeletedPickupCount() { return CurrentDayPickup.All().Where(x => x.CDPDeleted == false).Count(); }
public static List<CurrentDayPickup> GetCDPList() { return (from p in CurrentDayPickup.All() select p).ToList(); }
public static bool HasCDP(string custID) { return (CurrentDayPickup.Exists(x => (!x.CDPDeleted && x.CDPCustomerID == custID))); }