public void CreatePurchaseOrder4Paper(PurchasingPaperViewModel Paper)
{
var storeProcedureName = "[dbo].[Create_Paper_PurchaseOrder]";
var Result = _dbContext.Database.SqlQuery <PurchasingInkViewModel>(
$"{storeProcedureName} @PurchasingID,@PaperName,@Count,@Price,@CreatePersonId,@ProcessPersonId,@Status,@CreateDate,@ProcessDate",
new SqlParameter("@PurchasingID", Paper.PurchasingID),
new SqlParameter("@PaperName", Paper.PaperName),
new SqlParameter("@Count", Paper.Count),
new SqlParameter("@Price", Paper.Price),
new SqlParameter("@CreatePersonId", Paper.CreatePersonId),
new SqlParameter("@ProcessPersonId", Paper.ProcessPersonId),
new SqlParameter("@Status", Paper.Status),
new SqlParameter("@CreateDate", Paper.CreateDate),
new SqlParameter("@ProcessDate", Paper.ProcessDate)
).SingleOrDefault();
}
public List <PurchasingPaperViewModel> GetPurchasingById(string id)
{
var par = from u in _db.PaperPurchasing
where u.PurchasingID == id
select u;
var parc = new PurchasingPaperViewModel();
var parList = new List <PurchasingPaperViewModel>();
foreach (var i in par)
{
parc.PurchasingID = i.PurchasingID;
parc.PaperId = i.PaperId;
parc.PaperName = i.PaperName;
parc.Price = i.Price;
parc.ProcessDate = i.ProcessDate;
parc.ProcessPersonId = i.ProcessPersonId;
parc.Count = i.Count;
parc.CreateDate = i.CreateDate;
parc.CreatePersonId = i.CreatePersonId;
parc.Status = i.Status;
parList.Add(parc);
}
return(parList);
}
public async Task <List <PurchasingPaperViewModel> > GetAllPaperPurchasing()
{
var PaperList = new List <PurchasingPaperViewModel>();
var Paperlist = new List <PaperPurchasing>();
Paperlist = await _db.PaperPurchasing.ToListAsync();
foreach (var item in Paperlist)
{
PurchasingPaperViewModel par = new PurchasingPaperViewModel();
par.PurchasingID = item.PurchasingID;
par.PaperId = item.PaperId;
par.PaperName = item.PaperName;
par.Count = item.Count;
par.Price = item.Price;
par.CreatePersonId = item.CreatePersonId;
par.ProcessPersonId = item.ProcessPersonId;
par.Status = item.Status;
par.CreateDate = item.CreateDate;
par.ProcessDate = item.ProcessDate;
PaperList.Add(par);
}
return(PaperList);
}
public void CreatePurchaseOrder4Paper(PurchasingPaperViewModel Paper)
{
_paperRespository.CreatePurchaseOrder4Paper(Paper);
}
