public IActionResult Query_Details(string Id) { Querie querie = _context.queries.FirstOrDefault(qry => qry.Id == Id); QueryViewModel queryViewModel = new QueryViewModel(); if (querie != null) { queryViewModel.Id = querie.Id; queryViewModel.Title = querie.title; queryViewModel.UploadTime = querie.Query_Time; queryViewModel.Description = System.IO.File.ReadAllText(querie.textfilepath); IEnumerable <PhotoModel> photoModels = _context.photoModels.Where(ph => ph.querieId == Id); if (photoModels == null) { ViewBag.Error = "error"; } else { List <string> urls = new List <string>(); List <string> names = new List <string>(); foreach (var photo in photoModels) { urls.Add(photo.URL); names.Add(photo.Name); } queryViewModel.URLS = urls; queryViewModel.Names = names; } Employee employee = _context.employees.FirstOrDefault(emp => emp.Id == HttpContext.Session.GetString("uid")); if (employee.post == "main") { if (querie.status == "Inp" || querie.status == "Comp") { ViewBag.show = "none"; } else { ViewBag.show = "all"; } } else { if (querie.status == "Comp") { ViewBag.show = "none"; } else if (querie.status == "Inp") { ViewBag.show = "Complete"; } else if (querie.status == "Acc") { ViewBag.show = "proceed Request"; } } return(View(queryViewModel)); } ViewBag.Error = "error"; return(View()); }
public IActionResult Query_Details(string Id) { Querie querie = _context.queries.FirstOrDefault(qry => qry.Id == Id); QueryViewModel queryViewModel = new QueryViewModel(); if (querie != null) { queryViewModel.Title = querie.title; queryViewModel.UploadTime = querie.Query_Time; queryViewModel.Description = System.IO.File.ReadAllText(querie.textfilepath); IEnumerable <PhotoModel> photoModels = _context.photoModels.Where(ph => ph.querieId == Id); if (photoModels == null) { ViewBag.Error = "error"; } else { List <string> urls = new List <string>(); List <string> names = new List <string>(); foreach (var photo in photoModels) { urls.Add(photo.URL); names.Add(photo.Name); } queryViewModel.URLS = urls; queryViewModel.Names = names; } return(View(queryViewModel)); } ViewBag.Error = "error"; return(View()); }
public IActionResult Completed(string Id) { Querie querie = _context.queries.FirstOrDefault(qry => qry.Id == Id); querie.status = "Comp"; _context.SaveChanges(); return(RedirectToAction("HomePage", "Employees")); }
public IActionResult Reject(string Id) { Querie querie = _context.queries.FirstOrDefault(qry => qry.Id == Id); querie.status = "Rej"; querie.EmployeeId = HttpContext.Session.GetString("uid"); _context.SaveChanges(); return(RedirectToAction("HomePage", "Employees")); }
public IActionResult Proceed(string Id) { Querie querie = _context.queries.FirstOrDefault(qry => qry.Id == Id); Employee employee = _context.employees.FirstOrDefault(emp => emp.Id == HttpContext.Session.GetString("uid")); if (employee.post == "main") { querie.status = "Acc"; querie.EmployeeId = HttpContext.Session.GetString("uid"); } else { querie.status = "Inp"; querie.Main_Emp_Id = HttpContext.Session.GetString("uid"); } _context.SaveChanges(); return(RedirectToAction("HomePage", "Employees")); }
public async Task <IActionResult> Query_Problem(QueriesView queriesView) { if (ModelState.IsValid) { if (queriesView.photos != null) { string folder = "Proofs/"; queriesView.uploadphoto = new List <UploadPhotoModel>(); foreach (var file in queriesView.photos) { var gallery = new UploadPhotoModel { Name = file.FileName, URL = await UploadImage(folder, file) }; queriesView.uploadphoto.Add(gallery); } } string filepath = ""; if (queriesView.textfile != null) { string folderPath = "Description/"; folderPath += Guid.NewGuid().ToString() + "_" + RandomFileName(6); filepath = Path.Combine(_env.WebRootPath, folderPath); filepath += ".txt"; System.IO.File.WriteAllText(filepath, queriesView.textfile); } Querie querie = new Querie(); querie.Id = RandomString(15); querie.CitizenId = HttpContext.Session.GetString("uid"); querie.status = "Req"; querie.Area = queriesView.Area; querie.zipcode = queriesView.zipcode; querie.textfilepath = filepath; querie.title = queriesView.title; querie.Query_Time = DateTime.Now; querie.Citizen = _context.Citizens.FirstOrDefault(czn => czn.Id == HttpContext.Session.GetString("uid")); querie.ProofPhotos = new List <PhotoModel>(); foreach (var file in queriesView.uploadphoto) { querie.ProofPhotos.Add(new PhotoModel() { Name = file.Name, URL = file.URL }); } await _context.queries.AddAsync(querie); await _context.SaveChangesAsync(); return(RedirectToAction("HomePage", "Citizen")); } else { return(View()); } }