public void AcceptReturnToSupplier(string LocationID, string VendorID, string StorageID, string DocID) { try { List <tbl_Company> Company = Context.Company.Get().ToList(); string CompanyID = Company.FirstOrDefault().CompanyID; tbl_StockReceive stockRecieve = new tbl_StockReceive(); int Increment = Convert.ToInt32(DocID) + 1; stockRecieve.DocumentID = LocationID + Increment; stockRecieve.PONumber = LocationID + Increment; stockRecieve.CompanyID = CompanyID; stockRecieve.LocationID = LocationID; stockRecieve.StorageID = StorageID; stockRecieve.DocumentDate = DateTime.Now; stockRecieve.PostingDate = DateTime.Now; stockRecieve.VendorID = VendorID; stockRecieve.Amount = 0.00M; stockRecieve.Discount = 0.00M; stockRecieve.NetValue = 0.00M; stockRecieve.UserID = "Vinod"; stockRecieve.AddDate = DateTime.Now; Context.StockReceive.Insert(stockRecieve); Context.StockReceive.Save(); DocID = null; } catch (Exception ex) { } }
public void AcceptPO(Dictionary <string, string> dictPO, string docid) { tbl_PurchaseOrder PO = Context.PurchaseOrder.Get(e => e.DocumentID == docid && e.POStatus == "Open").FirstOrDefault(); List <tbl_PurchaseOrder_Detail> lstPODetail = Context.PurchaseOrderDetail.Get(e => e.DocumentID == docid).ToList(); bool isChanged = false; tbl_StockReceive stockRecieve = new tbl_StockReceive(); stockRecieve.DocumentID = docid; stockRecieve.PONumber = docid; stockRecieve.CompanyID = PO.CompanyID; stockRecieve.LocationID = PO.LocationID; stockRecieve.StorageID = PO.StorageID; stockRecieve.DocumentDate = PO.DocumentDate; stockRecieve.PostingDate = PO.PostingDate; stockRecieve.VendorID = PO.VendorID; stockRecieve.Amount = PO.Amount; stockRecieve.Discount = PO.Discount; stockRecieve.NetValue = PO.NetValue; stockRecieve.UserID = PO.UserID; stockRecieve.AddDate = PO.AddDate; stockRecieve.Dataid = PO.Dataid; Context.StockReceive.Insert(stockRecieve); Context.StockReceive.Save(); foreach (tbl_PurchaseOrder_Detail POD in lstPODetail) { decimal qty = Convert.ToDecimal(dictPO[POD.MaterialID]); if (POD.TranQty != qty) { isChanged = true; } tbl_StockReceive_Detail srd = new tbl_StockReceive_Detail(); srd.DocumentID = POD.DocumentID; srd.CompanyID = POD.CompanyID; srd.LocationID = POD.LocationID; srd.StorageID = POD.StorageID; srd.DocumentDate = POD.DocumentDate; srd.PostingType = POD.PostingType; srd.PostingDate = POD.PostingDate; srd.VendorID = POD.VendorID; srd.Counter = POD.Counter; srd.CategoryID = POD.CategoryID; srd.MaterialID = POD.MaterialID; srd.UOM = POD.UOM; srd.TranQty = qty; srd.BaseQty = qty; srd.CreditQty = POD.CreditQty; srd.Cost = POD.Cost; srd.DiscountRate = POD.DiscountRate; srd.Amount = POD.Amount; srd.CreditAmount = POD.CreditAmount; srd.UserID = POD.UserID; srd.PostKey = POD.PostKey; srd.AddDate = DateTime.Now; srd.UpdDate = DateTime.Now; srd.Dataid = POD.Dataid; srd.OrderQty = qty; Context.StockReceiveDetail.Insert(srd); } Context.StockReceiveDetail.Save(); if (isChanged) { PO.POStatus = "Pending"; } else { PO.POStatus = "Complete"; } Context.PurchaseOrder.Update(PO); Context.PurchaseOrder.Save(); }