public ActionResult Save(ProductSoldViewModel productSold)
{
ProductSold newProduct = db.ProductSold.Find(productSold.Id);
var i = productSold.ProductId;
Products p = db.Products.Find(i);
try
{
if (newProduct != null)
{
newProduct.Id = productSold.Id;
newProduct.CustomerId = productSold.CustomerId;
newProduct.ProductId = productSold.ProductId;
newProduct.StoreId = productSold.StoreId;
newProduct.DateSold = productSold.soldDate;
db.SaveChanges();
return(Json("success save"));
}
;
return(Json("Unfind"));
}
catch (Exception e)
{
throw e;
}
}
public JsonResult SaveDataInDatabase(ProductSoldViewModel model)
{
var result = false;
try
{
if (model.ID > 0)
{
ProductSold val = db.ProductSolds.SingleOrDefault(x => x.ID == model.ID);
val.CustomerId = model.CustomerId;
val.ProductId = model.ProductId;
val.StoreId = model.StoreId;
db.SaveChanges();
result = true;
}
else
{
ProductSold val = new ProductSold();
val.CustomerId = model.CustomerId;
val.ProductId = model.ProductId;
val.StoreId = model.StoreId;
val.DateSold = System.DateTime.Now;
db.ProductSolds.Add(val);
db.SaveChanges();
result = true;
}
}
catch (Exception ex)
{
throw ex;
}
return(Json(result, JsonRequestBehavior.AllowGet));
}
public ActionResult SaveEditSale(ProductSoldViewModel model)
{
Thread.CurrentThread.CurrentCulture = new CultureInfo("en-GB"); //dd/MM/yyyy
ProductSold k = db.ProductSolds.Where(x => x.Id == model.Id).FirstOrDefault();
if (k != null)
{
k.CustomerId = model.CustomerId;
k.ProductId = model.ProductId;
k.StoreId = model.StoreId;
//k.DateSold = Convert.ToDateTime(model.DateSold);
k.DateSold = DateTime.Parse(model.DateSold);
//k.DateSold = DateTime.ParseExact(model.DateSold, "dd/MM/yyyy", CultureInfo.InvariantCulture);
}
else
{
ProductSold pro = new ProductSold();
pro.ProductId = model.ProductId;
pro.CustomerId = model.CustomerId;
pro.StoreId = model.StoreId;
pro.StoreId = model.StoreId;
pro.DateSold = DateTime.Parse(model.DateSold);
//pro.DateSold = DateTime.ParseExact(model.DateSold, "dd/MM/yyyy", CultureInfo.InvariantCulture);
db.ProductSolds.Add(pro);
db.SaveChanges();
}
db.SaveChanges();
return(Json(new { Response = "Success" }));
}
public ActionResult EditSale(ProductSoldViewModel sale)
{
try
{
if (sale.Id >= 0)
{
ProductSold editedSale = db.ProductSolds.Find(sale.Id);
editedSale.ProductId = sale.ProductId;
editedSale.CustomerId = sale.CustomerId;
editedSale.StoreId = sale.StoreId;
editedSale.DateSold = sale.DateSold;
db.Entry(editedSale).State = EntityState.Modified;
db.SaveChanges();
ViewBag.CustomerId = new SelectList(db.Customers, "CustomerId", "CustomerName");
ViewBag.ProductId = new SelectList(db.Products, "ProductId", "ProductName");
ViewBag.StoreId = new SelectList(db.Stores, "StoreId", "StoreName");
return(null);
}
}
catch (Exception ex)
{
throw ex;
}
return(null);
}
public ActionResult Create(ProductSoldViewModel productSold)
{
int id = createId();
var newSold = new ProductSold
{
Id = id,
CustomerId = productSold.CustomerId,
ProductId = productSold.ProductId,
StoreId = productSold.StoreId,
DateSold = productSold.soldDate
};
db.ProductSold.Add(newSold);
db.SaveChanges();
return(Json("success create", JsonRequestBehavior.AllowGet));
}
// Edits a sale in the database
public ActionResult EditSale(ProductSoldViewModel sale)
{
ProductSold editSale = GetSaleById(sale.Id);
editSale.CustomerId = sale.CustomerId;
editSale.ProductId = sale.ProductId;
editSale.StoreId = sale.StoreId;
editSale.DateSold = sale.DateSold;
if (ModelState.IsValid)
{
db.Entry(editSale).State = EntityState.Modified;
db.SaveChanges();
}
return(Json(sale, JsonRequestBehavior.AllowGet));
}
public ActionResult Edit(int id)
{
var productSold = db.ProductSold.Find(id);
var newProductSold = new ProductSoldViewModel();
newProductSold.CustomerId = productSold.Customers.Id;
newProductSold.CustomerName = productSold.Customers.Name;
newProductSold.StoreId = productSold.Stores.Id;
newProductSold.StoreName = productSold.Stores.Name;
newProductSold.ProductId = productSold.Products.Id;
newProductSold.ProductName = productSold.Products.Name;
newProductSold.ProductList = getProductList();
newProductSold.CustomerList = getCustomerList();
newProductSold.StoreList = getStoreList();
newProductSold.soldDate = productSold.DateSold.Value;
return(Json(newProductSold, JsonRequestBehavior.AllowGet));
}
// Adds a sale to the database
public ActionResult AddSale(ProductSoldViewModel sale)
{
ProductSold newSale = new ProductSold()
{
Id = sale.Id,
CustomerId = sale.CustomerId,
ProductId = sale.ProductId,
StoreId = sale.StoreId,
DateSold = sale.DateSold
};
if (ModelState.IsValid)
{
db.ProductSolds.Add(newSale);
db.SaveChanges();
}
return(Json(sale, JsonRequestBehavior.AllowGet));
}
