public ActionResult AskQuery(string complaintid)
{
dbCMSEntities db = new dbCMSEntities();
try
{
if (Session["LoginType"].Equals("Worker") && Session["Id"] != null)
{
string cid = complaintid;
string sid = Session["Id"].ToString();
var comobj = (from c in db.tblComplaints
where (c.ComplaintId.ToString().Equals(cid) && c.ComplaintStatus.Equals("Assigned") && c.WorkerId.ToString().Equals(sid))
select c).FirstOrDefault();
if (comobj == null)
{
return(RedirectToAction("Home", "Worker"));
}
else
{
return(View(comobj));
}
}
else
{
return(RedirectToAction("Login", "Login"));
}
}
catch (Exception)
{
return(RedirectToAction("Error", "Home"));
}
}
public ActionResult Feedback(tblComplaint comobj)
{
dbCMSEntities db = new dbCMSEntities();
try
{
if (Session["LoginType"].Equals("Customer") && Session["Id"] != null)
{
var obj = (from c in db.tblComplaints
where c.ComplaintId.Equals(comobj.ComplaintId)
select c).FirstOrDefault();
obj.ComplaintStatus = "Feedback Provided";
obj.Feedback = comobj.Feedback;
db.SaveChanges();
return(RedirectToAction("Home", "Customer"));
}
else
{
return(RedirectToAction("Login", "Login"));
}
}
catch (Exception)
{
return(RedirectToAction("Error", "Home"));
}
}
public ActionResult Close(string complaintid)
{
dbCMSEntities db = new dbCMSEntities();
try
{
if (Session["LoginType"].Equals("ProductAdmin") && Session["Id"] != null)
{
int cid = int.Parse(complaintid);
var comobj = (from c in db.tblComplaints
where c.ComplaintId.Equals(cid)
select c).FirstOrDefault();
comobj.ComplaintStatus = "Closed";
db.SaveChanges();
return(RedirectToAction("Home", "ProductAdmin"));
}
else
{
return(RedirectToAction("Login", "Login"));
}
}
catch (Exception)
{
return(RedirectToAction("Error", "Home"));
}
}
public ActionResult AskQuery(tblComplaint comobj)
{
try
{
if (Session["LoginType"].Equals("Worker") && Session["Id"] != null)
{
dbCMSEntities db = new dbCMSEntities();
var obj = (from c in db.tblComplaints
where c.ComplaintId.Equals(comobj.ComplaintId)
select c).FirstOrDefault();
obj.WorkerQuery = comobj.WorkerQuery;
obj.CustomerReply = "Awaiting Reply";
db.SaveChanges();
return(RedirectToAction("Home", "Worker"));
}
else
{
return(RedirectToAction("Login", "Login"));
}
}
catch (Exception)
{
return(RedirectToAction("Error", "Home"));
}
}
public ActionResult Assign(int complaintid)
{
try
{
dbCMSEntities db = new dbCMSEntities();
string sid = Session["Id"].ToString();
Session["complaintid"] = complaintid;
var comp = (from p in db.tblComplaints
where p.ComplaintId.Equals(complaintid) && (p.ComplaintStatus.Equals("Not Assigned") | p.ComplaintStatus.Equals("Feedback Provided"))
select p).FirstOrDefault();
string pid = comp.ProductId.ToString();
var prodadmin = (from p in db.tblProducts
where p.ProductId.ToString().Equals(pid) && p.ProductAdminId.ToString().Equals(sid)
select p).FirstOrDefault();
var worker = from w in db.tblWorkers
where w.ProductAdminId.ToString().Equals(sid)
select w;
return(View(worker));
}
catch (Exception)
{
return(RedirectToAction("Home", "ProductAdmin"));
}
}
public ActionResult Reply(string complaintid)
{
dbCMSEntities db = new dbCMSEntities();
try
{
if (Session["LoginType"].Equals("Customer") && Session["Id"] != null)
{
string cid = complaintid;
string customerid = Session["Id"].ToString();
var comobj = (from c in db.tblComplaints
where c.ComplaintId.ToString().Equals(cid) && c.CustomerId.ToString().Equals(customerid)
select c).FirstOrDefault();
if (comobj.CustomerReply == "Awaiting Reply")
{
return(View(comobj));
}
else
{
return(RedirectToAction("Login", "Login"));
}
}
else
{
return(RedirectToAction("Login", "Login"));
}
}
catch (Exception)
{
return(RedirectToAction("Error", "Home"));
}
}
public ActionResult NewComplaint(tblComplaint compobj)
{
try
{
if (Session["LoginType"].Equals("Customer") && Session["Id"] != null)
{
dbCMSEntities db = new dbCMSEntities();
compobj.CustomerId = int.Parse(Session["Id"].ToString());
compobj.ComplaintStatus = "Not Assigned";
compobj.WorkerQuery = "NA";
compobj.CustomerReply = "NA";
compobj.Feedback = "NA";
compobj.ComplaintDate = DateTime.Now;
db.tblComplaints.Add(compobj);
db.SaveChanges();
return(RedirectToAction("Home", "Customer"));
}
else
{
return(RedirectToAction("Login", "Login"));
}
}
catch (Exception)
{
return(RedirectToAction("Error", "Home"));
}
}
public ActionResult Home()
{
try
{
if (Session["LoginType"].Equals("Worker") && Session["Id"] != null)
{
dbCMSEntities db = new dbCMSEntities();
string sessionid = Session["Id"].ToString();
var worker = (from work in db.tblWorkers
where work.WorkerId.ToString().Equals(sessionid)
select work).FirstOrDefault();
var complaintdata = from comp in db.tblComplaints
where comp.WorkerId.ToString().Equals(sessionid)
select comp;
WorkerView wv = new WorkerView {
Workerdata = worker, Complaintdata = complaintdata
};
return(View(wv));
}
else
{
return(RedirectToAction("Login", "Login"));
}
}
catch (Exception)
{
return(RedirectToAction("Error", "Home"));
}
}
public ActionResult Home()
{
try
{
if (Session["LoginType"].Equals("Customer") && Session["Id"] != null)
{
dbCMSEntities db = new dbCMSEntities();
string sessionid = Session["Id"].ToString();
var customer = (from cus in db.tblCustomers
where cus.CustomerId.ToString().Equals(sessionid)
select cus).FirstOrDefault();
var complaint = (from com in db.tblComplaints
where com.CustomerId.ToString().Equals(sessionid)
select com);
CustomerView custview = new CustomerView()
{
Customerdata = customer, Complaintdata = complaint
};
return(View(custview));
}
else
{
return(RedirectToAction("Login", "Login"));
}
}
catch (Exception)
{
return(RedirectToAction("Error", "Home"));
}
}
public ActionResult Assign(string WorkerId)
{
if (Session["LoginType"].Equals("ProductAdmin") && Session["Id"] != null)
{
string paid = Session["Id"].ToString();
string cid = Session["complaintid"].ToString();
dbCMSEntities db = new dbCMSEntities();
try
{
var worker = (from w in db.tblWorkers
where w.WorkerId.ToString().Equals(WorkerId)
select w).FirstOrDefault();
if (worker.ProductAdminId.ToString() != Session["Id"].ToString())
{
ModelState.AddModelError("Error", "Invalid Worker Id");
var workernew = from w in db.tblWorkers
where w.ProductAdminId.ToString().Equals(paid)
select w;
return(View(workernew));
}
var comp = (from i in db.tblComplaints
where i.ComplaintId.ToString().Equals(cid)
select i).FirstOrDefault();
comp.WorkerId = worker.WorkerId;
comp.ComplaintStatus = "Assigned";
worker.NoOfCases = worker.NoOfCases + 1;
worker.CurrentStatus = "Working";
db.SaveChanges();
return(RedirectToAction("Home", "ProductAdmin"));
}
catch (System.NullReferenceException)
{
ModelState.AddModelError("Error", "Invalid Worker Id");
var worker = from w in db.tblWorkers
where w.ProductAdminId.ToString().Equals(paid)
select w;
return(View(worker));
}
catch (System.InvalidOperationException)
{
ModelState.AddModelError("Error", "Invalid Worker Id");
var worker = from w in db.tblWorkers
where w.ProductAdminId.ToString().Equals(paid)
select w;
return(View(worker));
}
}
else
{
return(RedirectToAction("Login", "Login"));
}
}
public ActionResult SignUp(tblCustomer obj)
{
dbCMSEntities db = new dbCMSEntities();
try
{
db.tblCustomers.Add(obj);
db.SaveChanges();
return(RedirectToAction("Successful", "Home"));
}
catch (Exception)
{
ModelState.AddModelError("Error", "Email or Account Number already registered");
return(View());
}
}
public ActionResult Resolved(string complaintid)
{
dbCMSEntities db = new dbCMSEntities();
try
{
if (Session["LoginType"].Equals("Worker") && Session["Id"] != null)
{
int cid = int.Parse(complaintid);
string wid = Session["Id"].ToString();
var comobj = (from c in db.tblComplaints
where c.ComplaintId.Equals(cid)
select c).FirstOrDefault();
comobj.ComplaintStatus = "Resolved";
comobj.WorkerQuery = "NA";
comobj.CustomerReply = "NA";
var worker = (from w in db.tblWorkers
where w.WorkerId.ToString().Equals(wid)
select w).FirstOrDefault();
if (worker.NoOfCases == 1)
{
worker.CurrentStatus = "Free";
}
worker.NoOfCases = worker.NoOfCases - 1;
db.SaveChanges();
return(RedirectToAction("Home", "Worker"));
}
else
{
return(RedirectToAction("Login", "Login"));
}
}
catch (Exception)
{
return(RedirectToAction("Error", "Home"));
}
}
public ActionResult Home()
{
try
{
if (Session["LoginType"].Equals("ProductAdmin") && Session["Id"] != null)
{
dbCMSEntities db = new dbCMSEntities();
string sessionid = Session["Id"].ToString();
var productadmin = (from proda in db.tblProductAdmins
where proda.ProductAdminId.ToString().Equals(sessionid)
select proda).FirstOrDefault();
string paid = productadmin.ProductAdminId.ToString();
var productdata = (from p in db.tblProducts
where p.ProductAdminId.ToString().Equals(paid)
select p).FirstOrDefault();
string pid = productdata.ProductId.ToString();
var complaintdata = from p in db.tblComplaints
where p.ProductId.ToString().Equals(pid)
select p;
ProductAdminView pav = new ProductAdminView {
ProductAdmindata = productadmin, Complaintdata = complaintdata
};
return(View(pav));
}
else
{
return(RedirectToAction("Login", "Login"));
}
}
catch (Exception)
{
return(RedirectToAction("Error", "Home"));
}
}
public ActionResult ForgotPassword(tblCustomer obj)
{
string accno = obj.AccountNumber;
string email = obj.Email;
dbCMSEntities db = new dbCMSEntities();
var customer = (from c in db.tblCustomers
where c.AccountNumber.Equals(accno) && c.Email.Equals(email)
select c).FirstOrDefault();
if (customer == null)
{
ModelState.AddModelError("Error", "Invalid Email or Account Number");
return(View());
}
Session["ResetId"] = customer.CustomerId;
return(RedirectToAction("ResetPassword"));
}
public ActionResult Home()
{
try
{
if (Session["LoginType"].Equals("SystemAdmin") && Session["Id"] != null)
{
dbCMSEntities db = new dbCMSEntities();
string sessionid = Session["Id"].ToString();
var systemadmin = (from sysa in db.tblSystemAdmins
where sysa.SystemAdminId.ToString().Equals(sessionid)
select sysa).FirstOrDefault();
var compdata = from c in db.tblComplaints
select c;
var worker = from w in db.tblWorkers
select w;
var prodadmin = from p in db.tblProductAdmins
select p;
var customer = from c in db.tblCustomers
select c;
SystemAdminView sav = new SystemAdminView()
{
complaintdata = compdata, workerdata = worker, productadmindata = prodadmin, systemadmindata = systemadmin, customerdata = customer
};
return(View(sav));
}
else
{
return(RedirectToAction("Login", "Login"));
}
}
catch (Exception)
{
return(RedirectToAction("Error", "Home"));
}
}
public ActionResult ResetPassword()
{
dbCMSEntities db = new dbCMSEntities();
try
{
string sessionid = Session["ResetId"].ToString();
var customer = (from c in db.tblCustomers
where c.CustomerId.ToString().Equals(sessionid)
select c).First();
customer.SecurityAnswer = null;
customer.Pssd = null;
return(View(customer));
}
catch (Exception)
{
return(RedirectToAction("Error", "Home"));
}
}
public ActionResult Delete(string complaintid)
{
try
{
if (Session["LoginType"].Equals("SystemAdmin") && Session["Id"] != null)
{
dbCMSEntities db = new dbCMSEntities();
var complainttable = (from i in db.tblComplaints
where i.ComplaintId.ToString().Equals(complaintid) && i.ComplaintStatus.Equals("Closed")
select i).FirstOrDefault();
db.tblComplaints.Remove(complainttable);
db.SaveChanges();
return(RedirectToAction("Home", "SystemAdmin"));
}
}
catch (Exception)
{
return(RedirectToAction("Error", "Home"));
}
return(RedirectToAction("Error", "Home"));
}
public ActionResult ResetPassword(tblCustomer obj)
{
dbCMSEntities db = new dbCMSEntities();
try
{
string sessionid = Session["ResetId"].ToString();
string answer = obj.SecurityAnswer;
var customer = (from c in db.tblCustomers
where c.CustomerId.ToString().Equals(sessionid) && c.SecurityAnswer.Equals(answer)
select c).FirstOrDefault();
if (customer == null)
{
ModelState.AddModelError("Error", "Incorrect security answer");
var customernew = (from a in db.tblCustomers
where a.CustomerId.ToString().Equals(sessionid)
select a).First();
customernew.SecurityAnswer = null;
customernew.Pssd = null;
return(View(customernew));
}
customer.ConPssd = obj.ConPssd;
customer.Pssd = obj.Pssd;
db.SaveChanges();
return(RedirectToAction("SuccessfulReset", "Login"));
}
catch (Exception)
{
return(RedirectToAction("Error", "Home"));
}
}
public ActionResult ChangePassword(Login credentials)
{
dbCMSEntities dbo = new dbCMSEntities();
string Pssd = credentials.Pssd;
string LoginType = Session["LoginType"].ToString();
string NewPssd = credentials.NewPssd;
int uid = int.Parse(Session["Id"].ToString());
if (LoginType == "SystemAdmin")
{
var user = (from u in dbo.tblSystemAdmins
where u.SystemAdminId.Equals(uid) && u.Pssd.Equals(Pssd)
select u).FirstOrDefault();
try
{
if (user.Pssd == Pssd)
{
if (Pssd == NewPssd)
{
ModelState.AddModelError("Error", "Old and New Password cannot be the same");
return(View());
}
user.Pssd = NewPssd;
dbo.SaveChanges();
return(RedirectToAction("Login", "Login"));
}
}
catch (Exception)
{
ModelState.AddModelError("Error", "Invalid Old Password");
return(View());
}
}
else if (LoginType == "ProductAdmin")
{
var user = (from u in dbo.tblProductAdmins
where u.ProductAdminId.Equals(uid) && u.Pssd.Equals(Pssd)
select u).FirstOrDefault();
try
{
if (user.Pssd == Pssd)
{
if (Pssd == NewPssd)
{
ModelState.AddModelError("Error", "Old and New Password cannot be the same");
return(View());
}
user.Pssd = NewPssd;
dbo.SaveChanges();
return(RedirectToAction("Login", "Login"));
}
}
catch (Exception)
{
ModelState.AddModelError("Error", "Invalid Old Password");
return(View());
}
}
else if (LoginType == "Worker")
{
var user = (from u in dbo.tblWorkers
where u.WorkerId.Equals(uid) && u.Pssd.Equals(Pssd)
select u).FirstOrDefault();
try
{
if (user.Pssd == Pssd)
{
if (Pssd == NewPssd)
{
ModelState.AddModelError("Error", "Old and New Password cannot be the same");
return(View());
}
user.Pssd = NewPssd;
dbo.SaveChanges();
return(RedirectToAction("Login", "Login"));
}
}
catch (Exception)
{
ModelState.AddModelError("Error", "Invalid Old Password");
return(View());
}
}
else if (LoginType == "Customer")
{
var user = (from u in dbo.tblCustomers
where u.CustomerId.Equals(uid) && u.Pssd.Equals(Pssd)
select u).FirstOrDefault();
try
{
if (user.Pssd == Pssd)
{
if (Pssd == NewPssd)
{
ModelState.AddModelError("Error", "Old and New Password cannot be the same");
return(View());
}
user.Pssd = NewPssd;
user.ConPssd = NewPssd;
dbo.SaveChanges();
return(RedirectToAction("Login", "Login"));
}
}
catch (Exception)
{
ModelState.AddModelError("Error", "Invalid Old Password");
return(View());
}
}
return(RedirectToAction("Index", "Home"));
}
public ActionResult Login(Login credentials)
{
string Email = credentials.Email;
string Pssd = credentials.Pssd;
string LoginType = credentials.LoginType;
dbCMSEntities dbo = new dbCMSEntities();
try
{
if (LoginType == "SystemAdmin")
{
var user = (from u in dbo.tblSystemAdmins
where u.Email.Equals(Email) && u.Pssd.Equals(Pssd)
select u).FirstOrDefault();
if (user.Pssd == Pssd)
{
Session["Id"] = user.SystemAdminId;
Session["LoginType"] = LoginType;
return(RedirectToAction("Home", "SystemAdmin"));
}
ModelState.AddModelError("Error", "Invalid Email or Password");
return(View());
}
else if (LoginType == "ProductAdmin")
{
var user = (from u in dbo.tblProductAdmins
where u.Email.Equals(Email) && u.Pssd.Equals(Pssd)
select u).FirstOrDefault();
if (user.Pssd == Pssd)
{
Session["Id"] = user.ProductAdminId;
Session["LoginType"] = LoginType;
return(RedirectToAction("Home", "ProductAdmin"));
}
ModelState.AddModelError("Error", "Invalid Email or Password");
return(View());
}
else if (LoginType == "Worker")
{
var user = (from u in dbo.tblWorkers
where u.Email.Equals(Email) && u.Pssd.Equals(Pssd)
select u).FirstOrDefault();
if (user.Pssd == Pssd)
{
Session["Id"] = user.WorkerId;
Session["LoginType"] = LoginType;
return(RedirectToAction("Home", "Worker"));
}
ModelState.AddModelError("Error", "Invalid Email or Password");
return(View());
}
else if (LoginType == "Customer")
{
var user = (from u in dbo.tblCustomers
where u.Email.Equals(Email) && u.Pssd.Equals(Pssd)
select u).FirstOrDefault();
if (user.Pssd == Pssd)
{
Session["Id"] = user.CustomerId;
Session["LoginType"] = LoginType;
return(RedirectToAction("Home", "Customer"));
}
ModelState.AddModelError("Error", "Invalid Email or Password");
return(View());
}
}
catch (System.NullReferenceException)
{
ModelState.AddModelError("Error", "Invalid Email or Password");
return(View());
}
return(RedirectToAction("Index", "Home"));
}
