public ActionResult ResetPassword(ResetPassword model) { var message = ""; if (ModelState.IsValid) { using (Database1Entities3 db = new Database1Entities3()) { var user = db.Users.Where(a => a.ResetCode == model.ResetCode).FirstOrDefault(); if (user != null) { user.Password = Crypto.Hash(model.NewPassword); user.ResetCode = ""; db.Configuration.ValidateOnSaveEnabled = false; db.SaveChanges(); message = "Your Password was Updated Successfully"; } } } else { message = "Something Invalid"; } ViewBag.Message = message; return(View(model)); }
public ActionResult Save(Emp employee) { bool status = false; if (ModelState.IsValid) { using (Database1Entities3 dc = new Database1Entities3()) { if (employee.Id > 0) { //Edit var v = dc.Emps.Where(a => a.Id == employee.Id).FirstOrDefault(); if (v != null) { v.Id = employee.Id; v.Gender = employee.Gender; v.Department = employee.Department; v.City = employee.City; } } else { //Save dc.Emps.Add(employee); } dc.SaveChanges(); status = true; return(View()); } } return(new JsonResult { Data = new { status = status } }); }
protected void Page_Load(object sender, EventArgs e) { if (Session["emid"] != null) { string idkey = Session["emid"].ToString(); Database1Entities3 db = new Database1Entities3(); //使用LINQ方法 var result = db.Employee.Where(m => m.emid.Contains(idkey)); if (result.First().emname != null) { Label2.Text = result.First().emid; Label1.Text = result.First().emname; Label3.Text = result.First().emname; Label4.Text = result.First().emphone; string dekey = result.First().deid; var result1 = db.Department.Where(m => m.deid.Contains(dekey)); if (result1.First().dename != null) { Label5.Text = result1.First().dename; } } } else { Label1.Text = "未登录"; } }
public ActionResult AddEvents(Addevent modem) { string message = ""; Database1Entities3 s = new Database1Entities3(); if (ModelState.IsValid) { var isExist = IsEventNameExist(modem.EventName); if (isExist) { ModelState.AddModelError("EventNameExist", "Event Name already exist"); return(View(modem)); } s.Addevents.Add(modem); s.SaveChanges(); message = "New Event Added Successfully"; ViewBag.Message = message; return(View()); // return RedirectToAction("AdminEvents", "Events"); } else { return(View()); } }
public ActionResult EditEvent(string EventName, String Region, String Description, String Date, String City, String TypeofEvent, String NumberOfOfficialsNeeded) { if (ModelState.IsValid) { string message = ""; Database1Entities3 edit = new Database1Entities3(); Addevent p = edit.Addevents.Find(EventName); edit.Configuration.ValidateOnSaveEnabled = false; p.Region = Region; p.Description = Description; p.Date = Date; p.City = City; p.TypeofEvent = TypeofEvent; p.NumberOfOfficialsNeeded = NumberOfOfficialsNeeded; edit.SaveChanges(); message = "Event Edited Successfully"; ViewBag.Message = message; return(View()); } else { return(View()); } }
public ActionResult AssignRole(UserEvent modem) { if (ModelState.IsValid) { string message = ""; Database1Entities3 s = new Database1Entities3(); var k = s.UserEvents.Where(a => a.EmailID == modem.EmailID).FirstOrDefault(); var v = s.UserEvents.Where(a => a.EventName == modem.EventName).FirstOrDefault(); if (k != null && v != null) { k.Roles = modem.Roles; s.SaveChanges(); ModelState.Clear(); SendVerificationLinkEmail(modem.EmailID, modem.Roles, modem.EventName); message = "User roles are successfully assigned and notified for user"; ViewBag.Message = message; return(View()); } else { ModelState.AddModelError("InValidEventname", "User not Registered for this event"); return(View(modem)); } } return(View(modem)); }
public ActionResult ForgotPassword(string EmailID) { //Verify Email ID //Generate Reset password link //Send Email string message = ""; // bool status = false; using (Database1Entities3 dc = new Database1Entities3()) { var account = dc.Users.Where(a => a.EmailID == EmailID).FirstOrDefault(); if (account != null) { //Send email for reset password string resetCode = Guid.NewGuid().ToString(); SendVerificationLinkEmail(account.EmailID, resetCode); account.ResetCode = resetCode; dc.Configuration.ValidateOnSaveEnabled = false; dc.SaveChanges(); message = "Reset password link has been sent to your Email id."; } else { message = "Account not found"; } } ViewBag.Message = message; return(View()); }
public ActionResult Save(int id) { using (Database1Entities3 dc = new Database1Entities3()) { var v = dc.Emps.Where(a => a.Id == id).FirstOrDefault(); return(View(v)); } }
public ActionResult GetInfo() { using (Database1Entities3 db = new Database1Entities3()) { var employees = db.Emps.OrderBy(a => a.Gender).ToList(); return(Json(new { data = employees }, JsonRequestBehavior.AllowGet)); } }
public bool IsEventExist(string eventName) { using (Database1Entities3 dc = new Database1Entities3()) { var v = dc.Addevents.Where(a => a.EventName == eventName).FirstOrDefault(); return(v != null); } }
public bool IsEmailExist(string emailID) { using (Database1Entities3 dc = new Database1Entities3()) { var v = dc.Users.Where(a => a.EmailID == emailID).FirstOrDefault(); return(v != null); } }
public bool IsEmailidExist(string email) { using (Database1Entities3 dc = new Database1Entities3()) { string Emailid = @HttpContext.User.Identity.Name; var v = (Emailid == email); return(v); } }
public ActionResult DetailedProfiles(string email) { Database1Entities3 selectevent = new Database1Entities3(); var cl = from m in selectevent.Users where m.EmailID == email select m; return(View(cl)); }
public ActionResult Admin() { Database1Entities3 selectevent = new Database1Entities3(); var cl = from m in selectevent.Addevents orderby m.Date select m; return(View(cl)); }
public ActionResult AdminNews() { Database1Entities3 selectnews = new Database1Entities3(); var bl = from b in selectnews.News orderby b.NewsID select b; return(View(bl)); }
public ActionResult ProfileDetails() { string email = @HttpContext.User.Identity.Name; Database1Entities3 selectevent = new Database1Entities3(); var cl = from m in selectevent.Users where m.EmailID == email select m; return(View(cl)); }
public ActionResult RegisteredEvents(string eventname) { Database1Entities3 selectevent = new Database1Entities3(); var cl = from m in selectevent.Addevents orderby m.Date where m.EventName == eventname select m; return(View(cl)); }
public ActionResult UserDetails(string email) { Database1Entities3 selectUser = new Database1Entities3(); var bl = from m in selectUser.Users orderby m.UserID where m.EmailID == email select m; return(View(bl)); }
public ActionResult UserProfiles() { Database1Entities3 selectuser = new Database1Entities3(); var kl = from k in selectuser.Users orderby k.EmailID select k; return(View(kl)); }
public ActionResult UsersRegistered(string eventname) { Database1Entities3 selectevent = new Database1Entities3(); var cl = from m in selectevent.UserEvents orderby m.UserRegId where m.EventName == eventname select m; return(View(cl)); }
public ActionResult delete(string NewsTitle) { Database1Entities3 db1 = new Database1Entities3(); News del = db1.News.FirstOrDefault(X => X.NewsTitle == NewsTitle); db1.News.Remove(del); db1.SaveChanges(); return(View()); }
public ActionResult Users() { string email = @HttpContext.User.Identity.Name; Database1Entities3 selectevent = new Database1Entities3(); var cl = from m in selectevent.UserEvents orderby m.UserRegId where m.EmailID == email select m; return(View(cl)); }
public ActionResult Delete(int id) { using (Database1Entities3 db = new Database1Entities3()) { var v = db.Emps.Where(a => a.Id == id).FirstOrDefault(); if (v != null) { return(View(v)); } else { return(HttpNotFound()); } } }
public ActionResult AddNews(News modem) { Database1Entities3 k = new Database1Entities3(); if (ModelState.IsValid) { k.News.Add(modem); k.SaveChanges(); return(RedirectToAction("AdminNews", "News")); } else { return(View()); } }
public ActionResult ResetPassword(string id) { using (Database1Entities3 db = new Database1Entities3()) { var user = db.Users.Where(a => a.ResetCode == id).FirstOrDefault(); if (user != null) { ResetPassword model = new ResetPassword(); model.ResetCode = id; return(View(model)); } else { return(HttpNotFound()); } } }
public ActionResult DeleteEmployee(int id) { bool status = false; using (Database1Entities3 db = new Database1Entities3()) { var v = db.Emps.Where(a => a.Id == id).FirstOrDefault(); if (v != null) { db.Emps.Remove(v); db.SaveChanges(); status = true; } } return(new JsonResult { Data = new { status = status } }); }
public ActionResult NonSkatting([Bind(Exclude = "Password,ConfirmPassword")] string NSkRoles, string NSkExperience, string NSkCertificationLevels, string NSkAdditionalSkills) { string email = @HttpContext.User.Identity.Name; string message = ""; using (Database1Entities3 dc = new Database1Entities3()) { User edit = dc.Users.Find(email); edit.NSkRoles = NSkRoles; edit.NSkExperience = NSkExperience; edit.NSkCertificationLevels = NSkCertificationLevels; edit.NSkAdditionalSkills = NSkAdditionalSkills; dc.Configuration.ValidateOnSaveEnabled = false; dc.SaveChanges(); message = "Your details are updated successfully"; ViewBag.Message = message; return(View()); } }
protected void Page_Load(object sender, EventArgs e) { if (Session["emid"] == null) { Response.Redirect("Login.aspx"); } if (Session["emid"] != null) { string keyword = Session["emid"].ToString(); Database1Entities3 db = new Database1Entities3(); //使用LINQ方法 var result = db.Employee.Where(m => m.emid.Contains(keyword)); if (result.First().emname != null) { Label1.Text = result.First().emname; } } else { Label1.Text = "未登录"; } }
public ActionResult VerifyAccount(string id) { bool Status = false; using (Database1Entities3 dc = new Database1Entities3()) { dc.Configuration.ValidateOnSaveEnabled = false; var v = dc.Users.Where(a => a.ActivationCode == new Guid(id)).FirstOrDefault(); if (v != null) { v.IsEmailVerified = true; dc.SaveChanges(); Status = true; } else { ViewBag.Message = "Invalid Request"; } } ViewBag.Status = Status; return(View()); }
public ActionResult PersonalDetails([Bind(Exclude = "Password,ConfirmPassword")] string FirstName, string LastName, string Street, string City, string Region, string Postal, string MinistryofBackground, string PhoneNumber) { string email = @HttpContext.User.Identity.Name; using (Database1Entities3 dc = new Database1Entities3()) { User edit = dc.Users.Find(email); edit.FirstName = FirstName; edit.LastName = LastName; edit.Street = Street; edit.City = City; edit.Region = Region; edit.Postal = Postal; edit.MinistryofBackground = MinistryofBackground; edit.PhoneNumber = PhoneNumber; dc.Configuration.ValidateOnSaveEnabled = false; dc.SaveChanges(); return(RedirectToAction("Experience", "Home")); } }