public JsonResult GetTemplate(string start, string end, int id, int employeeId) { var calFrom = string.Format("YYYY-MM-DD HH:mm", start); var calTo = string.Format("YYYY-MM-DD HH:mm", end); IQueryable <PostIt> postIts = null; List <PostItHelpModel> postItsList = new List <PostItHelpModel>(); using (IPostItRepository _postItRepository = new PostItRepository(ApplicationDbContext.Create())) using (ICustomerRepository _customerRepository = new CustomerRepository(ApplicationDbContext.Create())) using (IEmployeeRepository _employeeRepository = new EmployeeRepository(ApplicationDbContext.Create())) { if (employeeId > -1) { postIts = _postItRepository.AllForEmployee(employeeId, id); } else { postIts = _postItRepository.AllForTemplate(id); } foreach (var postIt in postIts) { var customer = _customerRepository.Find(postIt.CustomerId); var employee = _employeeRepository.Find(postIt.EmployeeId); var from = Convert.ToDateTime(start); var fromAddDays = from.AddDays(postIt.DayOfWeek); var to = Convert.ToDateTime(start); var toAddDays = to.AddDays(postIt.DayOfWeek); var fromToDate = DateTime.Parse(postIt.From); var toToDate = DateTime.Parse(postIt.To); var finalStart = fromAddDays.Add(TimeSpan.Parse(fromToDate.ToString("HH:mm"))); var finalEnd = toAddDays.Add(TimeSpan.Parse(toToDate.ToString("HH:mm"))); PostItHelpModel newPostIt = new PostItHelpModel() { id = postIt.EventId, title = postIt.Title, start = finalStart.ToString("s"), end = finalEnd.ToString("s"), note = postIt.Note, customerId = postIt.CustomerId, employeeId = postIt.EmployeeId, customerName = customer.Company, employeeName = employee.Name, templateNo = id, templateId = null, allDay = false, dayOfWeek = postIt.DayOfWeek, isAssigned = postIt.IsAssigned }; postItsList.Add(newPostIt); } } var rows = postItsList.ToArray(); return(Json(rows, JsonRequestBehavior.AllowGet)); }
public JsonResult GetPostIts(string start, string end, int id, int employeeId) { var from = string.Format("YYYY-MM-DD HH:mm", start); var to = string.Format("YYYY-MM-DD HH:mm", end); IQueryable <PostIt> postIts = null; List <PostItHelpModel> postItHelpModels = new List <PostItHelpModel>(); using (IPostItRepository _postItRepository = new PostItRepository(ApplicationDbContext.Create())) using (ICustomerRepository _customerRepository = new CustomerRepository(ApplicationDbContext.Create())) using (IEmployeeRepository _employeeRepository = new EmployeeRepository(ApplicationDbContext.Create())) { if (employeeId > -1) { postIts = _postItRepository.AllForEmployee(from, to, employeeId, id); } else { postIts = _postItRepository.AllForTemplate(from, to, id); } foreach (var postIt in postIts) { var customer = _customerRepository.Find(postIt.CustomerId); var employee = _employeeRepository.Find(postIt.EmployeeId); var employeeName = ""; if (employee != null) { employeeName = employee.Name; } var postItHelpModel = new PostItHelpModel() { id = postIt.EventId, title = postIt.Title, start = postIt.From, end = postIt.To, note = postIt.Note, customerId = postIt.CustomerId, employeeId = postIt.EmployeeId, customerName = customer.Company, employeeName = employeeName, allDay = false, isAssigned = postIt.IsAssigned, templateNo = postIt.TemplateNo, templateId = postIt.TemplateId }; postItHelpModels.Add(postItHelpModel); } } var rows = postItHelpModels.ToArray(); return(Json(rows, JsonRequestBehavior.AllowGet)); }
public ActionResult Delete(int id) { using (IEmployeeRepository _employeeRepo = new EmployeeRepository(ApplicationDbContext.Create())) using (IPostItRepository _postItRepo = new PostItRepository(ApplicationDbContext.Create())) { var postItsForEmployee = _postItRepo.AllForEmployee(id).ToList(); foreach (var postIt in postItsForEmployee) { postIt.IsAssigned = false; _postItRepo.Update(postIt); _postItRepo.Save(); } _employeeRepo.Delete(id); _employeeRepo.Save(); return(RedirectToAction("Index")); } }