public async Task <int> insertAsync(Sale data) { // Sale obj = new Sale(); try { Sale obj = new Sale { CartID = data.CartID, InvoiceID = data.InvoiceID, DateCreated = DateTime.Now, UserCreated = data.UserModified, CustomerID = data.CustomerID }; await _context.Sales.AddAsync(obj); await _context.SaveChangesAsync(); return(obj.ID); } catch (Exception ex) { throw ex; } }
public async Task <int> insertAsync(Price data) { var price = new Price(); try { price = new Price { DateCreated = DateTime.Now, UserCreated = data.UserCreated, SalePrice = data.SalePrice, CostPrice = data.CostPrice }; await _context.Prices.AddAsync(price); await _context.SaveChangesAsync(); return(price.ID); } catch (Exception ex) { throw ex; } }
public async Task <int> insertAsync(StaffSkill data) { var StaffSkill = new StaffSkill(); try { if (data != null) { StaffSkill = new StaffSkill { SkillID = data.SkillID, StaffID = data.StaffID, SupervisorID = data.SupervisorID, CompetencyValue = data.CompetencyValue }; await _context.StaffSkills.AddAsync(StaffSkill); await _context.SaveChangesAsync(); } } catch (Exception ex) { throw ex; } return(StaffSkill.ID); }
public async Task deleteAsync(int ID) { try { var staff = await _context.Staffs.FindAsync(ID); _context.Staffs.Remove(staff); await _context.SaveChangesAsync(); } catch (Exception ex) { throw ex; } }
public async Task deleteAsync(int ID) { try { var lead = await _context.Leads.FindAsync(ID); _context.Leads.Remove(lead); await _context.SaveChangesAsync(); } catch (Exception ex) { throw ex; } }
public async Task deleteAsync(int ID) { try { var privileges = await _context.Privileges.Where(x => x.RoleID == ID).ToListAsync(); _context.Privileges.RemoveRange(privileges); await _context.SaveChangesAsync(); } catch (Exception ex) { throw ex; } }
public async Task deleteAsync(int ID) { try { var product = await _context.Products.FindAsync(ID); _context.Products.Remove(product); await _context.SaveChangesAsync(); } catch (Exception ex) { throw ex; } }
public async Task deleteAsync(int ID) { try { var user = await _context.AppUsers.FindAsync(ID); _context.AppUsers.Remove(user); await _context.SaveChangesAsync(); } catch (Exception ex) { throw ex; } }
public async Task deleteAsync(int ID) { try { var CustomerMessages = await _context.CustomerMessages.Where(x => x.CustomerID == ID).ToListAsync(); _context.CustomerMessages.RemoveRange(CustomerMessages); await _context.SaveChangesAsync(); } catch (Exception ex) { throw ex; } }
public async Task deleteAsync(int ID) { try { var item = await _context.Items.FindAsync(ID); _context.Items.Remove(item); await _context.SaveChangesAsync(); } catch (Exception ex) { throw ex; } }
public async Task deleteAsync(int ID) { try { var role = await _context.Roles.FindAsync(ID); _context.Roles.Remove(role); await _context.SaveChangesAsync(); } catch (Exception ex) { throw ex; } }
public async Task <int> insertAsync(Payment data) { var payment = new Payment(); try { if (data != null) { payment = new Payment { UserCreated = data.UserCreated, Amount = data.Amount, DatePaid = DateTime.Now, InvoiceNo = data.InvoiceNo, Method = data.Method, Reference = data.Reference, CustomerID = data.CustomerID }; await _context.Payments.AddAsync(payment); await _context.SaveChangesAsync(); } } catch (Exception ex) { throw ex; } return(payment.ID); }
public async Task <int> insertAsync(Assessment data) { var Assessment = new Assessment(); try { if (data != null) { Assessment = new Assessment { DateCreated = DateTime.Now, SAS = data.SAS, StaffSkillID = data.StaffSkillID }; await _context.Assessments.AddAsync(Assessment); await _context.SaveChangesAsync(); } } catch (Exception ex) { throw ex; } return(Assessment.ID); }
public async Task <int> insertAsync(User data) { int ID = 0; try { if (data != null) { await _context.AppUsers.AddAsync(data); ID = await _context.SaveChangesAsync(); } } catch (Exception ex) { throw ex; } return(ID); }
public async Task <int> insertAsync(Customer data) { int ID = 0; try { if (data != null) { data.DateCreated = DateTime.Now; data.UserCreated = data.UserModified; await _context.Customers.AddAsync(data); ID = await _context.SaveChangesAsync(); } } catch (Exception ex) { throw ex; } return(ID); }