public ActionResult Details(int?id)
{
Complain complain = db.Complains.Find(id);
ComplainViewModel model = Mapper.Map <Complain, ComplainViewModel>(complain);
return(View(model));
}
// GET: Complains/Detailss/5
public async Task <IActionResult> Detailss(int?id)
{
if (id == null)
{
return(NotFound());
}
var complain = await _context.Complains.Include(c => c.Area).FirstOrDefaultAsync(m => m.ID == id);
var userComplain = await _context.UserComplains.Include(c => c.User).FirstOrDefaultAsync(m => m.ComplainId == id);
var workerComplain = await _context.WorkerComplains.Include(c => c.User).FirstOrDefaultAsync(m => m.ComplainId == id);
ComplainViewModel complainViewModel = new ComplainViewModel
{
Complain = complain,
UserComplain = userComplain,
WorkerComplain = workerComplain
};
if (complainViewModel == null)
{
return(NotFound());
}
if (HttpContext.Session.GetString("UserAdmin") != null)
{
return(View(complainViewModel));
}
else
{
return(RedirectToAction("Admin", "Account"));
}
}
public async Task <IActionResult> Create([Bind("ID,AreaId,ComplainDate,ComplainDescription")] ComplainViewModel complain)
{
//ModelState["Status"].Errors.Clear();
if (ModelState.IsValid)
{
Complain _complain = new Complain();
_complain.AreaId = complain.AreaId;
_complain.ComplainDate = complain.ComplainDate;
_complain.ComplainDescription = complain.ComplainDescription;
_complain.Status = "Pending";
_context.Add(_complain);
await _context.SaveChangesAsync();
var user = HttpContext.Session.GetString("User").ToString();
UserComplain _userComplain = new UserComplain();
User aUser = _context.Users.Where(u => u.UserName == user).SingleOrDefault();
_userComplain.ComplainId = _complain.ID;
_userComplain.UserId = aUser.ID;
_context.UserComplains.Add(_userComplain);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
ViewData["AreaId"] = new SelectList(_context.Areas, "ID", "Name", complain.AreaId);
return(View(complain));
}
// GET: Complain
public async Task <ActionResult> Index()
{
var _db = new ApplicationDbContext();
ComplainViewModel complains = new ComplainViewModel();
var user = await UserManager.FindByIdAsync(User.Identity.GetUserId());
List <Complain> complains2 = null;
if (User.IsInRole(UserRoles.Admin))
{
complains2 = _db.Complains.Where(x => x.Status == false).ToList();
}
else if (User.IsInRole(UserRoles.User) && !User.IsInRole(UserRoles.Admin))
{
complains2 = _db.Complains.Where(u => u.UserId == user.Id).ToList();
}
foreach (var complain in complains2)
{
complains.ComplainItemsViewModels.Add(new ComplainItemsViewModel()
{
CreatedDate = complain.CreatedDate,
ComplainStatus = complain.Status,
ComplainId = complain.Id,
UserName = _db.Employees.FindAsync(UserManager.FindByIdAsync(complain.UserId).Result.Code).Result.Name
});
}
complains.ComplainCounter = complains2.Count();
return(View(complains));
}
// GET: Complains/Edit/5
public async Task <IActionResult> Edit(int?id)
{
if (id == null)
{
return(NotFound());
}
var complain = await _context.Complains.FindAsync(id);
if (complain == null)
{
return(NotFound());
}
if (HttpContext.Session.GetString("User") != null)
{
ComplainViewModel _complain = new ComplainViewModel();
_complain.ID = complain.ID;
_complain.AreaId = complain.AreaId;
_complain.ComplainDate = complain.ComplainDate;
_complain.ComplainDescription = complain.ComplainDescription;
_complain.Status = complain.Status;
ViewData["AreaId"] = new SelectList(_context.Areas, "ID", "Name", complain.AreaId);
return(View(_complain));
}
else
{
return(RedirectToAction("User", "Account"));
}
}
public void Save(ComplainViewModel complain)
{
Complains compalinsmodel = GetEntity(complain);
using (var _context = new NasscomEntities())
{
var tt = _context.Complains.ToList();
Complains complaincheck = _context.Complains.Find(compalinsmodel.ContactNumber);
if (complaincheck != null)
{
complaincheck.Name = compalinsmodel.Name;
complaincheck.Email = compalinsmodel.Email;
complaincheck.ContactNumber = compalinsmodel.ContactNumber;
complaincheck.Location = compalinsmodel.Location;
complaincheck.Compactor = compalinsmodel.Compactor;
complaincheck.Description = compalinsmodel.Description;
}
else
{
_context.Complains.Add(compalinsmodel);
}
_context.SaveChanges();
}
}
public ComplainViewModel GetComplains(string contactNumber)
{
ComplainViewModel complain = null;
using (var _context = new NasscomEntities())
{
complain = (from complains in _context.Complains
where complains.ContactNumber == contactNumber
select
new ComplainViewModel
{
Name = complains.Name,
Email = complains.Email,
ContactNumber = complains.ContactNumber,
Location = complains.Location,
Decription = complains.Description,
Compactor = complains.Compactor
}).FirstOrDefault();
}
if (complain != null)
{
return(complain);
}
else
{
return(new ComplainViewModel());
}
}
public ActionResult GenerateReportComplains()
{
DBSmartSchoolWebPortalEntities111 db = new DBSmartSchoolWebPortalEntities111();
var List = db.Complaints.ToList();
List <ComplainViewModel> PassList = new List <ComplainViewModel>();
foreach (var i in List)
{
ComplainViewModel c = new ComplainViewModel();
c.Details = i.Details;
c.Id = i.Id;
c.Date = Convert.ToDateTime(i.Date);
PassList.Add(c);
}
ReportDocument rd = new ReportDocument();
rd.Load(Path.Combine(Server.MapPath("~/Reports"), "CrystalReportComplains.rpt"));
rd.SetDataSource(PassList);
Response.Buffer = false;
Response.ClearContent();
Response.ClearHeaders();
try
{
Stream stream = rd.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat);
stream.Seek(0, SeekOrigin.Begin);
return(File(stream, "application/pdf", "ComplaintsList.pdf"));
}
catch
{
throw;
}
}
public ActionResult SendFeedback(ComplainViewModel model)
{
Complain complain = db.Complains.Find(model.ComplainId);
complain.ReplyDate = DateTime.Now;
complain.Feedback = model.Feedback;
db.SaveChanges();
//db.Entry(complain).State = EntityState.Modified;
return(RedirectToAction("Index"));
}
public ActionResult Edit(ComplainViewModel model)
{
if (ModelState.IsValid)
{
Complain complain = Mapper.Map <ComplainViewModel, Complain>(model);
db.Entry(complain).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(model));
}
public ActionResult Create(ComplainViewModel model)
{
if (ModelState.IsValid)
{
Complain complain = Mapper.Map <ComplainViewModel, Complain>(model);
complain.CreationDate = DateTime.Now;
db.Complains.Add(complain);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(model));
}
public ActionResult AddComplaint(ComplainViewModel collection)
{
DBSmartSchoolWebPortalEntities111 db = new DBSmartSchoolWebPortalEntities111();
Complaint complaint = new Complaint();
complaint.ParentId = LoginClass.LoginId;
complaint.Details = collection.Details;
db.Complaints.Add(complaint);
db.SaveChanges();
return(RedirectToAction("Account"));
}
private ComplainViewModel GetModel(Complains complain)
{
ComplainViewModel complainModel = new ComplainViewModel()
{
Name = complain.Name,
Email = complain.Email,
ContactNumber = complain.ContactNumber,
Location = complain.Location,
Compactor = complain.Compactor,
Decription = complain.Description,
};
return(complainModel);
}
private Complain GetEntity(ComplainViewModel complain)
{
Complains complainsEntity = new Complains();
if (complain != null)
{
complainsEntity.Name = complain.Name;
complainsEntity.Email = complain.Email;
complainsEntity.ContactNumber = complain.ContactNumber;
complainsEntity.Location = complain.Location;
complainsEntity.Compactor = complain.Compactor;
complainsEntity.Description = complain.Decription;
}
return(complainsEntity);
}
public ActionResult ComplaintStatus()
{
DBSmartSchoolWebPortalEntities111 db = new DBSmartSchoolWebPortalEntities111();
var List = db.Complaints.ToList();
List <ComplainViewModel> PassList = new List <ComplainViewModel>();
foreach (var i in List)
{
ComplainViewModel c = new ComplainViewModel();
c.Details = i.Details;
c.Id = i.Id;
c.Date = Convert.ToDateTime(i.Date);
PassList.Add(c);
}
return(View(PassList));
}
// For Admin
// GET: Complains/Complains
public async Task <IActionResult> Complains()
{
if (HttpContext.Session.GetString("UserAdmin") != null)
{
var cityProblemSolverDBContext = _context.Complains.Include(c => c.Area);
ComplainViewModel complainViewModel = new ComplainViewModel
{
Complains = await cityProblemSolverDBContext.ToListAsync()
};
//ViewData["WorkerId"] = new SelectList(_context.Users.Where(t => t.UserType == "Worker"), "ID", "Name");
return(View(complainViewModel));
}
else
{
return(RedirectToAction("Admin", "Account"));
}
}
public async Task <IActionResult> Edit(int id, [Bind("ID,AreaId,ComplainDate,ComplainDescription,Status")] ComplainViewModel complain)
{
if (id != complain.ID)
{
return(NotFound());
}
//ModelState["ComplainDate"].Errors.Clear();
if (ModelState.IsValid)
{
try
{
Complain _complain = new Complain();
_complain.ID = complain.ID;
_complain.AreaId = complain.AreaId;
_complain.ComplainDate = complain.ComplainDate;
_complain.ComplainDescription = complain.ComplainDescription;
_complain.Status = complain.Status;
_context.Update(_complain);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!ComplainExists(complain.ID))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
ViewData["AreaId"] = new SelectList(_context.Areas, "ID", "Name", complain.AreaId);
return(View(complain));
}
public ActionResult ComplaintStatus()
{
DBSmartSchoolWebPortalEntities111 db = new DBSmartSchoolWebPortalEntities111();
var List = db.Complaints.Where(x => x.ParentId == LoginClass.LoginId).ToList();
List <ComplainViewModel> PassList = new List <ComplainViewModel>();
foreach (var i in List)
{
ComplainViewModel c = new ComplainViewModel();
c.Details = i.Details;
if (i.Status != 1)
{
c.Status = "UnNoticed";
}
else
{
c.Status = "Noticed!";
}
c.Date = Convert.ToDateTime(i.Date);
PassList.Add(c);
}
return(View(PassList));
}
public IHttpActionResult GetComplainByNo(string complainNo,int userId)
{
try
{
ComplainViewModel complainView = new ComplainViewModel();
Complain complain = new Complain();
complain = _complain.GetComplainByNo(complainNo, userId);
if (complain != null)
{
complainView.id = complain.ID;
complainView.complainNo = String.IsNullOrEmpty(complain.ComplainNo) ? String.Empty : complain.ComplainNo;
complainView.description = String.IsNullOrEmpty(complain.Description) ? String.Empty : complain.Description;
complainView.bus = new BusViewModel();
complainView.bus.id = complain.BusId;
complainView.bus.busNo = complain.Bus.LicenceNo;
complainView.route = new RouteViewModel();
complainView.route.id = complain.RouteId;
complainView.route.from = complain.Route.From;
complainView.route.to = complain.Route.To;
complainView.route.routeNo = complain.Route.RouteNo;
complainView.place = String.IsNullOrEmpty(complain.Place) ? String.Empty : complain.Place;
complainView.complainDate = complain.Date.ToString(@"yyyy-MM-dd");
complainView.userId = complain.UserId == null ? 0 : complain.UserId.Value;
complainView.method = String.IsNullOrEmpty(complain.Method) ? String.Empty : complain.Method;
complainView.isInqueryParticipation = complain.IsInqueryParticipation;
complainView.isEvidenceHave = complain.IsEvidenceHave;
complainView.description = String.IsNullOrEmpty(complain.Description) ? String.Empty : complain.Description;
complainView.complainerName = String.IsNullOrEmpty(complain.ComplainerName) ? String.Empty : complain.ComplainerName;
complainView.complainerAddress = String.IsNullOrEmpty(complain.ComplainerAddress) ? String.Empty : complain.ComplainerAddress;
complainView.status = complain.ComplainStatus;
complainView.telNo = String.IsNullOrEmpty(complain.ComplainerTel) ? String.Empty : complain.ComplainerTel;
if (complain.IsEvidenceHave)
{
complainView.evidence = new EvidenceViewModel();
complainView.evidence.fileName = String.IsNullOrEmpty(complain.Evidence.FileName) ? String.Empty : complainView.evidence.fileName;
complainView.evidence.evidenceNo = String.IsNullOrEmpty(complain.Evidence.EvidenceNo) ? String.Empty : complainView.evidence.evidenceNo;
complainView.evidence.extension = String.IsNullOrEmpty(complain.Evidence.Extension) ? String.Empty : complainView.evidence.extension;
complainView.evidence.filePath = String.IsNullOrEmpty(complain.Evidence.FilePath) ? String.Empty : complainView.evidence.filePath;
}
complainView.Category = new List<CategoryViewModel>();
foreach (ComplainCategory category in complain.ComplainCategories)
{
if (category.IsSelected)
{
CategoryViewModel complainCategory = new CategoryViewModel();
complainCategory.id = category.ComplainId;
complainCategory.categoryNo = String.IsNullOrEmpty(category.Category.CategoryNo) ? String.Empty : category.Category.CategoryNo;
complainCategory.description = String.IsNullOrEmpty(category.Category.Description) ? String.Empty : category.Category.Description;
complainCategory.isSelected = category.IsSelected;
complainView.Category.Add(complainCategory);
}
}
}
var messageData = new { code = Constant.SuccessMessageCode, message = Constant.MessageSuccess };
var returnObject = new { complain = complainView, messageCode = messageData };
return Ok(returnObject);
}
catch (Exception ex)
{
string errorLogId = _eventLog.WriteLogs(User.Identity.Name, ex, MethodBase.GetCurrentMethod().Name);
var messageData = new { code = Constant.ErrorMessageCode, message = String.Format(Constant.MessageTaskmateError, errorLogId) };
var returnObject = new { messageCode = messageData };
return Ok(returnObject);
}
}
private void Complains_OnUnloaded(object sender, RoutedEventArgs e)
{
ComplainViewModel.CleanUp();
}
