public JsonResult Customertable()
{
using (var db = new CobraOnboarddbEntities())
{
var customer = db.People.Where(x => x.IsActive == true).Select(x => new { x.Id, x.Name, x.Address1, x.Address2, x.City }).ToList();
return(new JsonResult {
Data = customer, JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
}
public JsonResult DeleteCustomer(string data)
{
using (var db = new CobraOnboarddbEntities())
{
int custId = Convert.ToInt16(data);
var deletecust = db.People.Where(x => x.Id == custId).FirstOrDefault();
{
deletecust.IsActive = false;
}
db.SaveChanges();
}
return(new JsonResult());
}
public JsonResult DeleteOrder(string orderId)
{
using (var db = new CobraOnboarddbEntities())
{
int OrdId = Convert.ToInt16(orderId);
var orderheaders = db.OrderHeaders.Where(x => x.Id == OrdId).FirstOrDefault();
db.OrderHeaders.Remove(orderheaders);
var orderdetails = db.OrderDetails.Where(x => x.OderId == OrdId).FirstOrDefault();
db.OrderDetails.Remove(orderdetails);
db.SaveChanges();
}
return(new JsonResult());
}
public JsonResult Getorders()
{
using (var db = new CobraOnboarddbEntities())
{
var orders = db.OrderHeaders.Join(db.People, ord => ord.PersonId, peo => peo.Id,
(ord, peo) => new { ord, peo })
.Join(db.OrderDetails, od => od.ord.Id, odt => odt.OderId, (od, odt) => new { od, odt })
.Join(db.Products, p => p.odt.ProductId, pro => pro.Id, (p, pro) => new { p, pro })
.Select(x => new { x.p.od.ord.Id, x.p.od.ord.OrderDate, x.p.od.peo, x.pro, x.pro.Price }).ToList();
return(new JsonResult {
Data = orders, JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
}
public JsonResult GetCP()
{
using (var db = new CobraOnboarddbEntities())
{
var list = new GetCPViewmodel();
{
list.Person = db.People.Where(x => x.IsActive == true).ToList();
list.Product = db.Products.ToList();
}
return(new JsonResult {
Data = list, JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
}
public JsonResult EditOrder(EditOrderViewModel order)
{
using (var db = new CobraOnboarddbEntities())
{
var orderdetails = db.OrderHeaders.Where(x => x.Id == order.Id).FirstOrDefault();
{
orderdetails.PersonId = order.Ord.CustomerId;
}
var orderheader = db.OrderDetails.Where(x => x.OderId == order.Id).FirstOrDefault();
{
orderheader.ProductId = order.Ord.ProductId;
}
db.SaveChanges();
}
return(new JsonResult());
}
public JsonResult Customer(PersonViewModel person)
{
using (var db = new CobraOnboarddbEntities())
{
var customer = new Person()
{
Name = person.Name,
Address1 = person.Address1,
Address2 = person.Address2,
City = person.City,
IsActive = true
};
db.People.Add(customer);
db.SaveChanges();
var customerlist = db.People.Select(x => new { x.Id, x.Name, x.Address1, x.Address2, x.City }).ToList();
return(new JsonResult {
Data = customerlist, JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
}
public JsonResult EditCust(EditPersonViewModel person)
{
using (var db = new CobraOnboarddbEntities())
{
//int id = Convert.ToInt32(Id);
var editcustomer = db.People.Where(x => x.Id == person.Id).FirstOrDefault();
editcustomer.Name = person.Pers.Name;
editcustomer.Address1 = person.Pers.Address1;
editcustomer.Address2 = person.Pers.Address2;
editcustomer.City = person.Pers.City;
db.SaveChanges();
var customer = db.People.Select(x => new { x.Id, x.Name, x.Address1, x.Address2, x.City }).ToList();
return(new JsonResult {
Data = customer, JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
}
public JsonResult AddOrder(OrderViewModel order)
{
using (var db = new CobraOnboarddbEntities())
{
var orderheader = new OrderHeader()
{
OrderDate = DateTime.Now,
PersonId = order.CustomerId
};
db.OrderHeaders.Add(orderheader);
db.SaveChanges();
var orderdetails = new OrderDetail()
{
OderId = orderheader.Id,
ProductId = order.ProductId
};
db.OrderDetails.Add(orderdetails);
db.SaveChanges();
}
return(new JsonResult());
}
