public JsonResult CreatePostIt(PostItHelpModel postItHelpModel) { if (ModelState.IsValid) { TimeZone localTime = TimeZone.CurrentTimeZone; Console.WriteLine(localTime.StandardName); using (PostItRepository _postItRepo = new PostItRepository(ApplicationDbContext.Create())) using (CustomerRepository _customerRepository = new CustomerRepository(ApplicationDbContext.Create())) using (EmployeeRepository _employeeRepository = new EmployeeRepository(ApplicationDbContext.Create())) { PostIt postIt = new PostIt() { Title = postItHelpModel.title, From = postItHelpModel.start, To = postItHelpModel.end, Note = postItHelpModel.note, DayOfWeek = postItHelpModel.dayOfWeek, TemplateNo = postItHelpModel.templateNo, CreatedDate = DateTime.Now, CustomerId = postItHelpModel.customerId, EmployeeId = postItHelpModel.employeeId, IsAssigned = true }; _postItRepo.Insert(postIt); _postItRepo.Save(); return(Json(true)); } } return(Json(false)); }
public JsonResult UpdatePostIt(PostItHelpModel postItHelpModel) { if (ModelState.IsValid) { using (PostItRepository _postItRepo = new PostItRepository(ApplicationDbContext.Create())) using (CustomerRepository _customerRepository = new CustomerRepository(ApplicationDbContext.Create())) using (EmployeeRepository _employeeRepository = new EmployeeRepository(ApplicationDbContext.Create())) { PostIt postIt = _postItRepo.Find(postItHelpModel.id); postIt.Title = postItHelpModel.title; postIt.From = postItHelpModel.start; postIt.To = postItHelpModel.end; postIt.CustomerId = postItHelpModel.customerId; postIt.EmployeeId = postItHelpModel.employeeId; postIt.DayOfWeek = postItHelpModel.dayOfWeek; postIt.Note = postItHelpModel.note; postIt.TemplateNo = postItHelpModel.templateNo; postIt.IsAssigned = true; _postItRepo.Update(postIt); _postItRepo.Save(); return(Json(true)); } } return(Json(false)); }
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 DelPostIt(int id) { using (IPostItRepository _postItRepo = new PostItRepository(ApplicationDbContext.Create())) { _postItRepo.Delete(id); _postItRepo.Save(); return(Json(true, 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 Index() { HomeViewModel viewModel = null; using (ICustomerRepository _customerRepo = new CustomerRepository(ApplicationDbContext.Create())) using (IEmployeeRepository _employeeRepo = new EmployeeRepository(ApplicationDbContext.Create())) using (IPostItRepository _postItRepo = new PostItRepository(ApplicationDbContext.Create())) { List <Template> templates = new List <Template>(); for (int i = 1; i < 3; i++) { Template template = new Template() { TemplateId = i, TemplateName = "Template - Uge " + i }; templates.Add(template); } var employees = _employeeRepo.All(); List <EmployeeHelpModel> employeeHelpModels = new List <EmployeeHelpModel>(); EmployeeHelpModel all = new EmployeeHelpModel() { Id = -1, Name = "Alle" }; employeeHelpModels.Add(all); foreach (var employee in employees) { EmployeeHelpModel helpModel = new EmployeeHelpModel() { Id = employee.EmployeeId, Name = employee.Name }; employeeHelpModels.Add(helpModel); } viewModel = new HomeViewModel() { Customers = _customerRepo.All().ToList(), Employees = employees.ToList(), EmployeesList2 = employeeHelpModels, Templates = templates }; } return(View(viewModel)); }
public JsonResult CreateTemplate(TemplateData templateData) { IQueryable <PostIt> postIts = null; List <PostIt> postItsList = new List <PostIt>(); using (IPostItRepository _postItRepository = new PostItRepository(ApplicationDbContext.Create())) using (ICustomerRepository _customerRepository = new CustomerRepository(ApplicationDbContext.Create())) using (IEmployeeRepository _employeeRepository = new EmployeeRepository(ApplicationDbContext.Create())) { postIts = _postItRepository.AllForTemplate(templateData.templateId); foreach (var postIt in postIts) { var from = Convert.ToDateTime(templateData.start); var fromAddDays = from.AddDays(postIt.DayOfWeek); var to = Convert.ToDateTime(templateData.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"))); PostIt newPostIt = new PostIt() { Title = postIt.Title, From = finalStart.ToString("s"), To = finalEnd.ToString("s"), Note = postIt.Note, CustomerId = postIt.CustomerId, EmployeeId = postIt.EmployeeId, TemplateNo = 0, TemplateId = postIt.EventId, CreatedDate = DateTime.Now, DayOfWeek = postIt.DayOfWeek, IsAssigned = true }; postItsList.Add(newPostIt); } foreach (var postIt in postItsList) { _postItRepository.Insert(postIt); _postItRepository.Save(); } } return(Json(true)); }
public ActionResult Delete(int id) { using (ICustomerRepository _customerRepo = new CustomerRepository(ApplicationDbContext.Create())) using (IPostItRepository _postItRepo = new PostItRepository(ApplicationDbContext.Create())) { var postItsForCus = _postItRepo.AllForCustomer(id).ToList(); foreach (var postIt in postItsForCus) { postIt.IsAssigned = false; _postItRepo.Update(postIt); _postItRepo.Save(); } _customerRepo.Delete(id); _customerRepo.Save(); return(RedirectToAction("Index")); } }