public Invoice Create(Invoice invoice) { // validation if (_context.Invoices.Any(x => x.IID == invoice.IID)) { throw new AppException("Invoice ID " + invoice.IID + " is already in use"); } // Name of Invoice Owner based on Due Date if (_context.Invoices.Any(x => x.Invoice_Too + x.DueDate + x.DueDate == invoice.Invoice_Too + invoice.DueDate + invoice.ClientID)) { throw new AppException("Bill " + invoice.Invoice_Too + invoice.DueDate + invoice.ClientID + " has already been made"); } //InvoiceItems if (_context.Invoices.Any(x => x.InvoiceItems + x.ClientID + x.IID == invoice.InvoiceItems + invoice.ClientID + invoice.IID)) { throw new AppException("Invoice Item " + invoice.InvoiceItems + invoice.ClientID + invoice.IID + " is already in use"); } //InvoiceNotes if (_context.Invoices.Any(x => x.InvoiceNotes + x.ClientID + x.IID == invoice.InvoiceNotes + invoice.ClientID + invoice.IID)) { throw new AppException("Invoice Notes " + invoice.InvoiceNotes + invoice.ClientID + invoice.IID + " for " + invoice.ClientID + invoice.IID + " is already in use"); } _context.Invoices.Add(invoice); _context.SaveChanges(); return(invoice); }
public Employee Create(Employee employee) { // validation if (_context.Employees.Any(x => x.EID == employee.EID)) { throw new AppException("Employee ID " + employee.EID + " is already in use"); } if (_context.Employees.Any(x => x.EmpFirstName + x.EmpLastName == employee.EmpFirstName + employee.EmpLastName)) { throw new AppException("Employee Name " + employee.EmpFirstName + employee.EmpLastName + " is already in use"); } if (_context.Employees.Any(x => x.EmpEmail == employee.EmpEmail)) { throw new AppException("Employee Email " + employee.EmpEmail + " is already in use"); } if (_context.Employees.Any(x => x.EmpPhone == employee.EmpPhone)) { throw new AppException("Employee Phone " + employee.EmpPhone + " is already in use"); } _context.Employees.Add(employee); _context.SaveChanges(); return(employee); }
public Client Create(Client client) { // validation if (_context.Clients.Any(x => x.BusinessName == client.BusinessName)) { throw new AppException("Business Name " + client.BusinessName + " is already in use"); } // validation if (_context.Clients.Any(x => x.ClientID == client.ClientID)) { throw new AppException("Client Ide " + client.ClientID + " is already in use"); } _context.Clients.Add(client); _context.SaveChanges(); return(client); }
public Calendar Create(Calendar calendar) { // validation if (_context.Calendars.Any(x => x.CalendarTitle == calendar.CalendarTitle)) { throw new AppException("Calendar Title " + calendar.CalendarTitle + " is already in use"); } // validation if (_context.Calendars.Any(x => x.CalendarID == calendar.CalendarID)) { throw new AppException("Client Ide " + calendar.CalendarID + " is already in use"); } _context.Calendars.Add(calendar); _context.SaveChanges(); return(calendar); }
public Project Create(Project project) { // validation if (_context.Projects.Any(x => x.PID == project.PID)) { throw new AppException("Project ID " + project.PID + " is already in use"); } if (_context.Projects.Any(x => x.ProjectTitle == project.ProjectTitle)) { throw new AppException("Project Title " + project.ProjectTitle + " is already in use"); } if (_context.Projects.Any(x => x.ProjectNotes == project.ProjectNotes)) { throw new AppException("Project Notes " + project.ProjectNotes + " is already in use"); } if (_context.Projects.Any(x => x.DueDate == project.DueDate)) { throw new AppException("Due Date " + project.DueDate + " has not changed"); } if (_context.Projects.Any(x => x.ClientID == project.ClientID)) { throw new AppException("Client ID " + project.ClientID + " has not changed"); } if (_context.Projects.Any(x => x.EmpID == project.EmpID)) { throw new AppException("Employee ID " + project.EmpID + " has not changed"); } _context.Projects.Add(project); _context.SaveChanges(); return(project); }
public Post Create(Post post) { // validation if (_context.Posts.Any(x => x.PostId == post.PostId)) { throw new AppException("Post ID " + post.PostId + " is already in use"); } if (_context.Posts.Any(x => x.Title == post.Title)) { throw new AppException("Post Title " + post.Title + " is already in use"); } if (_context.Posts.Any(x => x.Content == post.Content)) { throw new AppException("Post Content " + post.Content + " is already in use"); } _context.Posts.Add(post); _context.SaveChanges(); return(post); }
public User Create(User user, string password) { // validation if (string.IsNullOrWhiteSpace(password)) { throw new AppException("Password is required"); } if (_context.Users.Any(x => x.Username == user.Username)) { throw new AppException("Username " + user.Username + " is already taken"); } byte[] passwordHash, passwordSalt; CreatePasswordHash(password, out passwordHash, out passwordSalt); user.PasswordHash = passwordHash; user.PasswordSalt = passwordSalt; _context.Users.Add(user); _context.SaveChanges(); return(user); }