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