//teacher's salary details public IActionResult SalaryDetails() { Int64 Count = 1; var v1 = _context.TeacherSalary.ToList(); var v2 = _context.Teacher.ToList(); var v3 = _context.TeacherDesignation.ToList(); var q = from vts in v1 join vt in v2 on vts.DesigId equals vt.DesigId join vtd in v3 on vts.DesigId equals vtd.DesigId orderby vt.TeacherName ascending select new { pk = vts.SerialNo, tcrnm = vt.TeacherName, dsgnm = vtd.DesigName, tcrsal = vts.Salary }; var tsvmlist = new List <TeacherSalaryViewModel>(); foreach (var item in q) { TeacherSalaryViewModel tsvm = new TeacherSalaryViewModel(); tsvm.serialnoVM = Count; Count++; tsvm.salaryVM = item.tcrsal; tsvm.designameVM = item.dsgnm; tsvm.tcrnameVM = item.tcrnm; tsvm.PrimaryKey = item.pk; tsvmlist.Add(tsvm); } return(View(tsvmlist)); }
//salary list public IActionResult SalaryList(int?page) { Int64 Count = 1; var pagenumber = page ?? 1; var v1 = _context.TeacherSalary.ToList(); var v2 = _context.TeacherDesignation.ToList(); var q = from vts in v1 join vtd in v2 on vts.DesigId equals vtd.DesigId select new { pk = vts.SerialNo, dsgnm = vtd.DesigName, tcrsal = vts.Salary }; var tsvmlist = new List <TeacherSalaryViewModel>(); foreach (var item in q) { TeacherSalaryViewModel tsvm = new TeacherSalaryViewModel(); tsvm.serialnoVM = Count; Count++; tsvm.PrimaryKey = item.pk; tsvm.designameVM = item.dsgnm; tsvm.salaryVM = item.tcrsal; tsvmlist.Add(tsvm); } var pg = tsvmlist.ToPagedList(pagenumber, 2); return(View(pg)); }
public IActionResult SetSalary(TeacherSalaryViewModel tsvm) { var vss = _context.TeacherDesignation.ToList(); vss.Insert(0, new TeacherDesignation { DesigId = 0, DesigName = "Select a designation" }); ViewBag.ss = vss; if (tsvm.desigidVM == 0) { ViewBag.msg1 = "Please choose a designation"; return(View()); } var v = _context.TeacherSalary.Where(q => q.DesigId == tsvm.desigidVM).FirstOrDefault(); if (v != null) { ViewBag.msg2 = "Salary is already set for this designation"; return(View()); } TeacherSalary ts = new TeacherSalary(); ts.SerialNo = 0; ts.Salary = tsvm.salaryVM; ts.DesigId = tsvm.desigidVM; _context.TeacherSalary.Add(ts); _context.SaveChanges(); ModelState.Clear(); return(View()); }
//update teacher salary public IActionResult UpdateTeacherSalary(Int64 uts) { //var v = _context.TeacherDesignation.ToList(); //v.Insert(0, new TeacherDesignation { DesigId = 0, DesigName = "Select a Designation" }); //ViewBag.td = v; var v1 = _context.TeacherSalary.Where(q => q.SerialNo == uts).FirstOrDefault(); TeacherSalaryViewModel tsvm = new TeacherSalaryViewModel(); tsvm.PrimaryKey = v1.SerialNo; tsvm.desigidVM = v1.DesigId; tsvm.salaryVM = v1.Salary; return(View(tsvm)); }
public IActionResult UpdateTeacherSalary(TeacherSalaryViewModel updt) { //var v = _context.TeacherDesignation.ToList(); //v.Insert(0, new TeacherDesignation { DesigId = 0, DesigName = "Select a Designation" }); //ViewBag.td = v; //if(updt.desigidVM==0) //{ // ViewBag.msg = "Please Select a Designation"; // return View(); //} TeacherSalary ts = new TeacherSalary(); ts.SerialNo = updt.PrimaryKey; ts.DesigId = updt.desigidVM; ts.Salary = updt.salaryVM; _context.TeacherSalary.Update(ts); _context.SaveChanges(); return(RedirectToAction("SalaryList")); }