public void UpdateInk(InkCViewModel ink)
{
var exitink = _db.InkStock.FirstOrDefault(s => s.InkName == ink.InkName);
if (exitink == null)
{
var storeProcedureName = "[dbo].[Add_Ink]";
var Result = _dbContext.Database.SqlQuery <PaperCViewModel>(
$"{storeProcedureName} @InkId,@InkName,@Ccount",
new SqlParameter("@InkId", ink.InkId),
new SqlParameter("@InkName", ink.InkName),
new SqlParameter("@Ccount", ink.Ccount)
).SingleOrDefault();
}
else
{
var storeProcedureName = "[dbo].[Update_Ink]";
var Result = _dbContext.Database.SqlQuery <PaperCViewModel>(
$"{storeProcedureName} @InkId,@InkName,@Ccount",
new SqlParameter("@InkId", ink.InkId),
new SqlParameter("@InkName", ink.InkName),
new SqlParameter("@Ccount", ink.Ccount)
).SingleOrDefault();
}
}
public List <InkCViewModel> GetInkByName(string name)
{
var inklist = from u in _db.InkStock
where (u.InkName.Contains(name))
select u;
var list = new List <InkCViewModel>();
foreach (var item in inklist)
{
var ink = new InkCViewModel();
ink.InkId = item.InkId;
ink.InkName = item.InkName;
ink.Ccount = item.Ccount;
list.Add(ink);
}
return(list);
}
public async Task <List <InkCViewModel> > GetAllInk()
{
var InkList = new List <InkCViewModel>();
var Inklist = new List <InkStock>();
Inklist = await _db.InkStock.ToListAsync();
foreach (var item in Inklist)
{
InkCViewModel Ink = new InkCViewModel();
Ink.InkId = item.InkId;
Ink.InkName = item.InkName;
Ink.Ccount = item.Ccount;
InkList.Add(Ink);
}
return(InkList);
}
public void UpdateInk(InkCViewModel ink)
{
_inkRespository.UpdateInk(ink);
}
