public JsonResult SaveOrder(BillVm O)
{
bool status = false;
if (ModelState.IsValid)
{
//Order order = new Order { OrderNo = O.OrderNo, OrderDate = O.OrderDate, Description = O.Description };
BillRegister billregister = new BillRegister {
BillDate = O.billdate, Remarks = O.remarks, memberId = O.memberid, paid = "N"
};
db.BillRegisters.Add(billregister);
db.SaveChanges();
foreach (var i in O.BillDetail)
{
//
// i.TotalAmount =
Billdetail billdetail = new Billdetail();
billdetail.BillID = billregister.BillID;
billdetail.HeaderId = i.headerid;
billdetail.Amount = i.amount;
db.Billdetail.Add(billdetail);
db.SaveChanges();
}
status = true;
}
else
{
status = false;
}
return(new JsonResult {
Data = new { status = status }
});
}
// GET: Bill
public ActionResult billDetail(int page = 1, int pageSize = 10)
{
List <BillVm> billVmList = new List <BillVm>();
var billList = (from bil in db.Bills
join cust in db.Customers on bil.customer_id equals cust.customer_id
select new { cust.customer_name, cust.customer_surname, bil.customer_id, bil.bill_total, bil.bill_date, bil.bill_id });
foreach (var item in billList)
{
BillVm billVm = new BillVm();
billVm.bill_id = item.bill_id;
billVm.customer_id = item.customer_id;
billVm.customer_name = item.customer_name;
billVm.customer_surname = item.customer_surname;
billVm.bill_total = item.bill_total;
billVm.bill_date = item.bill_date;
billVmList.Add(billVm);
}
PagedList <BillVm> billInfo = new PagedList <BillVm>(billVmList, page, pageSize);
return(View(billInfo));
}
