public IHttpActionResult CreateUser(Entities.Users user)
{
string result = "";
result = new Models.DAO.Users().CreateUser(user).ToString();
return(Json(result));
}
public void DeleteNull()
{
Entities.Users obj = null;
adaptadorUsers.Setup(item => item.SaveChanges()).Returns(null);
BusinessRules.Interfaces.IUsers BusinessRulesUsers = new BusinessRules.BusinessRules.Users(adaptadorUsers.Object);
var objReturn = BusinessRulesUsers.Delete(obj);
Assert.IsTrue(objReturn == null);
}
public bool UserAddSession(Entities.Users entityUser)
{
if (entityUser != null)
{
Session[CacheKey.LoginUser] = entityUser;
return(true);
}
else
{
return(false);
}
}
public void Delete()
{
var obj = new Entities.Users {
Id = 1
};
adaptadorUsers.Setup(item => item.SaveChanges()).Returns(1);
BusinessRules.Interfaces.IUsers BusinessRulesUsers = new BusinessRules.BusinessRules.Users(adaptadorUsers.Object);
var objReturn = BusinessRulesUsers.Delete(obj);
Assert.IsTrue(objReturn != null && objReturn.Value);
}
protected override void Seed(DL.Entities.Model1 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.
//
Authors author = new Entities.Authors {
Id = 1, FirstName = "Aleksandr ", LastName = "Pushkin"
};
Authors author2 = new Entities.Authors {
Id = 2, FirstName = "Stiven ", LastName = "King"
};
context.Authors.AddOrUpdate(author);
context.Authors.AddOrUpdate(author2);
Genres genre = new Entities.Genres {
Id = 1, Name = "Horror"
};
Genres genre2 = new Entities.Genres {
Id = 2, Name = "Multik"
};
context.Genres.AddOrUpdate(genre);
context.Genres.AddOrUpdate(genre2);
Books book = new Entities.Books {
Id = 1, AuthorId = 1, Title = "Romeo i Juletta", GenreId = 1, Price = 1000, Pages = 150
};
Books book2 = new Entities.Books {
Id = 2, AuthorId = 2, Title = "Fast & Furious", GenreId = 2, Price = 2000, Pages = 450
};
context.Books.AddOrUpdate(book);
context.Books.AddOrUpdate(book2);
Users user = new Entities.Users {
Id = 1, Email = "*****@*****.**", FIO = "Roberto Cavalli"
};
Users user2 = new Entities.Users {
Id = 2, Email = "*****@*****.**", FIO = "Yves Saint-Laurent"
};
context.Users.AddOrUpdate(user);
context.Users.AddOrUpdate(user2);
base.Seed(context);
}
/// <summary>
/// Change password of user.
/// </summary>
/// <param int="userId">The id of the user to change</param>
/// <param string="password">The new password</param>
/// <returns>The user with new password</returns>
public async Task <Domain.Models.Users> UpdateUserPasswordAsync(int userId, string password)
{
_logger.LogInformation("Updating user with ID {ticketId} with new password {password}", userId, password);
Entities.Users currentEntity = await _dbContext.Users.FindAsync(userId);
var newEntity = currentEntity;
newEntity.Password = password;
_dbContext.Entry(currentEntity).CurrentValues.SetValues(newEntity);
return(Mapper.MapUsers(newEntity));
}
public static User UserToModel(Entities.Users UserEntity)
{
return(new User()
{
id = (int)UserEntity.id,
firstName = UserEntity.firstName,
lastName = UserEntity.lastName,
mail = UserEntity.mail,
hmoId = (int)UserEntity.hmoId,
password = UserEntity.password,
tz = UserEntity.tz
});
}
public static Entities.Users UserToEntity(User userModel)
{
Entities.Users employee = new Entities.Users()
{
id = userModel.id,
firstName = userModel.firstName,
lastName = userModel.lastName,
mail = userModel.mail,
hmoId = userModel.hmoId,
password = userModel.password,
tz = userModel.tz
};
return(employee);
}
/// <summary>
/// 用户添加Cookie免登陆信息
/// </summary>
/// <returns></returns>
public bool UserAddCookie(Entities.Users entityUser)
{
if (entityUser != null && UserAddSession(entityUser))
{
BLL.User bllUser = new BLL.User();
Common.Helper.CookieHelper.SetCookie(Common.CacheKey.CookieUserName, entityUser.UserName, new TimeSpan(Common.CacheKey.CookieTimeSpan, 0, 0, 0));
Common.Helper.CookieHelper.SetCookie(Common.CacheKey.CookieUserEncrypt, bllUser.UserCookieEncrypt(entityUser.UserName, entityUser.Password, this.IP), new TimeSpan(7, 0, 0, 0));
return(true);
}
else
{
return(false);
}
}
public int UpdateLoginCount(string userName, int addCount = 1)
{
DataAccess.DBEntities context = new DataAccess.DBEntities();
Entities.Users user = context.Users.Where(m => m.UserName == userName).FirstOrDefault();
if (user != null)
{
user.LoginCount += addCount;
return(context.SaveChanges());
}
else
{
return(-1);
}
}
/// <summary>
/// 根据cookie信息获取用户登录
/// </summary>
/// <param name="userName">用户名</param>
/// <param name="userEncrypt">Cookie加密信息</param>
/// <returns></returns>
public Entities.Users CookieLogin(string userName, string userIP, string userEncrypt)
{
if (string.IsNullOrWhiteSpace(userName) || string.IsNullOrWhiteSpace(userEncrypt))
{
return(null);
}
DataAccess.DBEntities context = new DataAccess.DBEntities();
Entities.Users user = context.Users.Where(m => m.UserName == userName).FirstOrDefault();
if (user != null && UserCookieEncrypt(user.UserName, user.Password, userIP).Equals(userEncrypt))
{
return(user);
}
else
{
return(null);
}
}
public async Task <JsonResult> GetUserId()
{
try
{
string strUserName = User.Identity.Name;
Entities.Users user = await usersAppServices.GetUser(strUserName);
return(Json(new AjaxResponse {
Success = true, Result = user.Id
}));
}
catch (Exception ex)
{
Logger.Error(ex.Message);
return(Json(new AjaxResponse {
Success = false, Result = ex.Message
}));
}
}
public override void OnAuthorization(AuthorizationContext filterContext)
{
if (this.ValidateLogin)
{
//获取用户session信息
Entities.Users LoginUser = filterContext.HttpContext.Session[Common.CacheKey.LoginUser] as Entities.Users;
string path = filterContext.HttpContext.Request.Path;
if (LoginUser == null)//未登录或已退出
{
string url = "/Login/" + (ValidateAdmin?"AdminLogin":"******");
if (!string.IsNullOrEmpty(path))
{
path = filterContext.HttpContext.Server.UrlEncode(path);
url = url + "?returnurl=" + path;
}
filterContext.Result = new RedirectResult(url);
}
else
{
if (ValidateAdmin && LoginUser.IsAdmin == 0)//管理员身份验证
{
string url = "/Login/AdminLogin";
if (!string.IsNullOrEmpty(path))
{
path = filterContext.HttpContext.Server.UrlEncode(path);
url = url + "?returnurl=" + path;
}
filterContext.Result = new RedirectResult(url);
}
if (ValidateRequest && path != "/")
{
//PowerProvider provider = new PowerProvider();
//bool hasPower = provider.HasPower(path,LoginUser.RoleNum);
//if (!hasPower)
//{
// string url = "/Home/Error";
// filterContext.Result = new RedirectResult(url);
//}
}
}
}
}
public static bool Update(Entities.Users user, double addMoney)
{
bool condition = false;
using (var connection = DBConnection.Instance.Connection)
{
var money = Convert.ToDouble(user.Money.ToString());
double sum = money + addMoney;
string strdub = sum.ToString().Replace(',', '.');
var command_AddUser = new MySqlCommand($"UPDATE USERS SET " +
$"MONEY={strdub} WHERE LOGIN='******'", connection);
connection.Open();
command_AddUser.ExecuteNonQuery();
condition = true;
connection.Close();
}
return(condition);
}
public Entities.Users GetUser(int id)
{
using (SqlConnection connection = new SqlConnection(configuration.GetConnectionString("ConnectionString")))
{
try
{
connection.Open();
var query = $"SELECT Id, Name, Money FROM [BetPlay].[dbo].[Users] WHERE Id = {id}";
SqlCommand command = new SqlCommand(query, connection);
command.ExecuteNonQuery();
SqlDataReader reader = command.ExecuteReader();
Entities.Users response = readRows(reader).FirstOrDefault();
reader.Close();
connection.Close();
return(response);
}
catch (Exception ex)
{
throw ex;
}
}
}
public virtual async Task <JsonResult> Login(LoginViewModel model)
{
int loginStatus = -1;
loginStatus = usersAppServices.GetLoginStatus(model.UserName, model.Password);
Entities.Users entity = await usersAppServices.GetUser(model.UserName);
if (loginStatus == 0)
{
List <Claim> claims = new List <Claim>
{
new Claim(ClaimTypes.Name, model.UserName),
new Claim(ClaimTypes.Surname, entity.Name),
new Claim(ClaimTypes.Sid, entity.Id.ToString())
};
ClaimsIdentity identity = new ClaimsIdentity(claims, CookieAuthenticationDefaults.AuthenticationScheme);
ClaimsPrincipal principal = new ClaimsPrincipal(identity);
await HttpContext.SignInAsync(CookieAuthenticationDefaults.AuthenticationScheme, principal, new AuthenticationProperties { IsPersistent = model.RememberMe });
}
return(Json(new AjaxResponse {
Result = loginStatus
}));
}
/// <summary>
/// 用户登录
/// </summary>
/// <param name="UserName">用户名</param>
/// <param name="Password">密码</param>
/// <param name="VerificationCode">验证码</param>
public Entities.Users Login(string userName, string password, string verificationCode)
{
DataAccess.DBEntities context = new DataAccess.DBEntities();
Entities.Users user = context.Users.Where(m => m.UserName == userName && m.Password == password).FirstOrDefault();
return(user);
}
public ActionResult Index()
{
Entities.Users user = this.LoginUser;
return(View());
}
public Task PutUser(Entities.Users entity)
{
throw new NotImplementedException();
}
