public int Add(decimal GST, decimal GSTamount, decimal Discount, decimal GrandTotal, int Supplier_ID, decimal Quantity, decimal Transport_Charge, decimal OtherExpences, string Comment, string PaymentMode, decimal Subtotal, int Id) { string Company_Id = string.Empty; HttpCookie myCookie = Request.Cookies["inventoryCookie"]; if (!string.IsNullOrEmpty(myCookie.Values["Company_Id"])) { Company_Id = myCookie.Values["Company_Id"].ToString(); } var compid = Convert.ToInt32(Company_Id); Purchase_Bill purchase = new Purchase_Bill(); if (Id != 0) { purchase = db.Purchase_Bill.Where(e => e.Bill_No == Id).FirstOrDefault(); purchase.Date_Modified = DateTime.Now; } else { purchase.Date_Created = DateTime.Now; } purchase.Date_Created = DateTime.Now; purchase.Company_Id = compid; purchase.Supplier_ID = Supplier_ID; purchase.Quantity = Quantity; purchase.Discount = Discount; purchase.GST_Amount = GSTamount; purchase.Total_Amount = GrandTotal; purchase.Comment = Comment; purchase.Transport_Charges = Transport_Charge; purchase.Other_Expenses = OtherExpences; purchase.Payment_Mode = PaymentMode; purchase.GST = GST; purchase.SubTotal = Subtotal; db.Purchase_Bill.Add(purchase); if (Id != 0) { db.Entry(purchase).State = EntityState.Modified; } else { db.Purchase_Bill.Add(purchase); } db.SaveChanges(); var Bill_Id = db.Purchase_Bill.Where(e => e.Company_Id == compid && e.Supplier_ID == Supplier_ID && e.Total_Amount == GrandTotal).Select(e => e.Bill_No).FirstOrDefault(); return(Bill_Id); }
public ActionResult Delete(int id) { var PurchaseBill_item = db.Purchase_Bill_Item.Where(e => e.Purchase_Bill_ID == id).ToList(); foreach (var item in PurchaseBill_item) { var items = db.Purchase_Bill_Item.Where(e => e.Purchase_item_ID == item.Purchase_item_ID).FirstOrDefault(); db.Purchase_Bill_Item.Remove(items); db.SaveChanges(); } Purchase_Bill purchase_Bill = db.Purchase_Bill.Find(id); db.Purchase_Bill.Remove(purchase_Bill); db.SaveChanges(); return(RedirectToAction("Index")); }
private void Save_btn_Click(object sender, EventArgs e) { Purchase_Bill Purchase_Bill = new Purchase_Bill(); Purchase_Bill.PO_ID = (int)PONo_txt.SelectedValue; Purchase_Bill.Date = Date_txt.Value; Purchase_Bill.V_ID = (int)Vender_txt.SelectedValue; Purchase_Bill.Total = this.Total_Amount; Purchase_Bill.Balance = this.Balance_Amount; Purchase_Bill.items = ((List <ItemViewModel>)dataGridView1.DataSource) .Select(x => new Purchase_Bill_Item() { Item_ID = x.I_ID, item = dbContext.Items.Where(y => y.I_ID == x.I_ID).FirstOrDefault(), Quantity = x.Quantity, Purchase_Amount = x.Quoted_Amount }).ToList(); dbContext.Purchase_Bills.Add(Purchase_Bill); dbContext.SaveChanges(); }
public PartialViewResult CreatePartial(int?id) { string Company_Id = string.Empty; HttpCookie myCookie = Request.Cookies["inventoryCookie"]; if (!string.IsNullOrEmpty(myCookie.Values["Company_Id"])) { Company_Id = myCookie.Values["Company_Id"].ToString(); } var compid = Convert.ToInt32(Company_Id); ViewBag.Date = DateTime.Now.ToString("MM/dd/yyyy"); ViewBag.Supplier = db.Supplier_Details.Where(e => e.Company_Id == compid).ToList(); ViewBag.Products = db.Products_Details.Where(e => e.Company_Id == compid).ToList(); Purchase_Bill bill = new Purchase_Bill(); if (id != null) { bill = db.Purchase_Bill.Where(c => c.Bill_No == id).FirstOrDefault(); } return(PartialView(bill)); }