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));
}
