public void CreateStockItem(VoyagerContext db, ImportPurchase purchase, int pItemId) { Stock stcks = db.Stocks.Where(c => c.ProductItemId == pItemId).FirstOrDefault(); if (stcks != null) { stcks.PurchaseQty += purchase.Quantity; stcks.Quantity += purchase.Quantity; db.Entry(stcks).State = EntityState.Modified; } else { Stock stock = new Stock { PurchaseQty = purchase.Quantity, Quantity = purchase.Quantity, ProductItemId = pItemId, SaleQty = 0, Units = db.ProductItems.Find(pItemId).Units, StoreId = StoreID }; db.Stocks.Add(stock); } db.SaveChanges(); }
// Converting purchase items to stock public int ProcessPurchaseInward(VoyagerContext db, DateTime inDate, bool IsLocal) { int ctr = 0; var data = db.ImportPurchases.Where(c => c.IsDataConsumed == false && (c.GRNDate.Date) == (inDate.Date)).OrderBy(c => c.InvoiceNo).ToList(); if (data != null && data.Count > 0) { ProductPurchase PurchasedProduct = null; foreach (var item in data) { int pid = CreateProductItem(db, item); if (pid != -999) { CreateStockItem(db, item, pid); } PurchasedProduct = CreatePurchaseInWard(db, item, PurchasedProduct); PurchasedProduct.PurchaseItems.Add(CreatePurchaseItem(db, item, pid, IsLocal)); item.IsDataConsumed = true; db.Entry(item).State = EntityState.Modified; ctr++; } if (PurchasedProduct != null) { db.ProductPurchases.Add(PurchasedProduct); } db.SaveChanges(); } return(ctr); }
/// <summary> /// UpDate Stock when Sale or Purchase Happen /// </summary> /// <param name="db"></param> /// <param name="ItemCode"></param> /// <param name="Qty"></param> /// <param name="IsPurchased"></param> /// <returns></returns> public static bool UpDateStock(VoyagerContext db, int ItemCode, double Qty, bool IsPurchased, int StoreId) { var stock = db.Stocks.Where(c => c.ProductItemId == ItemCode && c.StoreId == StoreId).FirstOrDefault(); if (stock != null) { if (IsPurchased) { // Purchase Stock; stock.PurchaseQty += Qty; stock.Quantity += Qty; } else { //Sale Stock. stock.SaleQty += Qty; stock.Quantity -= Qty; } db.Entry(stock).State = EntityState.Modified; return(true); } else { return(false); } }
public ActionResult Edit([Bind(Include = "ImportPurchaseId,GRNNo,GRNDate,InvoiceNo,InvoiceDate,SupplierName,Barcode,ProductName,StyleCode,ItemDesc,Quantity,MRP,MRPValue,Cost,CostValue,TaxAmt,IsDataConsumed,ImportTime")] ImportPurchase importPurchase) { if (ModelState.IsValid) { db.Entry(importPurchase).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(importPurchase)); }
public ActionResult Edit([Bind(Include = "ImportSaleRegisterId,InvoiceNo,InvoiceType,InvoiceDate,Quantity,MRP,Discount,BasicRate,Tax,RoundOff,BillAmnt,PaymentType,ImportTime")] ImportSaleRegister importSaleRegister) { if (ModelState.IsValid) { db.Entry(importSaleRegister).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(importSaleRegister)); }
public ActionResult Edit([Bind(Include = "ImportInWardId,InWardNo,InWardDate,InvoiceNo,InvoiceDate,PartyName,TotalQty,TotalMRPValue,TotalCost,ImportDate")] ImportInWard importInWard) { if (ModelState.IsValid) { db.Entry(importInWard).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(importInWard)); }
public ActionResult Edit([Bind(Include = "SaleTaxTypeId,TaxName,TaxType,CompositeRate")] SaleTaxType saleTaxType) { if (ModelState.IsValid) { db.Entry(saleTaxType).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(saleTaxType)); }
public ActionResult Edit([Bind(Include = "ImportSaleItemWiseId,InvoiceDate,InvoiceNo,InvoiceType,BrandName,ProductName,ItemDesc,HSNCode,Barcode,StyleCode,Quantity,MRP,Discount,BasicRate,Tax,SGST,CGST,LineTotal,RoundOff,BillAmnt,PaymentType,Saleman,IsDataConsumed,ImportTime")] ImportSaleItemWise importSaleItemWise) { if (ModelState.IsValid) { db.Entry(importSaleItemWise).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(importSaleItemWise)); }
public ActionResult Edit([Bind(Include = "StoreID,StoreCode,StoreName,Address,City,PinCode,PhoneNo,StoreManagerName,StoreManagerPhoneNo,PanNo,GSTNO,NoOfEmployees,OpeningDate,ClosingDate,Status")] Store store) { if (ModelState.IsValid) { db.Entry(store).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(store)); }
public ActionResult Edit([Bind(Include = "CustomerID,FirstName,LastName,Age,DateOfBirth,City,MobileNo,Gender,NoOfBills,TotalAmount,CreatedDate")] Customer customer) { if (ModelState.IsValid) { db.Entry(customer).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(customer)); }
public ActionResult Edit([Bind(Include = "ProductPurchaseId,InWardNo,InWardDate,PurchaseDate,InvoiceNo,TotalQty,TotalBasicAmount,ShippingCost,TotalTax,TotalAmount,Remarks,SupplierID,IsPaid")] ProductPurchase productPurchase) { if (ModelState.IsValid) { db.Entry(productPurchase).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.SupplierID = new SelectList(db.Suppliers, "SupplierID", "SuppilerName", productPurchase.SupplierID); return(View(productPurchase)); }
public ActionResult Edit([Bind(Include = "StockID,ProductItemId,Quantity,SaleQty,PurchaseQty,Units")] Stock stock) { if (ModelState.IsValid) { db.Entry(stock).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.ProductItemId = new SelectList(db.ProductItems, "ProductItemId", "Barcode", stock.ProductItemId); return(View(stock)); }
public ActionResult Edit([Bind(Include = "ProductItemId,Barcode,BrandId,StyleCode,ProductName,ItemDesc,Categorys,MRP,TaxRate,Cost,Size,Units")] ProductItem productItem) { if (ModelState.IsValid) { db.Entry(productItem).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.BrandId = new SelectList(db.Brands, "BrandId", "BrandName", productItem.BrandId); return(View(productItem)); }
private async Task <Uri> AddBill(VoyagerBillInfo bill) { HttpResponseMessage response = await client.PostAsJsonAsync("api/VoyagerBills", bill); LogEvent.WriteEvent("Header:" + response.Headers.ToString()); LogEvent.WriteEvent("Content:" + response.Content.ToString()); LogEvent.WriteEvent("Status Code:" + response.StatusCode.ToString()); response.EnsureSuccessStatusCode(); if (response.IsSuccessStatusCode) { LogEvent.WriteEvent("Invocie is saved: " + bill.InvoiceNo); using (VoyagerContext db = new VoyagerContext()) { InsertDataLog log = db.InsertDataLogs.Where(c => c.BillNumber == bill.InvoiceNo).FirstOrDefault(); log.Remark = response.Content.ToString(); db.Entry(log).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); } } return(response.Headers.Location); }
private SaleItem CreateSaleItem(VoyagerContext db, ImportSaleItemWise item) { var pi = db.ProductItems.Where(c => c.Barcode == item.Barcode).Select(c => new { c.ProductItemId, c.Units }).FirstOrDefault(); if (pi == null) { //TODO: Handle for ProductItem Doesnt Exsist. //create item and stock int id = StockItem(db, item, out Units UNTS); pi = new { ProductItemId = id, Units = UNTS }; } SaleItem saleItem = new SaleItem { BarCode = item.Barcode, MRP = item.MRP, BasicAmount = item.BasicRate, Discount = item.Discount, Qty = item.Quantity, TaxAmount = item.SGST + item.CGST, BillAmount = item.LineTotal, Units = pi.Units, ProductItemId = pi.ProductItemId, SalesmanId = GetSalesmanId(db, item.Saleman), SaleTaxTypeId = CreateSaleTax(db, item) }; if (!SalePurchaseManager.UpDateStock(db, pi.ProductItemId, item.Quantity, false)) { //TODO: Create Stock and update CreateStockItem(db, saleItem.Qty, saleItem.ProductItemId, saleItem.Units); } item.IsDataConsumed = true; db.Entry(item).State = EntityState.Modified; return(saleItem); }