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