public Sitting Delete(Sitting sitting) { context.Sittings.Remove(sitting); context.SaveChanges(); return(sitting); }
public Sitting Update(Sitting updateSitting) { var _sitting = context.Sittings.Attach(updateSitting); _sitting.State = Microsoft.EntityFrameworkCore.EntityState.Modified; context.SaveChanges(); return(updateSitting); }
public bool ValidateDate(Sitting a) { var sittingItems = GetSittingWithType().Where(e => e.Start.Date == DateTime.Now.Date).ToList(); var validateItem = true; foreach (var s in sittingItems) { if (a.End <= a.Start || a.Start >= s.End) { return(validateItem); } else { validateItem = false; return(validateItem); } } return(validateItem); }
public void AddSitting(Sitting sitting) { var days = (sitting.End - sitting.Start).TotalDays; for (var i = 0; i < days; i++) { DateTime newDateTime = new DateTime(sitting.Start.AddDays(i).Year, sitting.Start.AddDays(i).Month, sitting.Start.AddDays(i).Day) + sitting.End.TimeOfDay; var newsitting = new Sitting() { Start = sitting.Start.AddDays(i), End = newDateTime, Capacity = sitting.Capacity, SittingTypeId = sitting.SittingTypeId, SittingType = sitting.SittingType, Status = sitting.Status }; context.Sittings.Add(newsitting); context.SaveChanges(); } }