// Add Function
public int Add(decimal GSTamount, decimal Discount, decimal GrandTotal, int Customer_ID, decimal Quantity, decimal delivery, decimal OtherExpences, string Comment, string PaymentMode, decimal Subtotal, decimal GST, 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);
Sales_Bill sales_Bill = new Sales_Bill();
if (Id != 0)
{
sales_Bill = db.Sales_Bill.Where(e => e.Sales_Bill_No == Id).FirstOrDefault();
sales_Bill.Date_Modified = DateTime.Now;
}
else
{
sales_Bill.Date_Created = DateTime.Now;
}
sales_Bill.Company_ID = compid;
sales_Bill.Delivery = delivery;
sales_Bill.Discount = Discount;
sales_Bill.Customer_ID = Customer_ID;
sales_Bill.GST_Amount = GSTamount;
sales_Bill.Quantity = Quantity;
sales_Bill.Other_Expenses = OtherExpences;
sales_Bill.Payment_Mode = PaymentMode;
sales_Bill.Comment = Comment;
sales_Bill.Total_Amount = GrandTotal;
sales_Bill.GST = GST;
sales_Bill.SubTotal = Subtotal;
if (Id != 0)
{
db.Entry(sales_Bill).State = EntityState.Modified;
}
else
{
db.Sales_Bill.Add(sales_Bill);
}
db.SaveChanges();
var Sales_Bill_Id = db.Sales_Bill.Where(e => e.Company_ID == compid && e.Customer_ID == Customer_ID && e.Total_Amount == GrandTotal).Select(e => e.Sales_Bill_No).FirstOrDefault();
return(Sales_Bill_Id);
}
// Delete
public ActionResult Delete(int id)
{
var salesitem = db.Sales_Bill_item.Where(e => e.Sales_Bill_No == id).ToList();
foreach (var item in salesitem)
{
var items = db.Sales_Bill_item.Where(e => e.Sales_Bill_item_ID == item.Sales_Bill_item_ID).FirstOrDefault();
db.Sales_Bill_item.Remove(items);
db.SaveChanges();
}
Sales_Bill sales_Bill = db.Sales_Bill.Find(id);
db.Sales_Bill.Remove(sales_Bill);
db.SaveChanges();
return(RedirectToAction("Index"));
}
// Create Partial
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.Customer = db.Customer_Details.Where(e => e.Customer_Id == compid).ToList();
ViewBag.Customers = db.Customer_Details.Where(e => e.Company_Id == compid).ToList();
ViewBag.Products = db.Products_Details.Where(e => e.Company_Id == compid).ToList();
Sales_Bill sales_Bill = new Sales_Bill();
if (id != null)
{
sales_Bill = db.Sales_Bill.Where(c => c.Sales_Bill_No == id).FirstOrDefault();
}
return(PartialView(sales_Bill));
}
