public JsonResult Delete(int Id)
{
ProductSolds productSold = db.ProductSolds.Find(Id);
db.ProductSolds.Remove(productSold);
db.SaveChanges();
return(Json("Success", JsonRequestBehavior.AllowGet));
}
public bool Delete(int id)
{
ProductSolds productSold = db.ProductSolds.Find(id);
db.ProductSolds.Remove(productSold);
db.SaveChanges();
return(true);
}
private ProductSolds convertToProductSolds(ProductSold p)
{
ProductSolds s = new ProductSolds
{
Id = p.Id,
CustomerId = p.CustomerId,
ProductId = p.ProductId,
StoreId = p.StoreId,
DateSold = p.DateSold
};
return(s);
}
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 bool Update(object item)
{
if (item == null)
{
return(false);
}
ProductSold i = (ProductSold)item;
//i.DateSold = Convert.ToDateTime(i.DateSoldString); // this line is no longer needed as we are no longer binding DateSoldString
ProductSolds sale = convertToProductSolds(i);
var p = db.ProductSolds.FirstOrDefault(a => a.Id == sale.Id);
p.CustomerId = sale.CustomerId;
p.ProductId = sale.ProductId;
p.StoreId = sale.StoreId;
p.DateSold = sale.DateSold;
db.SaveChanges();
return(true);
}
public object Add(object item)
{
if (item == null)
{
throw new ArgumentNullException("item");
}
//define DateSoldString property
ProductSold productSold = (ProductSold)item;
//has to set its DateSoldString so we can pass it later to the display oberservable array to display
productSold.DateSoldString = productSold.DateSold.ToString("dd/MM/yyyy");
//convert to main database context ProductSolds table object and save to table
ProductSolds sale = convertToProductSolds(productSold);
db.ProductSolds.Add(sale);
db.SaveChanges();
//get ID of the sale row we just added from main database
productSold.Id = sale.Id;
return(productSold);
}
public JsonResult update(ProductSolds productSold)
{
db.Entry(productSold).State = EntityState.Modified;
db.SaveChanges();
return(Json("Update complete.", JsonRequestBehavior.AllowGet));
}
public JsonResult Add(ProductSolds productSold)
{
db.ProductSolds.Add(productSold);
db.SaveChanges();
return(Json("Added", JsonRequestBehavior.AllowGet));
}
