public JsonResult GetTIByDocID(string DOCID) { ViewBag.Page = "Transfter IN"; tbl_TransferOut PO = TransactionBL.GetTIOrderByDocID(DOCID); return(Json(new { PostingDate = PO.PostingDate.Value.ToString("dd/MM/yyyy"), VendorID = PO.VendorID }, JsonRequestBehavior.AllowGet)); }
public tbl_TransferOut GetTIOrderByDocID(string docid) { tbl_TransferOut PO = Context.TransfterOUT.Get(e => e.DocumentID == docid).FirstOrDefault(); return(PO); }
public void AcceptTI(Dictionary <string, string> dictPO, string docid) { tbl_TransferOut PO = Context.TransfterOUT.Get(e => e.DocumentID == docid && e.TO_Status == "Open").FirstOrDefault(); List <tbl_TransferOut_Detail> lstPODetail = Context.TransfterOUTDetails.Get(e => e.DocumentID == docid).ToList(); bool isChanged = false; tbl_TransferIN stockRecieve = new tbl_TransferIN(); 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.TransfterIN.Insert(stockRecieve); Context.TransfterIN.Save(); foreach (tbl_TransferOut_Detail POD in lstPODetail) { decimal qty = Convert.ToDecimal(dictPO[POD.MaterialID]); if (POD.TranQty != qty) { isChanged = true; } tbl_TransferIN_Detail srd = new tbl_TransferIN_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.ToString(); Context.TransfterINDetails.Insert(srd); } Context.TransfterINDetails.Save(); if (isChanged) { PO.TO_Status = "Pending"; } else { PO.TO_Status = "Complete"; } Context.TransfterOUT.Update(PO); Context.TransfterOUT.Save(); }