public ActionResult OrderDetails(OrderAndTable model)
{
var order = model.order;
using (var dc = new MySQLEntities())
{
var orderInDb = dc.orders.Find(order.idOrders);
if (orderInDb == null)
{
order.idOrders = Guid.NewGuid();
dc.orders.Add(order);
dc.SaveChanges();
}
else
{
//dc.Set<order>().AddOrUpdate(order);
dc.Entry(orderInDb).CurrentValues.SetValues(order);
dc.Entry(orderInDb).State = EntityState.Modified;
dc.SaveChanges();
}
}
Thread.Sleep(1000);
return(RedirectToAction("../Home/Index"));
}
public ActionResult CustomerDetails(customers customer)
{
using (var dc = new MySQLEntities())
{
if (customer.idcustomers == Guid.Empty)
{
customer.idcustomers = Guid.NewGuid();
dc.customers.Add(customer);
dc.SaveChanges();
}
else
{
dc.Entry(customer).State = EntityState.Modified;
dc.SaveChanges();
}
}
return(RedirectToAction("Customers"));
}
public ActionResult DistrictDetails(districts district)
{
using (var dc = new MySQLEntities())
{
if (district.iddistricts == Guid.Empty)
{
district.iddistricts = Guid.NewGuid();
dc.districts.Add(district);
dc.SaveChanges();
}
else
{
dc.Entry(district).State = EntityState.Modified;
dc.SaveChanges();
}
}
return(RedirectToAction("Districts"));
}
public ActionResult WorktypeDetails(worktypes worktype)
{
using (var dc = new MySQLEntities())
{
if (worktype.idWorkTypes == Guid.Empty)
{
worktype.idWorkTypes = Guid.NewGuid();
dc.worktypes.Add(worktype);
dc.SaveChanges();
}
else
{
dc.Entry(worktype).State = EntityState.Modified;
dc.SaveChanges();
}
}
return(RedirectToAction("Worktypes"));
}
public ActionResult WorkDetails(works work)
{
using (var dc = new MySQLEntities())
{
if (work.idWorks == Guid.Empty)
{
work.idWorks = Guid.NewGuid();
dc.works.Add(work);
dc.SaveChanges();
}
else
{
dc.Entry(work).State = EntityState.Modified;
dc.SaveChanges();
}
}
return(RedirectToAction("Works"));
//if (idWorksAsString == null)
//{
// return HttpNotFound();
//}
//try
//{
// using (var dc = new MySQLEntities())
// {
// Guid idWorks = new Guid(idWorksAsString);
// var elementMySQL = dc.works.Find(idWorks);
// return PartialView(elementMySQL);
// };
//}
//catch (Exception ex)
//{
//return HttpNotFound();
//}
}
