public ActionResult AddSale(ProductSold sale)
{
if (ModelState.IsValid)
{
db.ProductSolds.Add(sale);
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);
}
public JsonResult Edit(int id, ProductSold prod)
{
using (db)
{
var prod1 = db.ProductSolds.Find(id);
if (prod1 != null)
{
db.Entry(prod1).State = EntityState.Detached;
}
db.Entry(prod).State = EntityState.Modified;
db.SaveChanges();
return(Json(prod, JsonRequestBehavior.AllowGet));
}
}
public ActionResult Create([Bind(Include = "Id,ProductId,CustomerId,StoreId,DateSold")] ProductSold productSold)
{
if (ModelState.IsValid)
{
db.ProductSolds.Add(productSold);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.CustomerId = new SelectList(db.Customers, "Id", "Name", productSold.CustomerId);
ViewBag.ProductId = new SelectList(db.Products, "Id", "Name", productSold.ProductId);
ViewBag.StoreId = new SelectList(db.Stores, "Id", "Name", productSold.StoreId);
return(View(productSold));
}
public ActionResult Delete(ProductSold model)
{
if (ModelState.IsValid)
{
var productsold = db.ProductSolds.FirstOrDefault(x => x.Id == model.Id);
db.ProductSolds.Remove(productsold);
db.SaveChanges();
return(RedirectToAction("Index"));
}
else
{
return(Json(new { success = false }));
}
}
public ActionResult DeleteConfirmed(int?id)
{
if (id != null)
{
ProductSold productSold = db.ProductSolds.Find(id);
db.ProductSolds.Remove(productSold);
db.SaveChanges();
return(new HttpStatusCodeResult(200, "Success"));
}
else
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
}
// GET: Sales/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
ProductSold productSold = db.ProductSolds.Include(c => c.Customer).Include(p => p.Product).Include(st => st.Store).SingleOrDefault(ps => ps.Id == id);
if (productSold == null)
{
return(HttpNotFound());
}
return(View(productSold));
}
// GET: Sales/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
ProductSold productSold = db.ProductSolds.Find(id);
if (productSold == null)
{
return(HttpNotFound());
}
return(View(productSold));
}
private void UpdateSales(ProductSold @event)
{
var sale = _sales.FirstOrDefault(s => s.ProductId == @event.ProductId);
if (sale == null)
{
sale = new Sale(@event.ProductId, @event.Amount, @event.TotalPrice);
_sales.Add(sale);
}
else
{
sale.Increase(@event.Amount, @event.TotalPrice);
}
}
//Return data based on particular Id
public JsonResult Edit(int id)
{
ProductSold productSold = db.ProductSolds.Find(id);
string value = string.Empty;
value = JsonConvert.SerializeObject(productSold,
Formatting.Indented,
new JsonSerializerSettings {
ReferenceLoopHandling = ReferenceLoopHandling.Ignore
});
return(Json(value, JsonRequestBehavior.AllowGet));
}
public ActionResult AddNewSale([Bind(Include = "Id,ProductId,CustomerId,StoreId,DateSold")] ProductSold productSold)
{
//either pass productId from frontend,.. or change productName to productId in backend
if (ModelState.IsValid)
{
db.ProductSolds.Add(productSold);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.CustomerId = new SelectList(db.Customers, "Id", "Name", productSold.CustomerId);
ViewBag.ProductId = new SelectList(db.Products, "Id", "Name", productSold.ProductId);
ViewBag.StoreId = new SelectList(db.Stores, "Id", "Name", productSold.StoreId);
return(View(productSold));
}
public ActionResult AddRecord(ProductSold ps)
{
ProductSold newProductSold = new ProductSold
{
CustomerID = ps.CustomerID,
StoreID = ps.StoreID,
ProductID = ps.ProductID,
DateSold = DateTime.Today
};
db.ProductSold.Add(newProductSold);
db.SaveChanges();
return(Json(new { success = true, responseText = "Record Successful Added!" }));
}
public JsonResult GetRecord(int?id)
{
if (id == null)
{
return(Json(HttpStatusCode.BadRequest));
}
ProductSold productSold = db.ProductSold.Include(x => x.Product).Include(x => x.Customer).Include(x => x.Store).FirstOrDefault(r => r.Id == id);
if (productSold == null)
{
return(Json(HttpStatusCode.NotFound));
}
return(Json(productSold, JsonRequestBehavior.AllowGet));
}
public JsonResult DeleteProductSold(int id)
{
try
{
ProductSold productSold = db.ProductSolds.Find(id);
db.ProductSolds.Remove(productSold);
db.SaveChanges();
}
catch
{
return(Json(new { Status = false }, JsonRequestBehavior.AllowGet));
}
return(Json(new { Status = true }, JsonRequestBehavior.AllowGet));
}
public ActionResult DeleteConfirmed(int id)
{
ProductSold productSold = db.ProductSolds.Find(id);
db.ProductSolds.Remove(productSold);
db.SaveChanges();
return(Json(
new
{
// Because the data is saved successfully, the Modal will be closed, thus no need to return inputed data.
// Id < 0, which means data saved successfully
Id = -1
}, JsonRequestBehavior.AllowGet
));
}
public ActionResult AddProductSold(ProductSold productSold)
{
using (var db = new OnboardingEntities())
{
var proSold = new ProductSold
{
CustomerId = productSold.CustomerId,
ProductId = productSold.ProductId,
StoreId = productSold.StoreId,
DateSold = productSold.DateSold,
};
db.ProductSolds.Add(proSold);
db.SaveChanges();
return(Json(new { Success = true }, JsonRequestBehavior.AllowGet));
}
}
/// <summary>
/// deletes the sale from the database
/// </summary>
/// <param name="saleId">
/// contains the id of the sale to be deleted
/// </param>
/// <returns></returns>
public ActionResult DeleteSale(int saleId)
{
bool result = false;
if (ModelState.IsValid)
{
ProductSold sale = db.ProductSolds.SingleOrDefault(x => x.Id == saleId);
if (sale != null)
{
db.ProductSolds.Remove(sale);
db.SaveChanges();
result = true;
}
}
return(Json(result, JsonRequestBehavior.AllowGet));
}
public ActionResult Edit(ProductSold product) // Update PartialView
{
if (ModelState.IsValid)
{
ProductSold productnew = db.ProductSolds.Where(X => X.ID == product.ID).FirstOrDefault();
if (productnew != null)
{
productnew.CustomerID = product.CustomerID;
productnew.ProductID = product.ProductID;
productnew.StoreID = product.StoreID;
productnew.Datesold = product.Datesold;
db.SaveChanges();
}
}
return(View(product));
}
//insert and update data into database
public JsonResult SaveDataInDatabase(SaleViewModel model)
{
var result = false;
try
{
//check if the input is null, return "re"
if (model.ProductId == null || model.CustomerId == null || model.StoreId == null || model.DataSold == null)
{
return(Json("re", JsonRequestBehavior.AllowGet));
}
else
{
//if id >0, update
if (model.Id > 0)
{
ProductSold prosold = db.ProductSolds.SingleOrDefault(x => x.Id == model.Id);
prosold.ProductId = model.ProductId;
prosold.CustomerId = model.CustomerId;
prosold.StoreId = model.StoreId;
prosold.DataSold = model.DataSold;
db.SaveChanges();
result = true;
}
else
{
// insert
//check if the customer is already existing
ProductSold prosold = new ProductSold();
prosold.ProductId = model.ProductId;
prosold.CustomerId = model.CustomerId;
prosold.StoreId = model.StoreId;
prosold.DataSold = model.DataSold;
db.ProductSolds.Add(prosold);
db.SaveChanges();
result = true;
}
}
return(Json(result, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
throw ex;
}
}
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));
}
// [HttpPost]
public JsonResult Update(ProductSold productsold)
{
bool result = false;
var product = db.ProductSolds.Where(p => p.Id == productsold.Id).FirstOrDefault();
//customer.Name = Request["Name"];
//customer.Address = Request["Address"];
db.Entry(product).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
result = true;
//else
//{
// return HttpNotFound;
//}
return(Json(result, JsonRequestBehavior.AllowGet));
}
public ActionResult Create(ProductSold prods)
{
using (var db = new Onboard1DbContext())
{
if (ModelState.IsValid)
{
db.ProductSolds.Add(prods);
db.SaveChanges();
return(RedirectToAction("GetSalesList"));
}
ViewBag.ProductId = db.Products.Select(x => new { x.Id, x.Name }).ToList();
ViewBag.CustomerId = db.Customers.Select(x => new { x.Id, x.Name }).ToList();
ViewBag.StoreId = db.Stores.Select(x => new { x.Id, x.Name }).ToList();
return(View(prods));
}
}
// 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 JsonResult Add(ProductSold prod)
{
try
{
using (db)
{
db.ProductSold.Add(prod);
db.SaveChanges();
return(Json(prod, JsonRequestBehavior.AllowGet));
}
}
catch (Exception ex)
{
Console.WriteLine(ex.InnerException);
return(Json(prod, JsonRequestBehavior.AllowGet));
}
}
public object GetById(int id)
{
ProductSolds c = db.ProductSolds.Find(id);
ProductSold sale = new ProductSold
{
Id = c.Id,
CustomerId = c.CustomerId,
CustomerName = c.Customers.Name,
ProductId = c.ProductId,
ProductName = c.Products.Name,
StoreId = c.StoreId,
StoreName = c.Stores.Name,
DateSold = c.DateSold
};
return(sale);
}
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));
}
// GET: ProductSolds/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
ProductSold productSold = db.ProductSolds.Find(id);
if (productSold == null)
{
return(HttpNotFound());
}
ViewBag.CustomerID = new SelectList(db.Customers, "CustomerID", "Name", productSold.CustomerID);
ViewBag.ProductID = new SelectList(db.Products, "ProductID", "Name", productSold.ProductID);
ViewBag.StoreID = new SelectList(db.Stores, "StoreID", "Name", productSold.StoreID);
return(View(productSold));
}
[HttpPost]//Add Sales
public ActionResult AddSales(SalesViewModel viewModel)
{
if (ModelState.IsValid)
{
var sales = new ProductSold
{
CustomerId = viewModel.CustomerId,
ProductId = viewModel.ProductId,
StoreId = viewModel.StoreId,
DateSold = viewModel.DateSold
};
db.ProductSolds.Add(sales);
db.SaveChanges();
return(Json("OK", JsonRequestBehavior.AllowGet));
}
throw new Exception("Invalid Model");
}
public JsonResult Create(ProductSold productSold)
{
bool result = false;
if (ModelState.IsValid)
{
db.ProductSolds.Add(productSold);
db.SaveChanges();
result = true;
}
var productId = db.ProductSolds.ToList().LastOrDefault();
//ViewBag.CustomerId = new SelectList(db.Customers, "Id", "Name", productSold.CustomerId);
// ViewBag.ProductId = new SelectList(db.Products, "Id", "ProductName", productSold.ProductId);
//ViewBag.StoreId = new SelectList(db.Stores, "Id", "Name", productSold.StoreId);
return(Json(productId, JsonRequestBehavior.AllowGet));
}
// CREATE Sale
public JsonResult CreateSale(ProductSold sale)
{
try
{
db.ProductSolds.Add(sale);
db.SaveChanges();
}
catch (Exception e)
{
Console.Write(e.Data + "Exception Occured");
return(new JsonResult {
Data = "Sale Create Failed", JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
return(new JsonResult {
Data = "Success", JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
public JsonResult UpdateDataInDatabase(SaleViewModel model)
{
var result = false;
//if id >0, update
ProductSold productsold = db.ProductSold.SingleOrDefault(x => x.Id == model.Id);
productsold.ProductId = (int)model.ProductId;
productsold.CustomerId = (int)model.CustomerId;
productsold.StoreId = (int)model.StoreId;
productsold.DataSold = (DateTime)model.DataSold;
db.SaveChanges();
result = true;
return(Json(result, JsonRequestBehavior.AllowGet));
}
