public ActionResult NewFromTemplate(int id) { var sqlDirect = new PrepareTemplate(); var taskId = sqlDirect.InsertTemplate(id); var task = _context.Tasks.SingleOrDefault(t => t.TaskId == taskId); if (task == null) { return(HttpNotFound()); } var viewModel = new TasksFormViewModel(task) { TaskTypes = _context.TaskTypes.ToList(), TaskCategories = _context.TaskCategories.ToList(), Prices = _context.Prices.ToList(), Companies = _context.Companies.ToList(), TaskStatuses = _context.TaskStatuses.ToList(), Members = _context.Members.ToList() }; return(View("TaskFormNewFromTemplate", viewModel)); }
public ActionResult Save(CompanyFormViewModel companyViewModel) { Companies company = new Companies(); CompanyTasks compTasks = new CompanyTasks(); if (!ModelState.IsValid) { return(View("CompanyForm")); } if (companyViewModel.CompanyId == 0) { //add company company.CompanyName = companyViewModel.CompanyName; company.Email = companyViewModel.Email; company.Phone = companyViewModel.Phone; _context.Companies.Add(company); _context.SaveChanges(); //save to get the new company id //add company tasks PrepareTemplate autoInsertTask = new PrepareTemplate(); var total = System.Web.HttpContext.Current.Request.Params["totalTasks"]; for (var i = 1; i <= Convert.ToInt32(total); i++) { compTasks.CompanyId = company.CompanyId; compTasks.TaskId = Convert.ToInt32(System.Web.HttpContext.Current.Request.Params["TaskId" + i.ToString()]); //auto insert tasks autoInsertTask.InsertTemplateForCompany(compTasks.TaskId, compTasks.CompanyId); } _context.CompanyTasks.Add(compTasks); } else { var companyInDb = _context.Companies.Single(c => c.CompanyId == company.CompanyId); companyInDb.CompanyName = company.CompanyName; companyInDb.Email = company.Email; companyInDb.Phone = company.Phone; } _context.SaveChanges(); return(RedirectToAction("Index", "Companies")); }