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