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