public long CreateReport(ReportItemDto report) { if (DateTime.Parse(report.Date).Date > DateTime.Now.Date || _context.Reports.Where(x => x.UserID == report.UserID && x.Date.Date == DateTime.Parse(report.Date).Date).Any()) { return(-1); } var currentReport = _context.Reports.Where(x => x.UserID == report.UserID && x.Date.Date == DateTime.Parse(report.Date).Date).SingleOrDefault(); if (currentReport != null) { _context.Reports.Remove(currentReport); } var newReport = new Report { UserID = report.UserID, Name = report.Name, Surname = report.Surname, Sector = report.Sector.SectorName, WorkName = report.Sector.WorkName, Amount = Math.Round(report.Amount, 2), Hours = Math.Round(report.Hours, 2), Date = DateTime.Parse(report.Date), }; _context.Reports.Add(newReport); _context.SaveChanges(); return(newReport.Id); }
public bool AddSector(SectorDto sector) { var newSector = new Sector { SectorName = sector.SectorName, WorkName = sector.WorkName, }; if (!_context.Sectors.Any(x => (x.SectorName == sector.SectorName))) { _context.Sectors.Add(newSector); _context.SaveChanges(); return(false); } return(true); }
public bool Register(RegisterDto register) { var user = new User { UserId = register.UserID, Name = register.Name, Surname = register.Surname, Password = Hash.GetHash(register.Password) }; if (!_context.Users.Any(x => (x.UserId == user.UserId))) { _context.Users.Add(user); _context.SaveChanges(); return(false); } return(true); }
private void AddPlan(SectorPlanDto sector, string hours, string date) { if (sector.Workers.Any()) { foreach (ShortUserDto worker in sector.Workers) { var newPlan = new Plan { UserID = worker.UserID, WorkName = sector.Sector.WorkName, Sector = sector.Sector.SectorName, Hours = hours, Date = DateTime.Parse(date), }; _context.Plans.Add(newPlan); _context.SaveChanges(); } } }
public bool SendToAll(string message) { List <int> usersList = new List <int>(); usersList = _context.Users.Where(x => x.UserId != 0).Select(x => x.UserId).ToList(); foreach (int id in usersList) { var newMessage = new Message { From = 0, //from admin (admin has ID = 0) To = id, MessageText = message, Date = DateTime.Now, }; _context.Messages.Add(newMessage); } _context.SaveChanges(); return(true); }