public static void Update(term new_term, long term_id) { var term = SelectById(term_id); new_term.id = term_id; if (term != null) { term.hall_id = new_term.hall_id; term.rental_date = new_term.rental_date; term.rent_time_start = new_term.rent_time_start; term.rent_time_end = new_term.rent_time_end; term.note = new_term.note; foreach (item_list item in term.items.ToList()) { if (!new_term.items.Any(i => i.item_id == item.item_id)) { context.item_list.Remove(item); } } foreach (item_list item in new_term.items) { var new_item = term.items.FirstOrDefault(i => i.item_id == item.item_id); if (new_item != null && item.quantity != new_item.quantity) { item_list.Update(new_item, item.term_id); } else if (new_item == null) { item.term_id = term.id; item_list.Insert(item); } } context.SaveChanges(); } }
public static bool CheckItem(int item_id, term term) { var items = context.item_list.Where(i => i.item_id == item_id).ToList(); foreach (item_list item in items) { var check_term = term.SelectById(term.id); if (check_term != null && check_term.rental_date.CompareTo(term.rental_date) == 0 && check_term.rent_time_end.CompareTo(term.rent_time_start) == 1) { return(true); } } return(false); }
public static void Insert(term term) { context.terms.Add(term); context.SaveChanges(); }