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); }