public ActionResult AddSolution(FeedBackModel loSolution)
{
AdminDataContext loAdminContext = new AdminDataContext();
loAdminContext.AddSolution(loSolution);
SmtpClient Client = new SmtpClient("smtp.gmail.com");
Random rnd = new Random();
string to = loSolution.EmailID;
string from = "*****@*****.**";//"*****@*****.**";
string subject = "Solution for Complaint on Online Education System";
string body = "<font>Hello dear " + loSolution.UserName + "<br /> Thanks for Contacting Us<br /><p> As your Complaint for Complaint ID - " + loSolution.ComplaintID + " as " + loSolution.Subjet + "we have tried to solve your complaint. The Solution is as below <br /></p><p>" + loSolution.Solution + "</p>Hope It will helpful to you <br/> </r>Thanks From Edu Team</font>";
MailMessage mail = new MailMessage(from, to, subject, body);
mail.IsBodyHtml = true;
Client.EnableSsl = true;
Client.Port = 443;
Client.UseDefaultCredentials = false;
Client.DeliveryMethod = SmtpDeliveryMethod.Network;
Client.Credentials = new NetworkCredential("*****@*****.**", "Admin.Online");//("*****@*****.**", "CFvgbhnj12#");
Client.Send(mail);
ViewBag.msg = "Email Sent";
return(RedirectToAction("Index"));
}
// GET: Admin/FeedBackandComplaint
public ActionResult Index()
{
AdminDataContext loAdminContext = new AdminDataContext();
FeedBackModel loFeedBack = new FeedBackModel();
loFeedBack.loComplaints = loAdminContext.GetComplaintsList();
var s = 0;
var U = 0;
foreach (var data in loFeedBack.loComplaints)
{
if (data.Solution == null)
{
U++;
}
else
{
s++;
}
}
ViewBag.Solved = s;
ViewBag.UnSolved = U;
ViewBag.TotalComplaints = loFeedBack.loComplaints.Count();
return(View(loFeedBack));
}
public ActionResult AboutUs()
{
QueryDataContext loQContext = new QueryDataContext();
List <QueryModel> loq = new List <QueryModel>();
loq = loQContext.GetQueries();
var c = 0;
foreach (var d in loq)
{
if (d.Answer != null)
{
c++;
}
}
TempData["Q"] = loq.Count();
TempData["TA"] = c;
AdminDataContext loEduContext = new AdminDataContext();
List <UserModel> loUsers = new List <UserModel>();
loUsers = loEduContext.GetUsers();
TempData["U"] = loUsers.Count();
TempData["FC"] = loEduContext.GetFeedBacksAndComplaints().Count();
return(View());
}
public static void AddAdmin(string misparIshi,
bool isSuperAdmin,
// Whether we should set isSuperAdmin if this admin already exists or
// just leave the current value.
bool forceNewAdminLevel = true)
{
if (!CurrentMisparIshi.IsSuperAdmin())
{
return;
}
var dataContext = new AdminDataContext();
var existingAdmin = dataContext.Admins
.Where(admin => admin.MisparIshi == misparIshi)
.FirstOrDefault();
if (existingAdmin != null)
{
if (forceNewAdminLevel)
{
existingAdmin.IsSuperAdmin = isSuperAdmin;
}
}
else
{
var newAdmin = new Admin();
newAdmin.MisparIshi = misparIshi;
newAdmin.IsSuperAdmin = isSuperAdmin;
dataContext.Admins.InsertOnSubmit(newAdmin);
}
dataContext.SubmitChanges();
AdminChangeWriter.WriteAdminChange(
String.Format("Added admin {0}", misparIshi));
CurrentMisparIshi.SetAdmins();
}
public ActionResult Feedback(int?id)
{
AdminDataContext db = new AdminDataContext();
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Service service = db.Services.Find(id);
ViewBag.Payment = service.Payment;
Session["OrderId"] = service.OrderId;
if (service == null)
{
return(HttpNotFound());
}
else if (service.Payment == false)
{
return(RedirectToAction("ErrorFeedback"));
}
return(RedirectToAction("CreateFeedback"));
}
public ActionResult ForgotPassword(Forgotpassword forgotpassword, string ReturnUrl = "")
{
string message = "";
bool Status = false;
using (var context = new AdminDataContext())
{
User entity = context.Users.FirstOrDefault(x => x.Email == forgotpassword.Email);
if (entity != null)
{
if (string.Compare(forgotpassword.Ques1, entity.Ques1) == 0 && string.Compare(forgotpassword.Ques2, entity.Ques2) == 0 && string.Compare(forgotpassword.Ques3, entity.Ques3) == 0)
{
entity.Password = forgotpassword.NewPassword;
entity.ConfirmPassword = entity.Password;
context.Entry(entity).State = EntityState.Modified;
context.SaveChanges();
Status = true;
message = $"Password successfully changed for {entity.Email}";
}
else
{
message = "Wrong Answers to the Questions";
}
}
else
{
message = "User with this email dosen't exist";
}
}
ViewBag.Message = message;
ViewBag.Status = Status;
return(View(forgotpassword));
}
//Tickets View
public ActionResult TicketView()
{
AdminDataContext db = new AdminDataContext();
string uid = Convert.ToString(Session["UID"]);
return(View(db.Tickets.Where(x => x.UserEmail == uid).ToList()));
}
public static tbl_lkp_License Edit_LicenseLookup(int licid)
{
using (AdminDataContext adb = new AdminDataContext())
{
return(adb.tbl_lkp_Licenses.Where(c => c.LicenseType_ID == licid).SingleOrDefault());
}
}
public static List <AdminLinq.tbl_lkp_LicenseCheckList> Bind_licenseCheckList(string licid, string action)
{
using (AdminDataContext pdb = new AdminDataContext())
{
return(pdb.tbl_lkp_LicenseCheckLists.Where(c => c.License_Type_ID == licid).ToList());
}
}
//Service List
private List <Service> GetServices()
{
var context = new AdminDataContext();
List <Service> ServiceList = context.Services.ToList();
return(ServiceList);
}
public ActionResult EditServiceBookingCleaner(int id)
{
var context = new AdminDataContext();
var selectedservice = context.Services.Where(s => s.OrderId == id).FirstOrDefault();
return(View(selectedservice));
}
public static List <Tbl_Login> Get_Password(int loginid)
{
using (AdminDataContext db = new AdminDataContext())
{
return(db.Tbl_Logins.Where(c => c.loginID == loginid).ToList());
}
}
public static List <Tbl_Login> BindGrid_ManageUsers()
{
using (AdminDataContext db = new AdminDataContext())
{
return(db.Tbl_Logins.ToList());
}
}
public static List <Tbl_Login> Get_UserandPassword(string username, string password)
{
using (AdminDataContext db = new AdminDataContext())
{
return(db.Tbl_Logins.Where(c => c.UserName == username && c.Password == password).ToList());
}
}
public static List <Tbl_Login> Get_Username(string username)
{
using (AdminDataContext db = new AdminDataContext())
{
return(db.Tbl_Logins.Where(c => c.UserName == username).ToList());
}
}
public static List <USP_Licensing_GetLicenseCheckListResult> getLicChecklist(int LicenseTypeID, int Action)
{
using (AdminDataContext pdb = new AdminDataContext())
{
return(pdb.USP_Licensing_GetLicenseCheckList(LicenseTypeID, Action).ToList());
}
}
public static int licChecklistInsert_Values(int licchecklistid, string lictype, string action, string checklist, string status, string ismandatory)
{
using (AdminDataContext pdetalinsert = new AdminDataContext())
{
tbl_lkp_LicenseCheckList checklistdetail;
if (licchecklistid == 0)
{
checklistdetail = new tbl_lkp_LicenseCheckList();
}
else
{
checklistdetail = pdetalinsert.tbl_lkp_LicenseCheckLists.Where(c => c.License_CheckList_ID == licchecklistid).SingleOrDefault();
}
checklistdetail.License_CheckList_ID = licchecklistid;
checklistdetail.License_Type_ID = lictype;
checklistdetail.Action = action;
checklistdetail.CheckList_ID = checklist;
checklistdetail.Status = status;
checklistdetail.Is_Mandatory = ismandatory;
if (licchecklistid == 0)
{
pdetalinsert.tbl_lkp_LicenseCheckLists.InsertOnSubmit(checklistdetail);
}
pdetalinsert.SubmitChanges();
return(checklistdetail.License_CheckList_ID);
}
}
public static tbl_lkp_LicenseCheckList Edit_licChecklist(int licchecklistid)
{
using (AdminDataContext db = new AdminDataContext())
{
return(db.tbl_lkp_LicenseCheckLists.Where(c => c.License_CheckList_ID == licchecklistid).SingleOrDefault());
}
}
//View Feedback
public ActionResult FeedbackView()
{
AdminDataContext db = new AdminDataContext();
string uid = Convert.ToString(Session["UID"]);
return(View(db.Feedbacks.Where(s => s.UserId == uid).ToList()));
}
public static Tbl_Login Edit_ManageUsers(int userid)
{
using (AdminDataContext db = new AdminDataContext())
{
return(db.Tbl_Logins.Where(c => c.loginID == userid).SingleOrDefault());
}
}
//Cleaner List
private List <Cleaner> GetCleaners()
{
var context = new AdminDataContext();
List <Cleaner> CleanerList = context.Cleaners.ToList();
return(CleanerList);
}
protected void btnYes_Click(object sender, EventArgs e)
{
int deleteId = 0;
if (ViewState["index"] != null)
{
rowIdx = int.Parse(ViewState["index"].ToString());
}
if (gView.DataKeys[rowIdx].Value.ToString() != null)
{
deleteId = int.Parse(gView.DataKeys[rowIdx].Value.ToString());
}
AdminDataContext admin = new AdminDataContext();
var rec = (from d in admin.tblLogonIds
select d
).Where(p => p.Id == deleteId);
foreach (var deletedRecord in rec)
{
admin.tblLogonIds.DeleteOnSubmit(deletedRecord);
admin.SubmitChanges();
}
gView.EditIndex = -1;
var dat = BusLogic.SelectUsers();
gView.DataSource = dat;
gView.DataBind();
}
public ActionResult Edit(int id)
{
var context = new AdminDataContext();
var std = context.Cleaners.Where(s => s.Id == id).FirstOrDefault();
return(View(std));
}
public ActionResult Registration([Bind(Exclude = "AdminApproved,CleanerAssigned")] Cleaner cleaner)
{
bool Status = false;
string Message = "";
if (ModelState.IsValid)
{
var isExist = IsCleanerIdExist(cleaner.CleanerId);
if (isExist)
{
ModelState.AddModelError("CleanerIdExist", "CleanerId already exist");
return(View(cleaner));
}
cleaner.AdminApproved = false;
cleaner.CleanerAssigned = false;
using (var context = new AdminDataContext())
{
context.Cleaners.Add(cleaner);
context.SaveChanges();
Status = true;
Message = "New Cleaner Created Successfully, Registration sent for approval";
}
}
else
{
Message = "Invalid Request";
}
ViewBag.Message = Message;
ViewBag.Status = Status;
return(View(cleaner));
}
public ActionResult ForgotUserId(ForgotUserid user)
{
string message = "";
bool Status = false;
//model validation
using (var context = new AdminDataContext())
{
var entity = context.Users.FirstOrDefault(x => x.ContactNumber == user.ContactNumber);
if (entity != null)
{
if (string.Compare(user.Ques1, entity.Ques1) == 0 && string.Compare(user.Ques2, entity.Ques2) == 0 && string.Compare(user.Ques3, entity.Ques3) == 0)
{
Status = true;
message = $"User ID is {entity.Email} ";
}
else
{
message = "Wrong Answers to the Questions";
}
}
else
{
message = "User with this Contact NUmber dosen't exist";
}
}
ViewBag.Message = message;
ViewBag.Status = Status;
return(View(user));
}
public ActionResult GetTutorialsBySearch(string Subject, string Category, string Keywords)
{
AdminDataContext dbContext = new AdminDataContext();
List <TutorialsModel> loTutorials = new List <TutorialsModel>();
loTutorials = dbContext.GetTutorialsBySearch((Subject == "")?null:Subject, (Category == "")?null:Category, (Keywords == "")?null:Keywords);
return(View("~/Areas/Admin/Views/Tutorials/_GetTutorialsBySearch.cshtml", loTutorials));
}
public static void EventLog(long?userId, string strEvent)
{
using (AdminDataContext adminDB = new AdminDataContext())
{
long?result = 0;
adminDB.InsertEvent(userId, strEvent, ref result);
}
}
public ActionResult GetComplaints(string ID, string status)
{
AdminDataContext loAdminContext = new AdminDataContext();
FeedBackModel loFeedBack = new FeedBackModel();
loFeedBack.loComplaints = loAdminContext.GetComplaintsList((ID == "") ? null : ID, (status == "") ? null : status);
return(View("~/Areas/Admin/Views/FeedBackandComplaint/_GetComplaintsForSearch.cshtml", loFeedBack));
}
public static void ErrorLog(long?userId, string error, string url)
{
using (AdminDataContext adminDB = new AdminDataContext())
{
long?result = 0;
adminDB.InsertErrors(userId, error, url, ref result);
}
}
// GET: Admin/Tutorials
public ActionResult Index()
{
AdminDataContext dbContext = new AdminDataContext();
TutorialsModel loTutorials = new TutorialsModel();
loTutorials.loTutorialsData = dbContext.GetTutorials();
return(View("Tutorials", loTutorials));
}
