public ActionResult DeleteConfirmed(int id)
{
PurchaseInvoiceMaster purchaseInvoicemaster = db.PurchaseInvoicemasters.Find(id);
db.PurchaseInvoicemasters.Remove(purchaseInvoicemaster);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public PurchaseInvoiceMaster AddPurchaseInvoicemaster(PurchaseViewModel str)
{
PurchaseInvoiceMaster pur = new PurchaseInvoiceMaster();
pur.CustomerID = str.CustomerID;
pur.PurchaseInvoiceNum = str.SupplierInvoice;
pur.PurchaseDate = str.PurchaseDate;
pur.InvoiceDate = str.SupplierInvoiceDate;
pur.TotalBill = str.InvoiceValue;
pur.TotalPaid = str.InvoiceValue;
pur.TotalDiscount = 0;
pur.StoreID = int.Parse(System.Web.HttpContext.Current.Session["storeid"].ToString());
pur.AddedUser = System.Web.HttpContext.Current.Session["username"].ToString();
pur.AddedDate = DateTime.Now;
pur.IsDeleted = false;
pur.IsCommited = false;
cntxt.PurchaseInvoicemasters.Add(pur);
cntxt.SaveChanges();
foreach (PurchasedetailViewModel strdet in str.purchasedetailViewModels)
{
PurchaseInvoiceDetail purchaseInvoiceDetail = new PurchaseInvoiceDetail();
purchaseInvoiceDetail.PurchaseInvoicemasterID = pur.PurchaseInvoicemasterID;
purchaseInvoiceDetail.CategoryID = strdet.CategoryID;
purchaseInvoiceDetail.ItemNameId = strdet.ItemNameID;
purchaseInvoiceDetail.ProductName = strdet.ProductDetails;
purchaseInvoiceDetail.Qty = strdet.TotalQty;
purchaseInvoiceDetail.SerialNum = strdet.Serial;
purchaseInvoiceDetail.TotalPrice = strdet.TotalPrice;
purchaseInvoiceDetail.UnitCP = strdet.UnitPrice;
purchaseInvoiceDetail.UnitSP = strdet.SellingPrice;
purchaseInvoiceDetail.CGSTPercent = strdet.CGSTPercent;
purchaseInvoiceDetail.SGSTPercent = strdet.SGSTPercent;
purchaseInvoiceDetail.UnitCGSTCP = 0;
purchaseInvoiceDetail.UnitSGSTSP = 0;
purchaseInvoiceDetail.UserID = 0;
purchaseInvoiceDetail.AddedUser = System.Web.HttpContext.Current.Session["username"].ToString();
purchaseInvoiceDetail.AddedDate = DateTime.Now;
purchaseInvoiceDetail.IsDeleted = false;
cntxt.PurchaseInvoiceDetails.Add(purchaseInvoiceDetail);
}
cntxt.SaveChanges();
return(pur);
}
// GET: POS/PurchaseInvoicemasters/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
PurchaseInvoiceMaster purchaseInvoicemaster = db.PurchaseInvoicemasters.Find(id);
if (purchaseInvoicemaster == null)
{
return(HttpNotFound());
}
return(View(purchaseInvoicemaster));
}
public PurchaseViewModel GetPurchaseViewModal(int id)
{
PurchaseViewModel purchaseviewNodal = new PurchaseViewModel();
PurchaseInvoiceMaster invmstr = GetPurchaseInvoicemaster(id);
purchaseviewNodal.SupplierInvoice = invmstr.PurchaseInvoiceNum;
purchaseviewNodal.SupplierInvoiceDate = invmstr.InvoiceDate;
purchaseviewNodal.PurchaseDate = invmstr.PurchaseDate;
purchaseviewNodal.CustomerID = invmstr.CustomerID;
purchaseviewNodal.InvoiceValue = invmstr.TotalBill;
purchaseviewNodal.PaidValue = invmstr.TotalPaid;
//foreach (PurchaseInvoiceDetail in invmstr.PurchaseInvoiceDetails ){
//}
return(purchaseviewNodal);
}
public PurchaseInvoiceMaster CommitAction(Boolean iscommit, int id)
{
PurchaseInvoiceMaster q = (from purmaster in cntxt.PurchaseInvoicemasters
where purmaster.PurchaseInvoicemasterID == id
select purmaster).FirstOrDefault();
q.IsCommited = true;
foreach (PurchaseInvoiceDetail element in q.PurchaseInvoiceDetails)
{
for (int i = 0; i < element.Qty; i++)
{
string defaultkey = element.PurchaseInvoicemaster.PurchaseInvoicemasterID.ToString() + "-" + element.PurchaseInvoiceDetailID.ToString() + "-" + i.ToString();
Product product = new Product();
product.ProductName = element.ProductName;
product.CategoryId = element.CategoryID;
product.ItemNameId = element.ItemNameId;
product.Qty = 1;
product.SerialNum = GetSerial(element.SerialNum, i, defaultkey);
product.NonTaxCP = element.UnitCP;
product.UnitCP = element.UnitCP;
product.UnitPrice = element.UnitCP;
product.UnitSP = element.UnitSP;
product.CGSTpercent = element.CGSTPercent;
product.SGSTPercent = element.SGSTPercent;
product.DiscountForLocation = 0;
product.MinimumSPForLocation = 0;
product.Taxamount = 0;
product.IsDelivered = false;
product.IsAvailable = true;
product.Isactive = true;
product.IsRateChangable = true;
product.IsTodaySpecial = true;
product.Color = "Red";
product.StoreID = int.Parse(System.Web.HttpContext.Current.Session["storeid"].ToString());
product.CGSTpercent = element.CGSTPercent;
product.SGSTPercent = element.SGSTPercent;
product.PurchaseInvoiceDetailID = element.PurchaseInvoiceDetailID;
cntxt.Products.Add(product);
}
}
cntxt.SaveChanges();
return(q);
}
// GET: POS/PurchaseInvoicemasters/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
PurchaseInvoiceMaster purchaseInvoicemaster = db.PurchaseInvoicemasters.Find(id);
if (purchaseInvoicemaster == null)
{
return(HttpNotFound());
}
ViewBag.CategoryID = new SelectList(db.Categories, "Id", "CategoryName");
ViewBag.ItemNameID = new SelectList(db.ItemNames, "Id", "ItemDesc");
ViewBag.CustomerID = new SelectList(db.Customers, "CustomerID", "CustomerName", purchaseInvoicemaster.CustomerID);
ViewBag.StoreID = new SelectList(db.Stores, "StoreID", "StoreName", purchaseInvoicemaster.StoreID);
return(View(purchaseInvoicemaster));
}
