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