public string Create(sales_has_products Model)
{
DatabaseContext db = new DatabaseContext();
string msg;
try
{
if (ModelState.IsValid)
{
Model.sales_idSale = new Random().Next(1, 1000);
db.sales_has_products.Add(Model);
db.SaveChanges();
msg = "Saved Successfully";
}
else
{
msg = "Validation data not successfully";
}
}
catch (Exception ex)
{
msg = "Error occured:" + ex.Message;
}
return(msg);
}
public string Delete(string Id)
{
DatabaseContext db = new DatabaseContext();
sales_has_products sales_has_product = db.sales_has_products.Find(int.Parse(Id));
db.sales_has_products.Remove(sales_has_product);
db.SaveChanges();
return("Deleted successfully");
}
public string Edit(sales_has_products Model)
{
DatabaseContext db = new DatabaseContext();
string msg;
try
{
if (ModelState.IsValid)
{
db.Entry(Model).State = EntityState.Modified;
db.SaveChanges();
msg = "Saved Successfully";
}
else
{
msg = "Validation data not successfully";
}
}
catch (Exception ex)
{
msg = "Error occured:" + ex.Message;
}
return(msg);
}
