public JsonResult SaveSale(int Id, int ProductId, int CustomerId, int StoreId, DateTime SaleDate)
{
//This method is used to save the edited information about the Customer and to create a new
//method
var result = false;
if (Id > 0)
{
try
{
ProductSold SaleToBeUpdated = db.ProductSolds.SingleOrDefault(x => x.Id == Id);
SaleToBeUpdated.ProductId = ProductId;
SaleToBeUpdated.CustomerId = CustomerId;
SaleToBeUpdated.StoreId = StoreId;
SaleToBeUpdated.Date = SaleDate;
db.SaveChanges();
result = true;
}
catch (Exception exp)
{
}
}
else
{
//The following code insersts new record
try
{
CustomerDbEntities db = new CustomerDbEntities();
ProductSold Sale = new ProductSold();
Sale.ProductId = ProductId;
Sale.CustomerId = CustomerId;
Sale.StoreId = StoreId;
Sale.Date = SaleDate;
db.ProductSolds.Add(Sale);
db.SaveChanges();
result = true;
}
catch (Exception ex)
{
throw ex;
}
}
return(Json(result, JsonRequestBehavior.AllowGet));
}
public JsonResult SaveProduct(int Id, string Name, Decimal Price)
{
var result = false;
if (Id > 0)
{
try
{
Product ProducttoBeUpdated = db.Products.SingleOrDefault(x => x.Id == Id);
ProducttoBeUpdated.Name = Name;
ProducttoBeUpdated.Price = Price;
db.SaveChanges();
result = true;
}
catch (Exception exp)
{
}
}
else
{
//The following code insersts new record
try
{
CustomerDbEntities db = new CustomerDbEntities();
// List<Product> list = db.Products.ToList();
//ViewBag.DepartmentList = new SelectList(list, "DepartmentId", "DepartmentName");
Product P1 = new Product();
P1.Name = Name;
P1.Price = Price;
db.Products.Add(P1);
db.SaveChanges();
result = true;
}
catch (Exception ex)
{
throw ex;
}
}
return(Json(result, JsonRequestBehavior.AllowGet));
}
public JsonResult SaveCustomer(int Id, string Name, string Address)
{
//This method is used to save the edited information about the Customer and to create a new
//method
var result = false;
if (Id > 0)
{
try
{
Customer CustomertoBeUpdated = db.Customers.SingleOrDefault(x => x.Id == Id);
CustomertoBeUpdated.Name = Name;
CustomertoBeUpdated.Address = Address;
db.SaveChanges();
result = true;
}
catch (Exception exp)
{
}
}
else
{
//The following code insersts new record
try
{
CustomerDbEntities db = new CustomerDbEntities();
Customer newCustomer = new Customer();
newCustomer.Name = Name;
newCustomer.Address = Address;
db.Customers.Add(newCustomer);
db.SaveChanges();
result = true;
}
catch (Exception ex)
{
throw ex;
}
}
return(Json(result, JsonRequestBehavior.AllowGet));
}
public CustomerRepository(CustomerDbEntities context) : base(context)
{
_customerDbEntities = context;
}
public UnitOfWork(CustomerDbEntities context)
{
_context = context;
Customers = new CustomerRepository(_context);
}
