public List <Prq_Purchase> GetPurchaseListID(int supplier, string dateFrom, string dateTo)
{
DateTime fromdate = DalCommon.SetDate(dateFrom);
DateTime toDate = DalCommon.SetDate(dateTo);
List <Prq_PreGradeSelection> result = (from temp in _context.Prq_PreGradeSelection
where temp.SupplierID == supplier && temp.RecordStatus == "CNF" && temp.SelectionDate >= fromdate && temp.SelectionDate <= toDate
select temp).ToList();
var lstPurchase = (from temp in result
join temp2 in _context.Prq_Purchase on temp.PurchaseID equals temp2.PurchaseID
select new {
PurchaseID = temp2.PurchaseID,
PurchaseNo = temp2.PurchaseNo,
PurchaseDate = temp2.PurchaseDate
}).AsEnumerable();
List <Prq_Purchase> lstPo = new List <Prq_Purchase>();
foreach (var item in lstPurchase)
{
Prq_Purchase ob = new Prq_Purchase();
ob.PurchaseID = item.PurchaseID;
ob.PurchaseNo = item.PurchaseNo;
ob.PurchaseDate = item.PurchaseDate;
lstPo.Add(ob);
}
return(lstPo);
}
public ValidationMsg setSNR(string purchaseId)
{
try
{
using (var tx = new TransactionScope())
{
using (_context)
{
string[] purchaseIds = purchaseId.Split(',');
for (int i = 0; i < purchaseIds.Length; i++)
{
int purcid = Convert.ToInt32(purchaseIds[i]);
Prq_Purchase data = (from temp in _context.Prq_Purchase where temp.PurchaseID == purcid && temp.RecordStatus == "CNF" select temp).FirstOrDefault();
data.RecordStatus = "SNR";
_context.SaveChanges();
}
}
tx.Complete();
}
_vmMsg.Type = Enums.MessageType.Success;
_vmMsg.Msg = "SNR set successfully for PurchaseId (" + purchaseId + ").";
}
catch (Exception)
{
_vmMsg.Type = Enums.MessageType.Error;
_vmMsg.Msg = "Failed to Confirmation.";
}
return(_vmMsg);
}
public long SavePurchaseInformation(PurchaseReceive model, int userId)
{
long CurrentPurchaseID = 0;
try
{
using (TransactionScope transaction = new TransactionScope())
{
#region New_Purchase_Insert
using (_context)
{
Prq_Purchase objPurchase = new Prq_Purchase();
//Random r = new Random();
//objPurchase.PurchaseNo = r.Next().ToString();
objPurchase.PurchaseNo = DalCommon.GetPreDefineNextCodeByUrl("Purchase/Purchase");
objPurchase.SupplierID = Convert.ToInt16(model.SupplierID);
objPurchase.SupplierAddressID = Convert.ToInt16(model.SupplierAddressID);
objPurchase.PurchaseCategory = model.PurchaseCategory;
objPurchase.PurchaseType = model.PurchaseType;
objPurchase.PurchaseYear = model.PurchaseYear;
objPurchase.PurchaseDate = DalCommon.SetDate(model.PurchaseDate);
objPurchase.PurchaseNote = model.PurchaseNote;
objPurchase.RecordStatus = "NCF";
objPurchase.SetOn = DateTime.Now;
objPurchase.SetBy = userId;
_context.Prq_Purchase.Add(objPurchase);
_context.SaveChanges();
CurrentPurchaseID = objPurchase.PurchaseID;
if (model.ChallanList != null)
{
Prq_PurchaseChallan objChallan = new Prq_PurchaseChallan();
objChallan.ChallanNo = model.ChallanList.FirstOrDefault().ChallanNo;
objChallan.PurchaseID = CurrentPurchaseID;
objChallan.SourceID = model.ChallanList.FirstOrDefault().SourceID;
objChallan.LocationID = model.ChallanList.FirstOrDefault().LocationID;
objChallan.ReceiveStore = DalCommon.GetStoreCode(model.ChallanList.FirstOrDefault().ReceiveStore);
objChallan.ChallanCategory = model.ChallanList.FirstOrDefault().ChallanCategory;
objChallan.ChallanNote = model.ChallanList.FirstOrDefault().ChallanNote;
objChallan.ChallanDate = Convert.ToDateTime(model.ChallanList.FirstOrDefault().ChallanDate);
objChallan.RecordStatus = "NCF";
objChallan.SetOn = DateTime.Now;
objChallan.SetBy = userId;
_context.Prq_PurchaseChallan.Add(objChallan);
_context.SaveChanges();
var CurrentChallanNo = objChallan.ChallanID;
if (model.ChallanItemList != null)
{
foreach (var ChallanItem in model.ChallanItemList)
{
Prq_PurchaseChallanItem objPurchaseChallanItem = new Prq_PurchaseChallanItem();
objPurchaseChallanItem.ChallanID = CurrentChallanNo;
objPurchaseChallanItem.ItemCategory = "Leather";
objPurchaseChallanItem.ItemTypeID = DalCommon.GetItemTypeCode(ChallanItem.ItemTypeID);
objPurchaseChallanItem.ItemSizeID = DalCommon.GetSizeCode(ChallanItem.ItemSizeID);
objPurchaseChallanItem.Description = ChallanItem.Description;
objPurchaseChallanItem.UnitID = DalCommon.GetUnitCode(ChallanItem.UnitID);
objPurchaseChallanItem.ChallanQty = ChallanItem.ChallanQty;
objPurchaseChallanItem.ReceiveQty = ChallanItem.ReceiveQty;
objPurchaseChallanItem.Remark = ChallanItem.Remark;
objPurchaseChallanItem.RecordStatus = "NCF";
objPurchaseChallanItem.SetBy = userId;
objPurchaseChallanItem.SetOn = DateTime.Now;
_context.Prq_PurchaseChallanItem.Add(objPurchaseChallanItem);
_context.SaveChanges();
}
}
}
}
#endregion
transaction.Complete();
}
return(CurrentPurchaseID);
}
catch (Exception e)
{
return(CurrentPurchaseID);
}
}
