public void UpdatePaper(PaperCViewModel paper)
{
var exitPaper = _db.Paper.FirstOrDefault(s => s.PaperName == paper.PaperName);
if (exitPaper == null)
{
var storeProcedureName = "[dbo].[Add_Paper]";
var Result = _dbContext.Database.SqlQuery <PaperCViewModel>(
$"{storeProcedureName} @PaperId,@PaperName,@Ccount",
new SqlParameter("@PaperId", paper.PaperId),
new SqlParameter("@PaperName", paper.PaperName),
new SqlParameter("@Ccount", paper.Ccount)
).SingleOrDefault();
}
else
{
var storeProcedureName = "[dbo].[Update_Paper]";
var Result = _dbContext.Database.SqlQuery <PaperCViewModel>(
$"{storeProcedureName} @PaperId,@PaperName,@Ccount",
new SqlParameter("@PaperId", paper.PaperId),
new SqlParameter("@PaperName", paper.PaperName),
new SqlParameter("@Ccount", paper.Ccount)
).SingleOrDefault();
}
}
public List <PaperCViewModel> GetPaperByPapername(string name)
{
var paperlist = from u in _db.Paper
where (u.PaperName.Contains(name))
select u;
var list = new List <PaperCViewModel>();
foreach (var item in paperlist)
{
var paper = new PaperCViewModel();
paper.PaperId = item.PaperId;
paper.PaperName = item.PaperName;
paper.Ccount = item.Ccount;
list.Add(paper);
}
return(list);
}
public async Task <List <PaperCViewModel> > GetAllPaper()
{
var paperList = new List <PaperCViewModel>();
var paperlist = new List <Paper>();
paperlist = await _db.Paper.ToListAsync();
foreach (var item in paperlist)
{
PaperCViewModel paper = new PaperCViewModel();
paper.PaperId = item.PaperId;
paper.PaperName = item.PaperName;
paper.Ccount = item.Ccount;
paperList.Add(paper);
}
return(paperList);
}
public void UpdatePaper(PaperCViewModel paper)
{
_paperRespository.UpdatePaper(paper);
}
