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()); }
public async Task <IActionResult> Edit(int id, [Bind("TsId,TeacherId,MonthName,Amount,Date")] TeacherSalary teacherSalary) { if (id != teacherSalary.TsId) { return(NotFound()); } if (ModelState.IsValid) { try { _context.Update(teacherSalary); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!TeacherSalaryExists(teacherSalary.TsId)) { return(NotFound()); } else { throw; } } return(RedirectToAction(nameof(Index))); } ViewData["TeacherId"] = new SelectList(_context.TeacherInfo, "TeacherId", "Email", teacherSalary.TeacherId); return(View(teacherSalary)); }
public async Task <IActionResult> Create([Bind("TsId,TeacherId,MonthName,Amount,Date")] TeacherSalary teacherSalary) { if (ModelState.IsValid) { _context.Add(teacherSalary); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } ViewData["TeacherId"] = new SelectList(_context.TeacherInfo, "TeacherId", "Email", teacherSalary.TeacherId); return(View(teacherSalary)); }
public ActionResult Salary_edit_teacher(int id, TeacherSalary teacherSalary) { try { using (DBmodel payrollentities = new DBmodel()) { payrollentities.Entry(teacherSalary).State = EntityState.Modified; payrollentities.SaveChanges(); } return(RedirectToAction("Salary_details_teacher")); } catch { return(View()); } }
public ActionResult Add_teacher_salary(int id, TeacherSalary teacherSalary) { try { using (DBmodel payrollentities = new DBmodel()) { payrollentities.TeacherSalaries.Add(teacherSalary); payrollentities.SaveChanges(); } return(RedirectToAction("Salary_details_teacher")); } catch { return(View()); } }
public ActionResult Salary_delete_teacher(int id, FormCollection collection) { try { // TODO: Add delete logic here using (DBmodel payrollentities = new DBmodel()) { TeacherSalary teacherSalary = payrollentities.TeacherSalaries.Where(x => x.SalaryId == id).FirstOrDefault(); payrollentities.TeacherSalaries.Remove(teacherSalary); payrollentities.SaveChanges(); } return(RedirectToAction("Salary_details_teacher")); } catch { return(View()); } }
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")); }