public void UpdateUser(DTO.Users user)
{
Provider p = new Provider();
try
{
p.Connect();
string strSql = "UpdateUsers";
p.ExecuteNonQuery(CommandType.StoredProcedure, strSql,
new SqlParameter {
ParameterName = "@UserID", Value = user.Username1
},
new SqlParameter {
ParameterName = "@Pass", Value = user.Password1
},
new SqlParameter {
ParameterName = "@Email", Value = user.Email1
}
);
}
catch (SqlException ex)
{
throw ex;
}
finally
{
p.Disconnect();
}
}
public int Get(string UserName, string Password)
{
BUS.Users bus_user = new BUS.Users(appSettings);
DTO.Users _user = bus_user.loginUser(UserName, Password);
if (_user != null)
{
var claims = new List <Claim>
{
new Claim("UserName", _user.UserName),
new Claim("UserID", _user.ID.ToString())
};
var userIdentity = new ClaimsIdentity(claims, "login");
ClaimsPrincipal principal = new ClaimsPrincipal(userIdentity);
HttpContext.SignInAsync(principal);
return(1);
}
else
{
return(0);
}
}
public Users UpdateUsers(Users users)
{
try
{
DTO.Users user = GetUnitOfWork().Edit(users);
_unitOfWork.Save();
return(user);
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public DTO.Users loginUser(string userName, string password)
{
DTO.Users _user;
try
{
_user = (from a in _appSettings.dbContext.Users
where a.IsDeleted == false && a.UserName == userName && a.Password == password
select new DTO.Users()
{
ID = a.ID,
UserName = a.UserName
}).FirstOrDefault();
}
catch (Exception ex)
{
_logger.add(_appSettings.logConfigFile, "Error:" + ex.InnerException);
_user = new DTO.Users();
}
return(_user);
}
public void Users_AddUser(DTO.Users user)
{
DAO_Users.Instance.InsertUser(user);
}
//method fro add user
public Users AddUsers(Users users)
{
DTO.Users user = GetUnitOfWork().Add(users);
_unitOfWork.Save();
return(user);
}
