public void CreatePurchaseOrder4Ink(PurchasingInkViewModel ink)
{
var storeProcedureName = "[dbo].[Create_Ink_PurchaseOrder]";
var Result = _dbContext.Database.SqlQuery <PurchasingInkViewModel>(
$"{storeProcedureName} @PurchasingID,@InkName,@Count,@Price,@CreatePersonId,@ProcessPersonId,@Status,@CreateDate,@ProcessDate",
new SqlParameter("@PurchasingID", ink.PurchasingID),
new SqlParameter("@InkName", ink.InkName),
new SqlParameter("@Count", ink.Count),
new SqlParameter("@Price", ink.Price),
new SqlParameter("@CreatePersonId", ink.CreatePersonId),
new SqlParameter("@ProcessPersonId", ink.ProcessPersonId),
new SqlParameter("@Status", ink.Status),
new SqlParameter("@CreateDate", ink.CreateDate),
new SqlParameter("@ProcessDate", ink.ProcessDate)
).SingleOrDefault();
}
public List <PurchasingInkViewModel> GetPurchasingByName(string name)
{
var inklist = from u in _db.InkPurchasing
where (u.InkName.Contains(name))
select u;
var list = new List <PurchasingInkViewModel>();
foreach (var i in inklist)
{
var purc = new PurchasingInkViewModel();
purc.PurchasingID = i.PurchasingID;
purc.InkId = i.InkId;
purc.InkName = i.InkName;
purc.Price = i.Price;
purc.ProcessDate = i.ProcessDate;
purc.ProcessPersonId = i.ProcessPersonId;
purc.Count = i.Count;
purc.CreateDate = i.CreateDate;
purc.CreatePersonId = i.CreatePersonId;
purc.Status = i.Status;
list.Add(purc);
}
return(list);
}
public async Task <List <PurchasingInkViewModel> > GetAllInkPurchasing()
{
var InkList = new List <PurchasingInkViewModel>();
var Inklist = new List <InkPurchasing>();
Inklist = await _db.InkPurchasing.ToListAsync();
foreach (var item in Inklist)
{
PurchasingInkViewModel ink = new PurchasingInkViewModel();
ink.PurchasingID = item.PurchasingID;
ink.InkId = item.InkId;
ink.InkName = item.InkName;
ink.Count = item.Count;
ink.Price = item.Price;
ink.CreatePersonId = item.CreatePersonId;
ink.ProcessPersonId = item.ProcessPersonId;
ink.Status = item.Status;
ink.CreateDate = item.CreateDate;
ink.ProcessDate = item.ProcessDate;
InkList.Add(ink);
}
return(InkList);
}
public List <PurchasingInkViewModel> GetPurchasingById(string id)
{
var pur = from u in _db.InkPurchasing
where u.PurchasingID == id
select u;
var purc = new PurchasingInkViewModel();
var purList = new List <PurchasingInkViewModel>();
foreach (var i in pur)
{
purc.PurchasingID = i.PurchasingID;
purc.InkId = i.InkId;
purc.InkName = i.InkName;
purc.Price = i.Price;
purc.ProcessDate = i.ProcessDate;
purc.ProcessPersonId = i.ProcessPersonId;
purc.Count = i.Count;
purc.CreateDate = i.CreateDate;
purc.CreatePersonId = i.CreatePersonId;
purc.Status = i.Status;
purList.Add(purc);
}
return(purList);
}
public void CreatePurchaseOrder4Ink(PurchasingInkViewModel ink)
{
_inkRespository.CreatePurchaseOrder4Ink(ink);
}
