public ActionResult Create([Bind(Include = "id,Name,Designation,Salary")] Employee employee) { if (ModelState.IsValid) { db.Employee.Add(employee); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(employee)); }
public ActionResult Create([Bind(Include = "Id,Electricity,Water,Lunch,Month,TotalBills")] Bill bill) { // bill.TotalBills = bill.Water + bill.Lunch + bill.Electricity; if (ModelState.IsValid) { db.Bills.Add(bill); db.SaveChanges(); bill.TotalBills = bill.Water + bill.Lunch + bill.Electricity; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(bill)); }
public ActionResult Create([Bind(Include = "Id,RentSpace,Equipments,Month,TotalAdditional")] Additional additional) { // additional.TotalAdditional = additional.RentSpace + additional.Equipments; if (ModelState.IsValid) { db.Additionals.Add(additional); db.SaveChanges(); additional.TotalAdditional = additional.RentSpace + additional.Equipments; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(additional)); }
public ActionResult Create([Bind(Include = "Id,Name,Salary,Position,TotalSalary")] Clark clark) { // var sum = db.Clarks.Sum(i => i.Salary); // clark.TotalSalary = sum; if (ModelState.IsValid) { db.Clarks.Add(clark); db.SaveChanges(); var sum = db.Clarks.Sum(i => i.Salary); clark.TotalSalary = sum; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(clark)); }
public ActionResult SignUp(User model) { using (var context = new OfficeDbEntities()) { context.User.Add(model); context.SaveChanges(); } return(RedirectToAction("LogIn")); }
public ActionResult Create([Bind(Include = "Id,SponsoredAmount,SellingAmount,EmpId,ClarkId,BillId,AdditionalId,Profit")] Management management) { if (ModelState.IsValid) { db.Managements.Add(management); db.SaveChanges(); // var profit = Convert.ToInt32(management.Employee.TotalSalary - management.Clark.TotalSalary - management.Bill.TotalBills - management.Additional.TotalAdditional); // management.Profit = profit; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.AdditionalId = new SelectList(db.Additionals, "Id", "Month", management.Additional.TotalAdditional); ViewBag.BillId = new SelectList(db.Bills, "Id", "Month", management.Bill.TotalBills); ViewBag.ClarkId = new SelectList(db.Clarks, "Id", "TotalSalary", management.Clark.TotalSalary); ViewBag.EmpId = new SelectList(db.Employees, "Id", "TotalSalary", management.Employee.TotalSalary); return(View(management)); }
public ActionResult Create([Bind(Include = "Id,Name,Salary,Position,TotalSalary")] Employee employee) { // employee.TotalSalary = 0; // employee.TotalSalary += employee.Salary; // employee.TotalSalary += (employee.Salary); if (ModelState.IsValid) { db.Employees.Add(employee); db.SaveChanges(); var sum = db.Employees.Sum(i => i.Salary); employee.TotalSalary = sum; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(employee)); }