public ActionResult FogertPassword(string EmailID)
{
//verify email
Console.WriteLine(EmailID);
string message = "";
bool status = false;
using (UserDBEntities dataconnect = new UserDBEntities())
{
var account = dataconnect.Users.Where(value => value.Email == EmailID).FirstOrDefault();
if (account != null)
{
//Send email for reset password
string resetCode = Guid.NewGuid().ToString();
SendVerificationLinkEmail(account.Email, resetCode, "ResetPassword");
account.ResetPassword = resetCode;
//
dataconnect.Configuration.ValidateOnSaveEnabled = status;
dataconnect.SaveChanges();
message = "Reset Password link has been sent to your email id.";
}
else
{
message = "Account Not Found";
}
}
ViewBag.Message = message;
return(View());
}
public JsonResult GetPop(int id, string ImageName)
{
string result = "Fail";
UserDBEntities user = new UserDBEntities();
Upload upload = new Upload();
var model = db.Uploads.Find(id);
model.ModifiedName = ImageName;
if (model.ModifiedName != null)
{
model.IsModified = true;
upload = model;
user.Entry(upload).State = System.Data.Entity.EntityState.Modified;
user.SaveChanges();
result = "successfully Modified";
}
//if (upload.MemberId == id)
//{
// var data = user.Uploads.FirstOrDefault();
// return View(data);
//}
return(Json(result, JsonRequestBehavior.AllowGet));
}
public ActionResult ResetPassword(ResetPassworsModel model)
{
var message = "";
if (ModelState.IsValid)
{
using (UserDBEntities data = new UserDBEntities())
{
var user = data.Users.Where(value => value.ResetPassword == model.ResetCode).FirstOrDefault();
if (user != null)
{
user.Password = Crypto.Hash(model.NewPassword);
user.ResetPassword = "";
data.Configuration.ValidateOnSaveEnabled = false;
data.SaveChanges();
message = "New Password Updated successfully";
}
}
}
else
{
message = "Somthing Invalide";
}
ViewBag.Message = message;
return(View(model));
}
public List<Profiles> getRandomProfiles()
{
using(var context = new UserDBEntities())
{
context.Database.Connection.Open();
List<Profiles> list = context.Profiles.ToList();
List<int> ids = new List<int>();
foreach(var i in list)
{
ids.Add(i.Id);
}
List<Profiles> filteredList = new List<Profiles>();
Random random = new Random();
List<int> ranNumbers = new List<int>();
int c = 0;
while (c < 5)
{
int ran = ids[random.Next(ids.Count)];
if (!ranNumbers.Contains(ran))
{
ranNumbers.Add(ran);
filteredList.Add(getUserByID(ran));
c++;
}
}
return filteredList;
}
}
public ActionResult Edit(Use use)
{
try
{
UserDBEntities db = new UserDBEntities();
db.Entry(use).State = System.Data.Entity.EntityState.Modified;
use.Password = Crypto.Hash(use.Password);
db.SaveChanges();
}
catch (DbEntityValidationException e)
{
foreach (var eve in e.EntityValidationErrors)
{
Console.WriteLine("Entity of type \"{0}\" in state \"{1}\" has the following validation errors:",
eve.Entry.Entity.GetType().Name, eve.Entry.State);
foreach (var ve in eve.ValidationErrors)
{
Console.WriteLine("- Property: \"{0}\", Error: \"{1}\"",
ve.PropertyName, ve.ErrorMessage);
}
}
throw;
}
return(RedirectToAction("EditData"));
}
public HttpResponseMessage Put([FromBody] int id, [FromUri] UserReg user)
{
using (UserDBEntities entities = new UserDBEntities())
{
try
{
var entity = entities.UserRegs.FirstOrDefault(e => e.UserId == id);
if (entity == null)
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Employee with id = " + id.ToString() + " not found to update."));
}
else
{
entity.Username = user.Username;
entity.Pwd = user.Pwd;
entity.ConfirmPwd = user.ConfirmPwd;
entity.Uemail = user.Uemail;
entity.Salary = user.Salary;
entities.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.OK, entity));
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex));
}
}
}
public ActionResult Edit(int id)
{
UserDBEntities db = new UserDBEntities();
var model = db.Uses.Find(id);
return(View(model));
}
public ActionResult Logic()
{
using (UserDBEntities userDB = new UserDBEntities())
{
var innerJoin = (from e in db.Uses
join d in db.Countries on e.Countryid equals d.Countryid
join f in db.States on e.StateId equals f.StateId
join h in db.Cities on f.StateId equals h.StateId
select new User
{
Username = e.Username,
Email = e.Email.ToString(),
Uid = e.Uid,
DateOfBirth = e.DateOfBirth.Value,
MobileNumber = e.MobileNumber.ToString(),
Address = e.Address.ToString(),
Gender = e.Gender.ToString(),
Cname = d.Cname,
Sname = f.Sname,
Cityname = h.Cityname,
IsActive = e.IsActive.Value
}).ToList();
return(View(innerJoin));
}
// return View(userDB.Uses.ToList());
}
public JsonResult Modify(string imageName)
{
string result = "Fail";
UserDBEntities userDB = new UserDBEntities();
// Upload upload = new Upload();
Upload upload = new Upload();
var data = userDB.Uploads.FirstOrDefault();
data.ModifiedName = imageName;
if (data.ModifiedName != null)
{
data.IsModified = true;
upload = data;
userDB.Entry(upload).State = System.Data.Entity.EntityState.Modified;
userDB.SaveChanges();
}
//userDB.SaveChanges();
result = "success";
return(Json(result, JsonRequestBehavior.AllowGet));
}
public static bool Login(string username, string password)
{
using (UserDBEntities entities = new UserDBEntities())
{
return(entities.Mods.Any(user => user.Username.Equals(username,
StringComparison.OrdinalIgnoreCase) && user.Password == password));
}
}
public ActionResult GetData( )
{
UserDBEntities user = new UserDBEntities();
var data = user.Uploads.ToList();
return(View(data));
}
/// <summary>
/// Hämtar alla användare
/// </summary>
public List<Profiles> fetchProfiles()
{
using (var context = new UserDBEntities())
{
context.Database.Connection.Open();
return context.Profiles.ToList();
}
}
public bool IsEmailExist(string emailID)
{
using (UserDBEntities connect = new UserDBEntities())
{
var v = connect.Users.Where(a => a.Email == emailID).FirstOrDefault();
return(v != null);
}
}
public bool IsEmailExist(string Email)
{
using (UserDBEntities db = new UserDBEntities())
{
var v = db.Uses.Where(a => a.Email == Email).FirstOrDefault();
return(v != null);
}
}
public ActionResult Edit(int id)
{
UserDBEntities db = new UserDBEntities();
UserTable user = db.UserTables.Where(u => u.UserID == id).Single();
UserEditVM userEditVM = new UserEditVM(user);
return(View("Edit", userEditVM));
}
public bool IsEmailExsist(string emailID)
{
using (UserDBEntities db = new UserDBEntities())
{
var v = db.Users.Where(a => a.EmailID == emailID).FirstOrDefault();
return(v != null);
}
}
public JsonResult GetCityName(int?StateId)
{
UserDBEntities db = new UserDBEntities();
var result = db.Cities.Where(e => e.StateId == StateId).Select(e => new SelectListItem {
Text = e.Cityname, Value = e.CityId.ToString()
}).ToList();
return(Json(result, JsonRequestBehavior.AllowGet));
}
public Profiles getUserByID(int id)
{
Profiles user;
using (var context = new UserDBEntities())
{
user = context.Profiles.Find(id);
}
return user;
}
public ActionResult Delete(int id)
{
UserDBEntities db = new UserDBEntities();
var model = db.Uses.Find(id);
db.Uses.Remove(model);
db.SaveChanges();
return(RedirectToAction("EditData"));
}
public IEnumerable <User> Get()
{
//Instance of UserDB entities.
using (UserDBEntities entities = new UserDBEntities())
{
//Return List of Users objects.
return(entities.Users.ToList());
}
}
public ActionResult Details(int id)
{
ViewBag.Message = "Details about customer.";
var db = new UserDBEntities();
UserTable user = db.UserTables.Where(u => u.UserID == id).Single();
UserDetailsVM userDetailsVM = new UserDetailsVM(user);
return(View("Details", userDetailsVM));
}
public string getPAboutById(int id)
{
using (var context = new UserDBEntities())
{
var about = (from a in context.Profiles
where (a.Id == id)
select a.About).Single();
return about;
}
}
public bool getHide(int id)
{
using (var context = new UserDBEntities())
{
var hide = (from a in context.SECURITY
where (a.PID == id)
select a.VISIBILITY).SingleOrDefault();
return hide;
}
}
public string getName(int id)
{
using (var context = new UserDBEntities())
{
var user = (from a in context.Profiles
where (a.Id == id)
select a).SingleOrDefault();
return user.Firstname;
}
}
public void setPic(int id, string filename)
{
using (var context = new UserDBEntities())
{
var user = (from a in context.Profiles
where (a.Id == id)
select a).SingleOrDefault();
user.Pic = filename;
context.SaveChanges();
}
}
public void setPAboutById(int id, string about)
{
using (var context = new UserDBEntities())
{
var user = (from a in context.Profiles
where (a.Id == id)
select a).SingleOrDefault();
user.About = about;
context.SaveChanges();
}
}
public ActionResult Registration()
{
UserViewModel use = new UserViewModel();
using (UserDBEntities db = new UserDBEntities())
{
use.CountryList = db.Countries.Select(e => new SelectListItem {
Text = e.Cname.ToString(), Value = e.Countryid.ToString()
}).ToList();
}
return(View(use));
}
public ActionResult Remove(int id)
{
UserDBEntities db = new UserDBEntities();
UserTable user = db.UserTables.Where(u => u.UserID == id).Single();
if (user != null)
{
db.UserTables.Remove(user);
}
db.SaveChanges();
return(Customers());
}
/// <summary>
/// Hämtar en user med viss id
/// </summary>
public List<Profiles> findProfilesByName(string name)
{
using (var context = new UserDBEntities())
{
context.Database.Connection.Open();
List<Profiles> profile = (from a in context.Profiles
where (a.Lastname.Contains(name) || a.Firstname.Contains(name))
select a).ToList();
return profile;
}
}
public ActionResult Registration([Bind(Exclude = "IsEmailVerified, ActivationCode")] User user)
{
bool Status = false;
string message = "";
//Model Validation
if (ModelState.IsValid)
{
#region //Email Exists
var isExist = IsEmailExist(user.Email);
if (isExist)
{
ModelState.AddModelError("EmailExist", "Email already exist");
return(View(user));
}
#endregion
#region Generate Activation Code
user.ActivationCode = Guid.NewGuid();
#endregion
#region Password Hashing
user.Password = Crypto.Hash(user.Password);
user.ConfirmPassword = Crypto.Hash(user.ConfirmPassword);
#endregion
user.IsEmailVerified = false;
#region Save to Database
using (UserDBEntities connect = new UserDBEntities())
{
connect.Users.Add(user);
connect.SaveChanges();
//Send Email to User
SendVerificationLinkEmail(user.Email, user.ActivationCode.ToString());
message = "Registration successfully done. Account activation link " +
" has been sent to your Email:" + user.Email;
Status = true;
}
#endregion
}
else
{
message = "Invalid Request";
}
ViewBag.Message = message;
ViewBag.Status = Status;
return(View(user));
}
public ActionResult Registration([Bind(Exclude = "IsEmailVerified, ActivationCode")] User user)
{
bool Status = false;
string message = "";
//model validation
if (ModelState.IsValid)
{
#region //email already exsists
var isExist = IsEmailExsist(user.EmailID);
if (isExist)
{
ModelState.AddModelError("EmailExist", "Email already exists");
return(View(user));
}
#endregion
#region generate activation code
user.ActivationCode = Guid.NewGuid();
#endregion
#region password hashing
user.Password = Crypto.Hash(user.Password);
user.ConfirmPassword = Crypto.Hash(user.ConfirmPassword);
#endregion
user.IsEmailVerified = false;
#region save to database
using (UserDBEntities db = new UserDBEntities())
{
db.Users.Add(user);
db.SaveChanges();
//send details to user via email
sendverificationEmail(user.EmailID, user.ActivationCode.ToString());
message = "Registration successfully completed. Check your email to verify the account.";
Status = true;
}
#endregion
}
else
{
message = "Invalied request";
}
ViewBag.Message = message;
ViewBag.Status = Status;
return(View(user));
}
public ActionResult Edit(UserEditVM user)
{
UserDBEntities db = new UserDBEntities();
UserTable userToUpdate = db.UserTables.Where(u => u.Username == user.Username).Single();
userToUpdate.Username = user.Username;
userToUpdate.Password = user.Password;
userToUpdate.IsAdmin = user.IsAdmin;
userToUpdate.Age = user.Age;
userToUpdate.FirstName = user.FirstName;
userToUpdate.LastName = user.LastName;
db.SaveChanges();
return(Customers());
}
public void setHide(int id, bool choice)
{
using (var context = new UserDBEntities())
{
var hide = (from a in context.SECURITY
where (a.PID == id)
select a).SingleOrDefault();
if (choice == true)
hide.VISIBILITY = true;
if (choice == false)
hide.VISIBILITY = false;
context.SaveChanges();
}
}
public HttpResponseMessage Get(int id)
{
using (UserDBEntities entities = new UserDBEntities())
{
var entity = entities.UserRegs.FirstOrDefault(e => e.UserId == id);
if (entity != null)
{
return(Request.CreateResponse(HttpStatusCode.OK, entity));
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Employee with id = " + id.ToString() + " not found."));
}
}
}
// GET: ExportData
public ActionResult ExportToExcel()
{
UserDBEntities db = new UserDBEntities();
var data = db.Uses.ToList().Select(p => new
{
p.Uid,
p.Username,
p.Email,
p.MobileNumber,
p.Address,
p.Gender,
p.DateOfBirth,
p.IsEmailVerified,
p.Countryid,
p.StateId,
p.CityId,
p.IsActive
});
// instantiate the GridView control from System.Web.UI.WebControls namespace
// set the data source
GridView gridview = new GridView();
gridview.DataSource = data;
gridview.DataBind();
// Clear all the content from the current response
Response.ClearContent();
Response.Buffer = true;
// set the header
Response.AddHeader("content-disposition", "attachment;filename = itfunda.xls");
Response.ContentType = "application/ms-excel";
Response.Charset = "";
// create HtmlTextWriter object with StringWriter
using (StringWriter sw = new StringWriter())
{
using (HtmlTextWriter htw = new HtmlTextWriter(sw))
{
// render the GridView to the HtmlTextWriter
gridview.RenderControl(htw);
// Output the GridView content saved into StringWriter
Response.Output.Write(sw.ToString());
Response.Flush();
Response.End();
}
}
return(View());
}
public ActionResult Register(RegisterVM user)
{
using (UserDBEntities db = new UserDBEntities())
{
if (db.UserTables.Any(x => x.Username == user.userTable.Username))
{
ViewBag.DuplicateMessage = "Username already exist.";
return(View("Register", user));
}
db.UserTables.Add(user.userTable);
db.SaveChanges();
}
ModelState.Clear();
ViewBag.SuccessMessage = "Registration Successful.";
return(View("Login", new LoginVM()));
}
public ActionResult Login(UserLogin login, string ReturnUrl = "")
{
string message = "";
using (UserDBEntities connect = new UserDBEntities())
{
var account = connect.Users.Where(attribute => attribute.Email == login.Email).FirstOrDefault();
if (account != null)
{
if (!account.IsEmailVerified)
{
ViewBag.Message = "Please verify your email first";
return(View());
}
if (string.Compare(Crypto.Hash(login.Password), account.Password) == 0)
{
int timeout = login.RememberMe ? 525600 : 20; //1 year
var ticket = new FormsAuthenticationTicket(login.Email, login.RememberMe, timeout);
string encrypted = FormsAuthentication.Encrypt(ticket);
var cookie = new HttpCookie(FormsAuthentication.FormsCookieName, encrypted);
cookie.Expires = DateTime.Now.AddMinutes(timeout);
cookie.HttpOnly = true;
Response.Cookies.Add(cookie);
if (Url.IsLocalUrl(ReturnUrl))
{
return(Redirect(ReturnUrl));
}
else
{
return(RedirectToAction("Index", "Contacts"));
}
}
else
{
message = "Invalid data provided";
}
}
else
{
message = "Invalid data provided";
}
}
ViewBag.Message = message;
return(View());
}
public HttpResponseMessage Get(string Username = "******")
{
using (UserDBEntities entities = new UserDBEntities())
{
switch (Username.ToLower())
{
case "default":
return(Request.CreateResponse(HttpStatusCode.OK, entities.UserRegs.ToList()));
//case "male":
// return Request.CreateResponse(HttpStatusCode.OK,
// entities.UserRegs.Where(e => e.Username.ToLower() == Username));
default:
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, "Value for username must match. " + Username + " is invalid"));
}
}
}
public ActionResult ResetPassword(string id)
{
using (UserDBEntities data = new UserDBEntities())
{
var user = data.Users.Where(value => value.ResetPassword == id).FirstOrDefault();
if (user != null)
{
ResetPassworsModel model = new ResetPassworsModel();
model.ResetCode = id;
return(View(model));
}
else
{
return(HttpNotFound());
}
}
}
public ActionResult Login(LoginVM login)
{
using (UserDBEntities db = new UserDBEntities())
{
var user = db.UserTables.Where(a => a.Username.Equals(login.Username) && a.Password.Equals(login.Password)).FirstOrDefault();
if (user != null)
{
System.Web.Security.FormsAuthentication.SetAuthCookie(user.Username, false);
return(RedirectToAction("Collection", "Collection"));
}
else
{
ModelState.AddModelError("", "Username or password is wrong.");
}
}
ModelState.Remove("Password");
return(View());
}
/// <summary>
/// Lägger till en användare i databasen
/// </summary>
public void insertUser(Profiles profile, SECURITY security)
{
try
{
using (var context = new UserDBEntities())
{
context.Database.Connection.Open();
context.Profiles.Add(profile);
context.SaveChanges();
security.PID = profile.Id;
context.SECURITY.Add(security);
context.SaveChanges();
}
}
catch (Exception e)
{
}
}
public SECURITY loginUser(SECURITY user)
{
using (var context = new UserDBEntities())
{
context.Database.Connection.Open();
SECURITY usr = null;
try
{
usr = context.SECURITY.Single(u => u.USERNAME == user.USERNAME && u.PASSWORD == user.PASSWORD);
}
catch
{
usr = null;
}
return usr;
}
}
public void UpdatePassword(int id, string newpass)
{
using (var context = new UserDBEntities())
{
var user = (from a in context.SECURITY
where (a.PID == id)
select a).SingleOrDefault();
user.PASSWORD = newpass;
context.SaveChanges();
}
}
public bool comparePassword(int id, string oldpass)
{
using (var context = new UserDBEntities())
{
var user = (from a in context.SECURITY
where (a.PID == id)
select a).SingleOrDefault();
if (user.PASSWORD == oldpass)
return true;
else
return false;
}
}
