public ActionResult checkout(tbl_order O)
{
List <cart> li = TempData["cart"] as List <cart>;
tbl_invoice iv = new tbl_invoice();
iv.in_fk_user = Convert.ToInt32(Session["u_id"].ToString());
iv.in_date = System.DateTime.Now;
iv.in_totalbill = (float)TempData["total"];
db.tbl_invoice.Add(iv);
db.SaveChanges();
foreach (var item in li)
{
tbl_order od = new tbl_order();
od.o_fk_pro = item.productid;
od.o_fk_invoice = iv.in_id;
od.o_date = System.DateTime.Now;
od.o_qty = item.qty;
od.o_unitprice = (int)item.price;
od.o_bill = item.bill;
db.tbl_order.Add(od);
db.SaveChanges();
}
TempData.Remove("total");
TempData.Remove("cart");
TempData.Remove("cartto");
TempData["msg"] = "Transaction Completed...";
TempData.Keep();
return(RedirectToAction("Index"));
}
public ActionResult Total(Order order)
{
List <Cart> li = TempData["cart"] as List <Cart>;
tbl_invoice iv = new tbl_invoice();
iv.CustomerId = Convert.ToInt32(Session["CustomerId"].ToString());
iv.InvoiceDate = System.DateTime.Now;
iv.Invoice_TotalBill = Convert.ToDecimal(TempData["total"]);
db.tbl_invoice.Add(iv);
db.SaveChanges();
foreach (var item in li)
{
Order o = new Order();
o.NewspaperId = item.PaperId;
// o.Newspaper.NewspaperName = item.PaperName;
o.InvoiceId = iv.InvoiceId;
o.OrderDate = System.DateTime.Now;
o.Order_Unitprice = Convert.ToInt32(item.price);
o.OrderQty = item.qty;
o.OrderBill = decimal.ToDouble(item.bill);
db.Orders.Add(o);
db.SaveChanges();
}
TempData.Remove("total");
TempData.Remove("cart");
TempData["message"] = "Transaction completed";
TempData.Keep();
return(RedirectToAction("Index", "Payment"));
}
public ActionResult DeleteConfirmed(Guid id)
{
tbl_invoice tbl_invoice = db.tbl_invoice.Find(id);
db.tbl_invoice.Remove(tbl_invoice);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public IHttpActionResult Posttbl_invoice(tbl_invoice tbl_invoice)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
ICollection <tbl_invoiceDetail> details = tbl_invoice.tbl_invoiceDetail;
tbl_invoice.tbl_invoiceDetail = null;
tbl_invoice.tbl_table = null;
tbl_invoice.tbl_user = null;
db.tbl_invoice.Add(tbl_invoice);
try
{
db.SaveChanges();
}
catch (DbUpdateException)
{
if (tbl_invoiceExists(tbl_invoice.id))
{
return(Conflict());
}
else
{
throw;
}
}
if (details != null)
{
foreach (var item in details)
{
try
{
item.tbl_invoice = null;
db.tbl_invoiceDetail.Add(item);
db.SaveChanges();
}
catch (DbUpdateException)
{
if (db.tbl_invoiceDetail.Count(e => e.invoice_id == item.invoice_id && e.name.Equals(item.name)) > 0)
{
return(Conflict());
}
else
{
throw;
}
}
}
}
return(CreatedAtRoute("DefaultApi", new { id = tbl_invoice.id }, tbl_invoice));
}
public IHttpActionResult Gettbl_invoice(Guid id)
{
tbl_invoice tbl_invoice = db.tbl_invoice.Find(id);
if (tbl_invoice == null)
{
return(NotFound());
}
return(Ok(tbl_invoice));
}
public ActionResult Edit([Bind(Include = "id,code,table_id,user_id,time_in,time_out,date,total")] tbl_invoice tbl_invoice)
{
if (ModelState.IsValid)
{
db.Entry(tbl_invoice).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.table_id = new SelectList(db.tbl_table, "id", "code", tbl_invoice.table_id);
ViewBag.user_id = new SelectList(db.tbl_user, "id", "user_name", tbl_invoice.user_id);
return(View(tbl_invoice));
}
public ActionResult Put([FromBody] tbl_invoice entity)
{
//if (_invoiceService.UpdateInvoice(entity))
//{
// return Ok();
//}
//else
//{
// return BadRequest();
//}
return(Ok());
}
public ActionResult Create([Bind(Include = "id,code,table_id,user_id,time_in,time_out,date,total")] tbl_invoice tbl_invoice)
{
if (ModelState.IsValid)
{
tbl_invoice.id = Guid.NewGuid();
db.tbl_invoice.Add(tbl_invoice);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.table_id = new SelectList(db.tbl_table, "id", "code", tbl_invoice.table_id);
ViewBag.user_id = new SelectList(db.tbl_user, "id", "user_name", tbl_invoice.user_id);
return(View(tbl_invoice));
}
// GET: Invoice/Details/5
public ActionResult Details(Guid?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
tbl_invoice tbl_invoice = db.tbl_invoice.Find(id);
if (tbl_invoice == null)
{
return(HttpNotFound());
}
return(View(tbl_invoice));
}
// GET: Invoice/Edit/5
public ActionResult Edit(Guid?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
tbl_invoice tbl_invoice = db.tbl_invoice.Find(id);
if (tbl_invoice == null)
{
return(HttpNotFound());
}
ViewBag.table_id = new SelectList(db.tbl_table, "id", "code", tbl_invoice.table_id);
ViewBag.user_id = new SelectList(db.tbl_user, "id", "user_name", tbl_invoice.user_id);
return(View(tbl_invoice));
}
public void kbcc()
{
tbl_invoice iv = new tbl_invoice();
if (TempData["card"] != null)
{
float x = 0;
List <card> li2 = TempData["card"] as List <card>;
foreach (var item in li2)
{
x += item.pro_product_Bill;
}
TempData["total"] = x;
}
TempData.Keep();
}
public ActionResult Login(User_LoginClass userModel, tbl_order o)
{
using (DBModels db = new DBModels())
{
var userDetails = db.User_Login.Where(x => x.Email == userModel.Email && x.Password == userModel.Password).FirstOrDefault();
var admin = db.User_Login.Where(x => x.Email == "*****@*****.**" && x.Password == "12345").FirstOrDefault();
if (userDetails == null)
{
userModel.LoginErrorMessage = "*Wrong User Name Or Password.";
return(View("Login", userModel));
}
else if (userDetails == admin)
{
Session["Login_id"] = userDetails.Login_id;
ViewData["Message"] = "User Record" + userModel.Email + "Is Login Successfully!";
return(RedirectToAction("ViewRegisterFood"));
}
else
{
Session["Login_id"] = userDetails.Login_id;
List <card> li = TempData["card"] as List <card>;
tbl_invoice iv = new tbl_invoice();
iv.in_fk_Login_id = Convert.ToInt32(Session["Login_id"].ToString());
if (TempData["card"] != null)
{
iv.in_Date_Time = System.DateTime.Now;
iv.in_total_bill = (float)TempData["total"];
db.tbl_invoice.Add(iv);
db.SaveChanges();
foreach (var item in li)
{
tbl_order od = new tbl_order();
od.o_fk_pro_Food_id = item.pro_product_id;
od.o_fk_in_id = iv.in_id;
od.o_Date_Time = System.DateTime.Now;
od.o_Quantity = item.qty;
od.o_unitprice = (int)item.pro_product_Price;
od.o_bill = item.pro_product_Bill;
db.tbl_order.Add(od);
db.SaveChanges();
}
TempData.Remove("total");
TempData.Remove("card");
TempData["msg"] = "Transaction Completed....";
TempData.Keep();
return(RedirectToAction("EveryDayValue", "Home", userModel));
}
else
{
userModel.LoginErrorMessage = "*Cart is Empty";
return(View("Login", userModel));
}
}
}
}
public ActionResult getInvoice(InvoiceBasic obj)
{
var id = "";
tbl_invoice objuser = new tbl_invoice();
string voucher = obj.voucher;
string invoice_id = voucher;
string actionType = obj.actionType;
if (actionType == "insert")
{
objuser.invoice_id = invoice_id;
objuser.voucher = obj.voucher;
objuser.voucherArabic = obj.voucherArabic;
objuser.cash_party_acc = obj.cash_party_acc;
objuser.type = obj.type;
objuser.acc_id = obj.acc_id;
objuser.remarks = obj.remarks;
objuser.depot_loc = obj.depot_loc;
objuser.purchase_acc = obj.purchase_acc;
objuser.date = obj.date;
objuser.party_vno = obj.party_vno;
objuser.spl_disc = obj.spl_disc;
objuser.gst = obj.gst;
objuser.addl_per = obj.addl_per;
objuser.invoice_type = "2";
objuser.created_at = DateTime.Now;
objuser.updated_at = DateTime.Now;
objuser.tot_net = obj.tot_net;
objuser.tot_qty = obj.tot_qty;
objuser.tot_gross = obj.tot_gross;
entityOBJ.tbl_invoice.Add(objuser);
if (entityOBJ.SaveChanges() > 0)
{
id = Convert.ToString(entityOBJ.tbl_invoice.Max(item => item.id));
if (obj.acc_id == "custom")
{
tbl_custominvoice customeOBJ = new tbl_custominvoice();
customeOBJ.invoice_id = obj.voucher;
customeOBJ.party_name = obj.party_name;
customeOBJ.party_name = obj.party_name;
customeOBJ.party_vno = obj.party_vno;
entityOBJ.tbl_custominvoice.Add(customeOBJ);
entityOBJ.SaveChanges();
}
}
else
{
id = "failed";
}
}
else
{
id = Convert.ToString(obj.id);
int idint = obj.id;
var singleRec = entityOBJ.tbl_invoice.FirstOrDefault(x => x.id == idint);
entityOBJ.tbl_invoice.Remove(singleRec);
List <tbl_purchaseInvoice> deps = entityOBJ.tbl_purchaseInvoice.Where(x => x.invoice_id == id).ToList();
entityOBJ.tbl_purchaseInvoice.RemoveRange(deps);
entityOBJ.SaveChanges();
objuser.invoice_id = invoice_id;
objuser.voucher = obj.voucher;
objuser.voucherArabic = obj.voucherArabic;
objuser.cash_party_acc = obj.cash_party_acc;
objuser.type = obj.type;
objuser.acc_id = obj.acc_id;
objuser.remarks = obj.remarks;
objuser.depot_loc = obj.depot_loc;
objuser.purchase_acc = obj.purchase_acc;
objuser.date = obj.date;
objuser.party_vno = obj.party_vno;
objuser.spl_disc = obj.spl_disc;
objuser.gst = obj.gst;
objuser.addl_per = obj.addl_per;
objuser.invoice_type = "2";
objuser.created_at = DateTime.Now;
objuser.updated_at = DateTime.Now;
objuser.tot_net = obj.tot_net;
objuser.tot_qty = obj.tot_qty;
objuser.tot_gross = obj.tot_gross;
entityOBJ.tbl_invoice.Add(objuser);
if (entityOBJ.SaveChanges() > 0)
{
id = Convert.ToString(entityOBJ.tbl_invoice.Max(item => item.id));
if (obj.acc_id == "custom")
{
tbl_custominvoice customeOBJ = new tbl_custominvoice();
customeOBJ.invoice_id = obj.voucher;
customeOBJ.party_name = obj.party_name;
customeOBJ.party_name = obj.party_name;
customeOBJ.party_vno = obj.party_vno;
entityOBJ.tbl_custominvoice.Add(customeOBJ);
entityOBJ.SaveChanges();
}
}
else
{
id = "failed";
}
}
return(Json(id, JsonRequestBehavior.AllowGet));
}
public IHttpActionResult Puttbl_invoice(Guid id, tbl_invoice tbl_invoice)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != tbl_invoice.id)
{
return(BadRequest());
}
ICollection <tbl_invoiceDetail> newDetails = tbl_invoice.tbl_invoiceDetail;
tbl_invoice.tbl_invoiceDetail = null;
tbl_invoice.tbl_table = null;
tbl_invoice.tbl_user = null;
db.Entry(tbl_invoice).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!tbl_invoiceExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
if (newDetails != null)
{
ICollection <tbl_invoiceDetail> oldDetails = db.tbl_invoiceDetail.Where(e => e.tbl_invoice.id == id).ToList();
foreach (var oldDetail in oldDetails)
{
if (!(newDetails.Count(e => e.invoice_id == oldDetail.invoice_id && e.name.Equals(oldDetail.name)) > 0))
{
if (oldDetail != null)
{
oldDetail.tbl_invoice = null;
db.tbl_invoiceDetail.Remove(oldDetail);
db.SaveChanges();
}
}
}
foreach (var item in newDetails)
{
tbl_invoiceDetail temp = db.tbl_invoiceDetail.FirstOrDefault(e => e.invoice_id == item.invoice_id && e.name.Equals(item.name));
if (temp == null)
{
item.tbl_invoice = null;
db.tbl_invoiceDetail.Add(item);
}
else
{
temp.name = item.name;
temp.price = item.price;
temp.amount = item.amount;
temp.tbl_invoice = null;
db.Entry(temp).State = EntityState.Modified;
}
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!(db.tbl_invoiceDetail.Count(e => e.invoice_id == item.invoice_id && e.name.Equals(item.name)) > 0))
{
return(NotFound());
}
else
{
throw;
}
}
}
}
return(StatusCode(HttpStatusCode.OK));
}
public bool DeleteInvoice(tbl_invoice entity)
{
return(invoiceRepository.Delete(entity));
}
public int RegisterInvoice(tbl_invoice entity)
{
return(invoiceRepository.Insert(entity));
}
public bool UpdateInvoice(tbl_invoice entity)
{
return(invoiceRepository.Update(entity));
}
