public async Task <IEnumerable <PickUp> > GetPickUpData(PickUpInput input)
{
string query = "SELECT * " +
"FROM qryInventory " +
"WHERE PartPU = 1 " +
$"AND PartPUDate <= '{input.Today:yyyy-MM-dd}' " +
$"AND BaseID = {input.BaseId} " +
"OR Pickup = 1 " +
$"AND BaseID = {input.BaseId} " +
$"OR PUDate <= '{input.Today:yyyy-MM-dd}' " +
"AND PUDate > '1/1/2000' " +
"AND PUCompleted = 0 " +
$"AND BaseID = {input.BaseId}";
try
{
using (IDbConnection db = GetConnection())
{
db.Open();
return(await db.QueryAsync <PickUp>(query));
}
}
catch (Exception)
{
return(null);
}
}
public async Task <IEnumerable <PickUp> > GetAllPickUps(int baseId)
{
if (await BaseIdExist(baseId))
{
PickUpInput input = new PickUpInput(baseId, DateTime.Today.Date, await GetShortBase(baseId));
List <PickUp> pickUps = (List <PickUp>)(await GetPickUpData(input));
if (pickUps == null)
{
return(new List <PickUp>());
}
return(pickUps);
}
return(null);
}
