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