// GET UPDATE SELL
public JsonResult GetUpdateSell(int Id)
{
try
{
ProductSoldModel sell = db.ProductSold.Where(x => x.Id == Id).SingleOrDefault();
var value = JsonConvert.SerializeObject(sell, Formatting.Indented, new JsonSerializerSettings
{
ReferenceLoopHandling = ReferenceLoopHandling.Ignore
});
return(Json(value));
}
catch (Exception e)
{
Console.Write(e.Data + "Error occurred");
return(Json(new { Data = "Get sell update failed" }));
}
}
// Delete SELL
public JsonResult Deletesale(int Id)
{
try
{
ProductSoldModel sale = db.ProductSold.Where(x => x.Id == Id).SingleOrDefault();
if (ModelState.IsValid)
{
db.ProductSold.Remove(sale);
db.SaveChanges();
Console.Write("Delete sell successful");
}
}
catch (Exception e)
{
Console.Write(e.Data + "Error occurred");
return(Json(new { Data = "Delete sell failed" }));
}
return(Json(new { Data = "Success" }));
}
public JsonResult UpdateSale(ProductSoldModel productSold)
{
ProductSoldModel sale = db.ProductSold.Where(x => x.Id == productSold.Id).SingleOrDefault();
if (ModelState.IsValid)
{
sale.DateSold = productSold.DateSold;
sale.CustomerId = productSold.CustomerId;
sale.ProductId = productSold.ProductId;
sale.StoreId = productSold.StoreId;
}
try
{
db.SaveChanges();
}
catch (Exception e)
{
Console.Write(e.Data + "Error occurred");
return(Json(new { Data = "Update sell failed" }));
}
return(Json(new { Data = "Success" }));
}
// CREATE SELL
public JsonResult CreateSale(ProductSoldModel productSold)
{
var sell = new ProductSoldModel();
if (ModelState.IsValid)
{
sell.DateSold = productSold.DateSold;
sell.CustomerId = productSold.CustomerId;
sell.ProductId = productSold.ProductId;
sell.StoreId = productSold.StoreId;
}
try
{
db.ProductSold.Add(sell);
db.SaveChanges();
Console.Write("ProductSold successful");
return(Json(new { Data = "Success" }));
}
catch (Exception e)
{
Console.Write(e.Data + "Error occurred");
return(Json(new { Data = "Create sale failed" }));
}
}