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)));
}
