public bool AddInvoice(Invoice invoice, List<Product> products )
{
try
{
using (TransactionScope ts = new TransactionScope())
{
using (SalesAndInventorySystemDataContext dataContext = new SalesAndInventorySystemDataContext())
{
//Invoice newInvoice=new Invoice(){ InvoiceNo = invoice.InvoiceNo, CostPrice = invoice.CostPrice, Due = invoice.Due, InvoiceDate = invoice.InvoiceDate, TotalPrice = invoice.TotalPrice, vat = invoice.vat};
dataContext.Invoices.Add(invoice);
dataContext.SaveChanges();
if (invoice.InvoiceID>0)
{
foreach (Product product in products)
{
SellProduct sellProduct=new SellProduct(){ InvoiceID = invoice.InvoiceID, Price = product.Price, ProductID = product.ProductID, Quantiry = product.Quantity, Size = product.Size};
dataContext.SellProducts.Add(sellProduct);
dataContext.Database.ExecuteSqlCommand("Update Products set Quantity= Quantity-" + product.Quantity + "where ProductID="+product.ProductID);
dataContext.SaveChanges();
}
}
}
ts.Complete();
return true;
}
return false;
}
catch (Exception exception)
{
throw new Exception(exception.Message);
}
}
public bool AddCompany(PersonType company)
{
try
{
using (SalesAndInventorySystemDataContext dataContext = new SalesAndInventorySystemDataContext())
{
dataContext.Companies.Add(company);
dataContext.SaveChanges();
return true;
}
}
catch (Exception exception)
{
throw new Exception(exception.Message);
}
}
public bool AddCategory(Category category)
{
try
{
using (SalesAndInventorySystemDataContext dataContext = new SalesAndInventorySystemDataContext())
{
dataContext.Categoets.Add(category);
dataContext.SaveChanges();
return true;
}
}
catch (Exception exception)
{
throw new Exception(exception.Message);
}
}
public bool AddProduct(Product product)
{
try
{
using (SalesAndInventorySystemDataContext dataContext = new SalesAndInventorySystemDataContext())
{
dataContext.Products.Add(product);
dataContext.SaveChanges();
return true;
}
}
catch (Exception exception)
{
throw new Exception(exception.Message);
}
}
public bool DeleteCompany(PersonType company)
{
try
{
using (SalesAndInventorySystemDataContext dataContext = new SalesAndInventorySystemDataContext())
{
dataContext.Companies.Attach(company);
dataContext.Entry(company).State=EntityState.Deleted;
dataContext.SaveChanges();
return true;
}
}
catch (Exception exception)
{
throw new Exception(exception.Message);
}
}
public bool DeleteProduct(Product product)
{
try
{
using (SalesAndInventorySystemDataContext dataContext = new SalesAndInventorySystemDataContext())
{
dataContext.Products.Attach(product);
dataContext.Entry(product).State = EntityState.Deleted;
dataContext.SaveChanges();
return true;
}
}
catch (Exception exception)
{
throw new Exception(exception.Message);
}
}
public bool UpdateCompany(PersonType company)
{
try
{
using (SalesAndInventorySystemDataContext dataContext = new SalesAndInventorySystemDataContext())
{
dataContext.Companies.Attach(company);
dataContext.Entry(company).State = EntityState.Modified;
dataContext.SaveChanges();
return true;
//_cnt.Users.Attach(user);
//_cnt.Entry<User>(user).Property(u => u.PasswordHash).IsModified = true;
//_cnt.SaveChanges();
}
}
catch (Exception exception)
{
throw new Exception(exception.Message);
}
}
public bool UpdateCategory(Category category)
{
try
{
using (SalesAndInventorySystemDataContext dataContext = new SalesAndInventorySystemDataContext())
{
dataContext.Categoets.Attach(category);
dataContext.Entry(category).State = EntityState.Modified;
dataContext.SaveChanges();
return true;
}
}
catch (Exception exception)
{
throw new Exception(exception.Message);
}
}
