public async static Task <int> BookItems(int user_id, int item_id, int time_id, string date_string)
{
Transaction transaction = new Transaction(user_id,
item_id,
(int)Transaction_type.borrow,
time_id,
DateTime.ParseExact(date_string, "yyyy-MM-dd", null));
int result = await TransactionDB.Add(transaction);
return(result);
}
public static async Task <List <List <int> > > GetCurrentQuantityByDateAsync(DateTime date)
{
var db = new SoftwareStudioContext();
List <int> allItemsAM = await GetAllQuantityAsync();
List <int> allItemsPM = await GetAllQuantityAsync();
for (int i = 0; i < 5; i++)
{
List <Transaction> transactions = await TransactionDB.GetByLabIDAndDateAsync(i + 1, date);
for (int j = 0; j < transactions.Count; j++)
{
switch (transactions[j].time_id)
{
case (int)Time_id_type.none:
allItemsAM[i]++;
allItemsPM[i]++;
break;
case (int)Time_id_type.AM:
allItemsAM[i]--;
break;
case (int)Time_id_type.PM:
allItemsPM[i]++;
break;
case (int)Time_id_type.Day:
allItemsAM[i]--;
allItemsPM[i]--;
break;
}
}
}
return(new List <List <int> > {
allItemsAM, allItemsPM
});
}
public static async Task <List <int> > GetCurrentQuantityByLabIDAsync(int labID)
{
var db = new SoftwareStudioContext();
int allQuantity = (await GetAllByLabIDAsync(labID)).Count;
int allItemsAM = allQuantity;
int allItemsPM = allQuantity;
List <Transaction> transactions = await TransactionDB.GetByLabIDAndDateAsync(labID, DateTime.Now);
for (int j = 0; j < transactions.Count; j++)
{
switch (transactions[j].time_id)
{
case (int)Time_id_type.none:
allItemsAM++;
allItemsPM++;
break;
case (int)Time_id_type.AM:
allItemsAM--;
break;
case (int)Time_id_type.PM:
allItemsPM++;
break;
case (int)Time_id_type.Day:
allItemsAM--;
allItemsPM--;
break;
}
}
return(new List <int> {
allItemsAM, allItemsPM
});
}
