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());
}
}
