public ActionResult ChangeMail(Models.Users u)
{
string newmail, pass, code, nowpass = string.Empty;
newmail = u.UMail;
pass = u.UPass;
code = u.UState;
if (!string.IsNullOrEmpty(mail) && string.IsNullOrEmpty(code))
{
return(Json(new { res = "false", msg = "请输入操作授权码！" }, JsonRequestBehavior.DenyGet));
}
if (mailCode != code)
{
return(Json(new { res = "false", msg = "授权码校验失败！" }, JsonRequestBehavior.DenyGet));
}
pass = FormsAuthentication.HashPasswordForStoringInConfigFile(nowpass, "md5");
nowpass = DBHelper.GetScalar("select UPass from Users where UNum=" + User.Identity.Name + "").ToString();
if (pass != nowpass)
{
return(Json(new { res = "false", msg = "登录密码输入错误！" }, JsonRequestBehavior.DenyGet));
}
string sql = "update Users set UMail='" + newmail + "' where UNum=" + User.Identity.Name + "";
if (DBHelper.GetLine(sql) > 0)
{
return(Json(new { res = "true", msg = "安全邮箱修改成功！" }, JsonRequestBehavior.DenyGet));
}
else
{
return(Json(new { res = "false", msg = "安全邮箱修改失败！" }, JsonRequestBehavior.DenyGet));
}
}
public async Task SignInProcedureAsync(object sender, EventArgs e)
{
Models.Users user = new Models.Users(Entry_Username.Text, Entry_Password.Text);
if (user.CheckInformation())
{
ActivitySpinner.IsVisible = true;
// var result = await App.RestService.Login(user); ---removed because we are not currently connecting to an actual server.
var result = await App.GetUserService().LoginUser(user);
// var result = new Token(); //Dummy token used because we are not actually connecting to a server at this point.
await DisplayAlert("Login", "Login Successfull", "Ok");
if (result != null)
{
ActivitySpinner.IsVisible = false;
//App.UserDatabase.SaveUser(user); //removed because we are not currently connecting to a server.
//App.TokenDatabase.SaveToken(result); //removed because we are not currently connecting to a server.
// await Navigation.PushAsync(new Dashboard());
if (Device.RuntimePlatform == Device.RuntimePlatform)
{
Application.Current.MainPage = new MasterDetail();
}
}
}
else
{
await DisplayAlert("Login", "Login not correct, empty username or password ", "Ok");
ActivitySpinner.IsVisible = false;
}
}
public ActionResult SendMail(Models.Users u)
{
string mail = DBHelper.GetScalar("exec GetMailByName '" + u.UName + "'").ToString();
if (mail == "false")
{
return(Json(new { res = "false", msg = "您的帐号未绑定安全邮箱！" }, JsonRequestBehavior.DenyGet));
}
MailHelper m = new MailHelper();
codeResult = MailHelper.RandomCode(12);
m.To = mail;
m.Title = "重置密码";
m.Body = "<h3>您此次重置密码操作的授权码是【" + codeResult + "】</h3>";
if (m.Send())
{
codeResult = codeResult + "-" + u.UName;
mail = mail.Substring(0, 1) + "***" + mail.Substring(mail.LastIndexOf('@') - 3);
return(Json(new { res = "true", msg = "授权码已发送至：" + mail }, JsonRequestBehavior.DenyGet));
}
else
{
return(Json(new { res = "false", msg = "邮件发送失败！" }, JsonRequestBehavior.DenyGet));
}
}
public ActionResult Index(Models.Users users)
{
var passwordEncripted = Encriptacion.Encriptacion.Encriptar(users.Us_Password);
var loginResultClients = cli.BuscarClientePorLogin(users.Us_User_Name, passwordEncripted);
var loginResultUsers = use.BuscarUsers(users.Us_User_Name, passwordEncripted);
if (loginResultClients != null)
{
//Si es nulo, entonces no existe.
Session["UserID"] = users.Us_User_Name;
Session["Nombre"] = loginResultClients.Cl_Nombre ?? users.Us_User_Name; //Si el campo de nombre es nulo, entonces se muestra el usuario.
Session["Type"] = "cliente";
Session["Cedula"] = loginResultClients.Cl_Cedula ?? "0"; //Si el campo es nulo, pone un 0 por valor default.
return(RedirectToAction("Index", "SeleccionDeFeria"));
}
else if (loginResultUsers)
{
Session["UserID"] = users.Us_User_Name;
Session["Type"] = "admin";
return(RedirectToAction("UserDashboard"));
}
else
{
ModelState.AddModelError("errorLogin", "Usuario y/o contrasena incorrectos");
return(View("Index"));
}
}
public ActionResult Create(Models.Users users)
{
if (Session["UserID"] != null && Session["Type"].Equals("admin"))
{
try
{
if (ModelState.IsValid)
{
//Encripta el password
var passwordEncriptado = Encriptacion.Encriptacion.Encriptar(users.Us_Password);
//Asigna la variable encriptada al objeto Password
users.Us_Password = passwordEncriptado;
var usersInsertar = Mapper.Map <DATA.Users>(users);
use.InsertarUsers(usersInsertar);
return(RedirectToAction("Index"));
}
}
catch (Exception)
{
ModelState.AddModelError("error", "No se ha podido insertar");
}
}
else
{
return(RedirectToAction("Index", "Home"));
}
return(View());
}
public void InsertUser(Models.Users user)
{
DBcontext.Users.Add(user);
DBcontext.SaveChanges();
}
//
// GET: /Advise/
public ActionResult Write(int? id)
{
var user = new Models.Users();
if (id != null)
user = EnterRepository.GetRepositoryEnter().UsersRepository.LoadEntities(m => m.ID == id).FirstOrDefault();
return View(user);
}
public ActionResult Registration(Models.RegistrationModel reg_model)
{
if (Session["session_key"] != null)
{
return(RedirectToAction("index"));
}
using (NHibernate.ISession session = NHibernateSessionManeger.OpenSession())
{
if (!ModelState.IsValid)
{
return(View());
}
else
{
NHibernate.IQuery query = session.CreateQuery("FROM Users WHERE name = '" + reg_model.Name + "'");
if (query.List <Models.Users>().Count() > 0)
{
ViewData["ErrorMessage"] = " Пользователь с ником " + reg_model.Name + " уже занят ";
return(View());
}
var usr = new Models.Users();
usr.Email = reg_model.Email;
usr.Name = reg_model.Name;
var salt = Guid.NewGuid().ToByteArray();
string hashsed_password = Convert.ToBase64String(CryptSharp.Utility.SCrypt.ComputeDerivedKey(System.Text.UTF8Encoding.UTF8.GetBytes(reg_model.Password), salt, 16384, 8, 1, null, 128));
usr.HashPassword = hashsed_password;
usr.Salt = Convert.ToBase64String(salt);
session.Save(usr);
return(RedirectToAction("authorization"));
}
}
}
public IActionResult OnGet(int?id)
{
string DbConnection = @"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=C:\Users\disko\OneDrive\1. Sheffiled Hallam University\Databases and Web\web\Assignment\Group\Group_Project_Assignment\Databases\Database.mdf;Integrated Security=True";
SqlConnection conn = new SqlConnection(DbConnection);
conn.Open();
UserRecords = new Models.Users();
using (SqlCommand command = new SqlCommand())
{
command.Connection = conn;
command.CommandText = "SELECT * FROM Userz WHERE UserId = @MemberID";
command.Parameters.AddWithValue("@MemberID", id);
Console.WriteLine("The id : " + id);
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
UserRecords.MemberID = reader.GetInt32(0);
UserRecords.UserName = reader.GetString(1);
UserRecords.UserEmail = reader.GetString(2);
UserRecords.UserCard = reader.GetString(3);
UserRecords.UserPassword = reader.GetString(4);
}
}
conn.Close();
return(Page());
}
public void Countries(Models.Users user)
{
var _roWuserCountries = from _userCountry in db.UserCountries
where _userCountry.UserId == user.UserId
select _userCountry;
if (_roWuserCountries.LongCount() > 0)
{
foreach (UserCountries _eachRow in _roWuserCountries)
{
_countriesUsers.CountryId = _eachRow.CountryId;
_countriesUsers.UserId = _eachRow.UserId;
var _roWcountriesUsers = from _contryUsers in db.Countries_Users
where _contryUsers.CountryId == _countriesUsers.CountryId
select _contryUsers;
if (_roWcountriesUsers.LongCount() > 0)
{
foreach (Countries_Users _eachcountries in _roWcountriesUsers)
{
_countries_Users = new Countries_Users();
_countries_Users.Active = _eachcountries.Active;
_countries_Users.CountryName = _eachcountries.CountryName;
_countries_Users.CountryId = _eachcountries.CountryId;
_countries_Users.ID = _eachcountries.ID;
lcoun.Add(_countries);
}
}
}
}
}
public Models.Users apimethod()
{
Models.Users users = new Models.Users();
users.username = "******";
users.sex = "man";
return(users);
}
public Models.Users GetUser(string userid)
{
Users obj = new Users();
Models.Users userObj = new Models.Users();
try
{
var user = _UserFacade.GetUser(userid);
userObj = new Models.Users
{
Id = user.Id,
Userid = user.Userid,
Firstname = user.Firstname,
Lastname = user.Lastname,
Email = user.Email,
Pass = user.Pass,
Pno = user.Pno,
Image = user.Image,
LoyaltyPoints = user.LoyaltyPoints
};
}
catch (Exception e)
{
Console.WriteLine(e.Message);
obj = null;
throw e;
}
return(userObj);
}
public ActionResult Login(Models.Users user)
{
if (ModelState.IsValid)
{
if (user.Email.Equals("*****@*****.**") && user.Passwords.Equals("connhanong"))
{
Session.Add("Admin", user);
return(RedirectToAction("Index"));
}
var check = Services.LoginServices.Login(user.Email, user.Passwords);
if (check)
{
Session.Add("User", user);
return(RedirectToAction("Index"));
}
else
{
ViewBag.Error = "Sai tai khoản/ mật khẩu";
return(View(user));
}
}
else
{
ViewBag.Error = "Sai tai khoản/ mật khẩu";
return(View(user));
}
}
public void UpdateUser(Models.Users user)
{
DBcontext.Entry(user).State = EntityState.Modified;
DBcontext.SaveChanges();
}
public ActionResult RoomieInfo(string id)
{
if (!WebCookieHelper.UserCheckLogin())
{
string userAgent = Request.UserAgent;
if (userAgent.ToLower().Contains("micromessenger"))
{
Utility.CookieHelper.SetCookie("returnurl", Request.Url.ToString(), "", 1);
return(Redirect("/weixin/account"));
}
else
{
return(Redirect("/member/login?returnurl=" + Request.Url));
}
}
if (string.IsNullOrEmpty(id))
{
Models.Users result = new Models.Users();
return(View(result));
}
int nid = int.Parse(id);
var user = EnterRepository.GetRepositoryEnter().UsersRepository.LoadEntities(m => m.ID == nid).FirstOrDefault();
return(View(user));
}
public ActionResult DeleteConfirmed(int id)
{
Models.Users users = db.Users.Find(id);
db.Users.Remove(users);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public async Task <IdentityResult> RegisterUser(Models.Users userModel)
{
Models.Users user = new Models.Users
{
UserName = userModel.UserName,
EmailConfirmed = false,
PhoneNumberConfirmed = false,
TwoFactorEnabled = false,
LockoutEnabled = false,
AccessFailedCount = 0
};
IdentityResult result = null;
try
{
result = await _userManager.CreateAsync(user, userModel.Password);
}
catch (DbEntityValidationException dbEx)
{
foreach (var validationErrors in dbEx.EntityValidationErrors)
{
foreach (var validationError in validationErrors.ValidationErrors)
{
System.Console.WriteLine("Property: {0} Error: {1}", validationError.PropertyName, validationError.ErrorMessage);
}
}
}
return(result);
}
public ActionResult SignUp(IFormCollection collection, Models.Users user)
{
PizzaBox.Domain.Users dmc = new Users();
dmc.FirstName = user.FirstName;
dmc.LastName = user.LastName;
dmc.Street = user.Street;
dmc.City = user.City;
dmc.State = user.State;
dmc.ZipCode = user.ZipCode;
dmc.Phone = user.Phone;
dmc.Email = user.Email;
dmc.Password = user.Password;
try
{
db.AddUser(dmc);
db.Save();
return(RedirectToAction(nameof(Index)));
}
catch
{
return(View());
}
}
public List <Models.Users> GetsUser(string userid)
{
List <Models.Users> obj = new List <Models.Users>();
try
{
var repobj = _AdminFacade.GetUser(userid);
if (repobj != null)
{
var iter = new Models.Users();
foreach (var user in repobj)
{
iter = new Models.Users
{
Id = user.Id,
Userid = user.Userid,
Email = user.Email,
Pass = null,
Pno = user.Pno,
Firstname = user.Firstname,
Lastname = user.Lastname,
LoyaltyPoints = user.LoyaltyPoints
};
obj.Add(iter);
}
}
}
catch (Exception e)
{
Console.WriteLine(e.Message);
obj = null;
throw e;
}
return(obj);
}
private static System.Collections.Generic.List <Models.Users> ListAuthStatic()
{
var List = new System.Collections.Generic.List <Models.Users>();
var User = new Models.Users();
//tuanmjnh
User.Id = Guid.Parse("f4191f70-2c4a-442e-a62d-b4b6833b33f4");
User.Username = "******";
User.Password = "******";//"Tuanmjnh@tm"; //"fc44d0279133a2f46178134ce9bf2167";//tuanmjnh@123
User.Salt = "1c114c58-69d9-41e6-bd3e-363906e04e50";
User.FullName = "Bơm Bơm";
User.FullName = "tuanmjnh";
User.Mobile = "0123456789";
User.Email = "*****@*****.**";
User.Address = "SuperAdmin";
User.Roles = Common.Roles.superadmin;
User.Orders = 0;
User.CreatedBy = "f4191f70-2c4a-442e-a62d-b4b6833b33f4";
User.CreatedAt = DateTime.Now;
User.UpdatedBy = "f4191f70-2c4a-442e-a62d-b4b6833b33f4";
User.UpdatedAt = DateTime.Now;
User.LastLogin = DateTime.Now;
User.Flag = 1;
User.Extras = null;
//Add User to list
List.Add(User);
return(List);
}
public ActionResult LoginState(Models.Users u)
{
//验证码
string code = RouteData.Values["id"].ToString();
if (code.ToUpper() != codeResult)
{
return(Content("Code"));
}
if (!ModelState.IsValid)
{
return(Content("false"));
}
//md5密码加密 上线后开启
u.UPass = FormsAuthentication.HashPasswordForStoringInConfigFile(u.UPass, "md5");
//通过验证
string res = DBHelper.GetScalar("exec CheckLogin '" + u.UName + "','" + u.UPass + "'").ToString().Trim();
if (res == "State")
{
return(Content(res));
}
else if (res == "false")
{
return(Content(res));
}
else
{
//生成认证Session
FormsAuthentication.SetAuthCookie(res, true);
return(Content(res));
}
}
private void processResponse(String json)
{
Helpers.JsonMsg jsonMsg = JsonConvert.DeserializeObject <Helpers.JsonMsg>(json);
switch (jsonMsg.msg)
{
case "error-login":
AlertDialog.Builder alert = new AlertDialog.Builder(this);
alert.SetTitle("B³¹d");
alert.SetMessage("Z³y login lub has³o.");
alert.SetNeutralButton("OK", (senderAlert, args) => {
return;
});
RunOnUiThread(() =>
{
alert.Show();
});
break;
default:
Models.Users user = JsonConvert.DeserializeObject <Models.Users>(jsonMsg.msg);
loginUser(user);
Finish();
break;
}
}
public TokenUser RefreshTokenLogin(string refreshToken)
{
if (refreshToken != null)
{
Models.Users dbUser = _dbContext.Users.FirstOrDefault(x => x.RefreshToken == refreshToken);
if (dbUser != null && dbUser?.RefreshTokenEndDate > DateTime.Now)
{
MyTokenHandler tokenHandler = new MyTokenHandler(_appSettings);
Token token = tokenHandler.CreateAccessToken();
dbUser.RefreshToken = token.RefreshToken;
dbUser.RefreshTokenEndDate = token.Expiration.AddMinutes(5);
_dbContext.SaveChanges();
Auth.User user = new Auth.User()
{
Email = dbUser.UserName, Name = dbUser.Name, Password = dbUser.Password, Surname = dbUser.Surname
};
return(new TokenUser()
{
Token = token, User = user
});
}
}
return(null);
}
public ActionResult UserInfo()
{
string Tel = WebCookieHelper.GetUserInfo(2);
string Name = WebCookieHelper.GetUserInfo(1);
//未缓存手机号
if (string.IsNullOrEmpty(Tel))
{
string userAgent = Request.UserAgent;
if (userAgent.ToLower().Contains("micromessenger"))
{
Utility.CookieHelper.SetCookie("returnurl", Request.Url.ToString(), "", 1);
return(Redirect("/weixin/account"));
}
else
{
return(Redirect("/member/login?returnurl=" + Request.Url));
}
}
var result = EnterRepository.GetRepositoryEnter().UsersRepository.LoadEntities(m => m.Tel == Tel).FirstOrDefault();
if (result == null)
{
result = new Models.Users();
result.Tel = Tel;
result.Name = Name;
}
if (result.EmployeeID != 0)
{
var employee = EnterRepository.GetRepositoryEnter().EmployeeRepository.LoadEntities(m => m.ID == result.EmployeeID).FirstOrDefault();
ViewBag.employee = employee;
}
return(View(result));
}
public ActionResult UserInfo(Models.Users user)
{
GlobalMethod.log.Info(string.Format("{0}{1}提交报名信息", DateTime.Now.ToString(), user.Name));
string Tel = WebCookieHelper.GetUserInfo(2);
var u = EnterRepository.GetRepositoryEnter().UsersRepository.LoadEntities(m => m.Tel == user.Tel).FirstOrDefault();
if (u == null)
{
user.Pwd = SystemContext.Instance.GetPwd(Tel);
user.CreateTime = DateTime.Now;
EnterRepository.GetRepositoryEnter().UsersRepository.AddEntity(user);
}
else
{
if (user.ID == 0)
{
user.ID = u.ID;
}
EnterRepository.GetRepositoryEnter().UsersRepository.EditEntity(user, new string[] { "Name", "Gender", "School", "ExamSchool", "ExamPlace", "ExceptRoomie", "Baks" });
}
if (EnterRepository.GetRepositoryEnter().SaveChange() > 0)
{
return(Content(""));
}
else
{
return(Content("提交成功"));
}
}
public async Task <IActionResult> RegisterAccount([FromBody] Models.Users user)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
bool bDuplicateEmail = _usersRepository.FindDuplicateEmail(user.Email);
if (bDuplicateEmail)
{
return(Conflict("Duplicate Email"));
}
bool bDuplicateaUserName = _usersRepository.FindDuplicateEmail(user.UserName);
if (bDuplicateaUserName)
{
return(Conflict("Duplicate UserName"));
}
user = await _usersRepository.Add(user);
var results = new ObjectResult(user)
{
StatusCode = (int)HttpStatusCode.OK
};
return(results);
}
public void UserCont(Models.Users user, Models.ApplicationUsers ApplicationUsers)
{
Functions _functions = new Functions();
_functions.Countries(user);
int userId = user.UserId;
int countryId = _functions._countriesUsers.CountryId;
int ApplicationId = _roWApplicationusers.ApplicationId;
var list = _functions.lcoun;
List <string> var = new List <string>();
List <int> country = new List <int>();
foreach (Countries _eachCountries in list)
{
var.Add(_eachCountries.ID);
CountriesUsers c = new CountriesUsers(country, var, ApplicationId, userId);
Session["CountriesUsers"] = c;
}
foreach (Countries _eachCountry in list)
{
country.Add(_eachCountry.CountryId);
CountriesUsers c = new CountriesUsers(country, var, ApplicationId, userId);
Session["CountriesUsers"] = c;
}
}
protected override void Seed(WebApp.ApplicationDbContext context)
{
// This method will be called after migrating to the latest version.
// You can use the DbSet<T>.AddOrUpdate() helper extension method
// to avoid creating duplicate seed data. E.g.
//
//context.Person.AddOrUpdate(
// p => p.FullName,
// new Person { FullName = "Andrew Peters" },
// new Person { FullName = "Brice Lambson" },
// new Person { FullName = "Rowan Miller" }
//);
AutomaticMigrationsEnabled = true;
if (context.User.Where(w => w.IsSuperAdmin && w.IsActive).FirstOrDefault() == null)
{
Models.Users user = new Models.Users();
user.IsActive = user.IsSuperAdmin = true;
user.IsPasswordResetRequested = user.IsTeam = false;
user.Name = "Super Admin";
user.Password = "******";
user.UserName = "******";
user.Email = "*****@*****.**";
user.DateCreated = DateTime.Now;
Identity.UsersManager userManager = new Identity.UsersManager();
userManager.CreateAdminUser(user);
}
}
public ActionResult Count()
{
var users = new Models.Users();
ViewBag.Count = users.GetCount();
return(View());
}
public virtual System.Web.Mvc.ActionResult SetPasswrod(Models.Users user, string Password, string ConfirmPassword)
{
if (ConfirmPassword == string.Empty | ConfirmPassword == null)
{
ModelState.AddModelError
(key: "confirmPassword", errorMessage: "Confirm Password Is Required ..!");
}
Models.Users originalItem =
MyDatabaseContext.User.Find(user.Id);
if (originalItem == null)
{
return(HttpNotFound());
}
if (Password != ConfirmPassword)
{
ModelState.AddModelError
(key: "confirmPassword", errorMessage: "Confirm Password Is Not Correct");
}
originalItem.Password = Password;
MyDatabaseContext.SaveChanges();
return(RedirectToAction(MVC.Admin.Users.Index()));
}
protected void Page_Load(object sender, EventArgs e)
{
currentuser = sitetemp.getcurrentuser(false);
if (!IsPostBack)
{
ddlcurrency.DataTextField = "info_currency_code";
ddlcurrency.DataValueField = "info_currencies_key";
ddlcurrency.DataSource = sitetemp.view_info_currencies_cannhold();
ddlcurrency.DataBind();
}
}
public ActionResult Edit(int id, Models.UserEntity data)
{
try
{
var users = new Models.Users();
users.Update(data);
return RedirectToAction("List");
}
catch
{
return View();
}
}
protected void Page_Load(object sender, EventArgs e)
{
currentuser = sitetemp.getcurrentuser(true);
}
public ActionResult Count()
{
var users = new Models.Users();
ViewBag.Count = users.GetCount();
return View();
}
public ActionResult List()
{
var users = new Models.Users();
return View(users.GetList());
}
public ActionResult Edit(int id)
{
var users = new Models.Users();
return View(users.GetDetail(id));
}
