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);
}
