public BE_User SetNewPassword(VE_User _VeUser)
{
_database = new MySQLDatabase(connectionString);
int idMail = 2;
BE_Mail _BeMail = GetMailInfo(idMail);
_VeUser.passwordHash = BE.Security.Encriptar(_VeUser.passwordHash);
BE_User _BeUser = new DA_User(_database).setNewPassword(_VeUser);
string body = _BeMail.bodyMail;
body = body.Replace("@FirstName", _VeUser.firstName);
body = body.Replace("@LastName", _VeUser.lastName);
if (_BeUser != null)
{
BL_Mail _BlMail = new BL_Mail();
_BlMail.SendEmail("*****@*****.**", _BeUser.userName, _BeMail.subjectMail, body);
return(_BeUser);
}
else
{
throw new ApplicationException("Ususario incorrecto o inexistente");
}
}
public BE_Json DeleteUserGeneral([FromBody] VE_User vE_User)
{
BE_Json objJson = null;
var objListaAux = string.Empty;
try
{
BL_Usuario _blUsuario = new BL_Usuario();
_blUsuario.connectionString = AppConfig.DbConnection;
objListaAux = JsonConvert.SerializeObject(_blUsuario.DeleteUserGeneral(vE_User));
objJson = new BE_Json();
objJson.data = objListaAux;
objJson.status = CManager.RESULTADO_WCF.OK;
}
catch (Exception ex)
{
objJson = new BE_Json();
objJson.data = "Hubo en error en servidor:" + ex.Message + ";" + ex.StackTrace + ";" + ex.ToString();
objJson.status = CManager.RESULTADO_WCF.ERROR;
objJson.status = CManager.RESULTADO_WCF.ERROR;
}
finally
{
objListaAux = null;
}
return(objJson);
}
public VE_User CreateUserGeneral(VE_User veUser)
{
string strError_Mensaje = string.Empty;
object UserId = new object();
Dictionary <string, object> parameters = new Dictionary <string, object>();
parameters.Add("_createdBy", veUser.userAudit);
parameters.Add("_email", veUser.email);
parameters.Add("_emailConfirmed", false);
parameters.Add("_firstName", veUser.firstName);
parameters.Add("_lastName", veUser.lastName);
parameters.Add("_normalizedEmail", veUser.email.ToUpper());
parameters.Add("_normalizedUserName", veUser.userName.ToUpper());
parameters.Add("_passwordHash", BE.Security.Encriptar(veUser.passwordHash));
parameters.Add("_phoneNumber", veUser.phoneNumber);
parameters.Add("_phoneNumberConfirmed", false);
parameters.Add("_twoFactorEnabled", false);
parameters.Add("_userName", veUser.userName);
UserId = _database.ExecuteSPGetId("sp_createUserGeneral", parameters);
veUser.id = UserId.ToString();
return(veUser);
}
public VE_User CreateUser(VE_User user)
{
Guid g;
// Create and display the value of two GUIDs.
g = Guid.NewGuid();
user.id = Guid.NewGuid().ToString();
_database = new MySQLDatabase(connectionString);
return(new DA_User(_database).createUser(user));
}
public VE_User CreateUserGeneral(VE_User vE_User, List <string> CompanyCodeList, List <string> RoleIdList, bool authorize)
{
_database = new MySQLDatabase(connectionString);
var user = new DA_User(_database).CreateUserGeneral(vE_User);
foreach (var ri in RoleIdList)
{
CreateUserRole(user.id, ri);
}
foreach (var cc in CompanyCodeList)
{
CreateUserCompany(user.id, cc, authorize);
}
return(user);
}
public VE_User setPasswordRecovery(VE_User _VeUser)
{
int filasAfectadas = 0;
string strError_Mensaje = string.Empty;
bool boResultado = false;
Dictionary <string, object> parameters = new Dictionary <string, object>();
parameters.Add("_userName", _VeUser.userName);
parameters.Add("_userAudit", _VeUser.userAudit);
filasAfectadas = _database.ExecuteSP("spu_updateLockoutEnabled", parameters);
boResultado = (filasAfectadas > 0);
if (boResultado)
{
return(_VeUser);
}
return(null);
}
public int deleteUserGeneral(VE_User vE_User)
{
int filasAfectadas = 0;
string strError_Mensaje = string.Empty;
bool boResultado = false;
Dictionary <string, object> parameters = new Dictionary <string, object>();
parameters.Add("_id", vE_User.id);
parameters.Add("_updatedby", vE_User.userAudit);
filasAfectadas = _database.ExecuteSP("sp_deleteUserGeneral", parameters);
boResultado = (filasAfectadas > 0);
if (boResultado)
{
return(filasAfectadas);
}
return(0);
}
/// <summary>
/// Return the user's password hash
/// </summary>
/// <param name="userId">The user's id</param>
/// <returns></returns>
public VE_User loginValidation(string userName, string passwordHash)
{
VE_User _usuario = null;
Dictionary <string, object> parameters = new Dictionary <string, object>();
parameters.Add("_userName", userName);
parameters.Add("_passwordHash", passwordHash);
var rows = _database.QuerySP("sp_validarLoginUsuarios", parameters);
foreach (var row in rows)
{
_usuario = new VE_User();
_usuario.id = row["Id"];
_usuario.accessFailedCount = string.IsNullOrEmpty(row["AccessFailedCount"]) ? 0 : int.Parse(row["AccessFailedCount"]);
_usuario.concurrencyStamp = row["ConcurrencyStamp"];
_usuario.configuration = row["Configuration"];
_usuario.email = row["Email"];
_usuario.emailConfirmed = string.IsNullOrEmpty(row["EmailConfirmed"]) ? false : row["EmailConfirmed"].Equals("1") ? true : false;
_usuario.firstName = row["FirstName"];
_usuario.isEnabled = string.IsNullOrEmpty(row["IsEnabled"]) ? false : row["IsEnabled"].Equals("1") ? true : false;
_usuario.lastName = row["LastName"];
_usuario.lockoutEnabled = string.IsNullOrEmpty(row["LockoutEnabled"]) ? false : row["LockoutEnabled"].Equals("1") ? true : false;
_usuario.lockoutEnd = string.IsNullOrEmpty(row["LockoutEnd"]) ? DateTime.MinValue : DateTime.Parse(row["LockoutEnd"]);
_usuario.lockoutEndFormat = _usuario.lockoutEnd.ToShortDateString();
_usuario.normalizedEmail = row["NormalizedEmail"];
_usuario.normalizedUserName = row["NormalizedUserName"];
_usuario.passwordHash = row["PasswordHash"];
_usuario.phoneNumber = row["PhoneNumber"];
_usuario.phoneNumberConfirmed = string.IsNullOrEmpty(row["PhoneNumberConfirmed"]) ? false : row["PhoneNumberConfirmed"].Equals("1") ? true : false;
_usuario.securityStamp = row["SecurityStamp"];
_usuario.twoFactorEnabled = string.IsNullOrEmpty(row["TwoFactorEnabled"]) ? false : row["TwoFactorEnabled"].Equals("1") ? true : false;
_usuario.userName = row["UserName"];
_usuario.companyName = row["CompanyName"];
_usuario.companyDocumento = row["CompanyRUC"];
_usuario.companyCode = row["CompanyCode"];
_usuario.roleId = row["RoleId"];
_usuario.rolaName = row["RoleName"];
_usuario.quantityAuth = row["quantityAuth"];
}
return(_usuario);
}
public VE_User deleteUser(VE_User user)
{
int filasAfectadas = 0;
string strError_Mensaje = string.Empty;
bool boResultado = false;
Dictionary <string, object> parameters = new Dictionary <string, object>();
parameters.Add("_id", user.id);
parameters.Add("_username", user.userName);
parameters.Add("_userAudit", user.userAudit);
filasAfectadas = _database.ExecuteSP("spd_deleteAspnetuser", parameters);
boResultado = (filasAfectadas > 0);
if (boResultado)
{
return(user);
}
return(null);
}
public VE_User createUser(VE_User _VeUser)
{
int filasAfectadas = 0;
string strError_Mensaje = string.Empty;
bool boResultado = false;
Dictionary <string, object> parameters = new Dictionary <string, object>();
parameters.Add("_id", _VeUser.id);
parameters.Add("_accessFailedCount", _VeUser.accessFailedCount);
parameters.Add("_concurrencyStamp", _VeUser.concurrencyStamp);
parameters.Add("_configuration", _VeUser.configuration);
parameters.Add("_email", _VeUser.email);
parameters.Add("_emailConfirmed", _VeUser.emailConfirmed);
parameters.Add("_firstName", _VeUser.firstName);
parameters.Add("_isEnabled", _VeUser.isEnabled);
parameters.Add("_lastName", _VeUser.lastName);
parameters.Add("_lockoutEnabled", _VeUser.lockoutEnabled);
parameters.Add("_lockoutEnd", _VeUser.lockoutEnd);
parameters.Add("_normalizedEmail", _VeUser.normalizedEmail);
parameters.Add("_normalizedUserName", _VeUser.normalizedUserName);
parameters.Add("_passwordHash", _VeUser.passwordHash);
parameters.Add("_phoneNumber", _VeUser.phoneNumber);
parameters.Add("_phoneNumberConfirmed", _VeUser.phoneNumberConfirmed);
parameters.Add("_securityStamp", _VeUser.securityStamp);
parameters.Add("_twoFactorEnabled", _VeUser.twoFactorEnabled);
parameters.Add("_userName", _VeUser.userName);
parameters.Add("_userAudit", _VeUser.userAudit);
filasAfectadas = _database.ExecuteSP("spi_insertAspnetuser", parameters);
boResultado = (filasAfectadas > 0);
if (boResultado)
{
return(_VeUser);
}
return(null);
}
public VE_User updateUserGeneral(VE_User veUser)
{
int filasAfectadas = 0;
string strError_Mensaje = string.Empty;
bool boResultado = false;
Dictionary <string, object> parameters = new Dictionary <string, object>();
parameters.Add("_id", veUser.id);
parameters.Add("_accessFailedCount", veUser.accessFailedCount);
parameters.Add("_concurrencyStamp", veUser.concurrencyStamp);
parameters.Add("_configuration", veUser.configuration);
parameters.Add("_email", veUser.email);
parameters.Add("_emailConfirmed", veUser.emailConfirmed);
parameters.Add("_firstName", veUser.firstName);
parameters.Add("_isEnabled", veUser.isEnabled);
parameters.Add("_lastName", veUser.lastName);
parameters.Add("_lockoutEnabled", veUser.lockoutEnabled);
parameters.Add("_lockoutEnd", veUser.lockoutEnd);
parameters.Add("_normalizedEmail", veUser.normalizedEmail);
parameters.Add("_normalizedUserName", veUser.normalizedUserName);
parameters.Add("_passwordHash", string.IsNullOrEmpty(veUser.passwordHash)?DBNull.Value:(object)BE.Security.Encriptar(veUser.passwordHash));
parameters.Add("_phoneNumber", veUser.phoneNumber);
parameters.Add("_phoneNumberConfirmed", veUser.phoneNumberConfirmed);
parameters.Add("_securityStamp", veUser.securityStamp);
parameters.Add("_twoFactorEnabled", veUser.twoFactorEnabled);
parameters.Add("_userName", veUser.userName);
parameters.Add("_updatedby", veUser.userAudit);
filasAfectadas = _database.ExecuteSP("sp_updateUserGeneral", parameters);
boResultado = (filasAfectadas > 0);
if (boResultado)
{
return(veUser);
}
return(null);
}
public VE_User getUserInfo(string userName)
{
VE_User _veUser = null;
Dictionary <string, object> parameters = new Dictionary <string, object>()
{
{ "_userName", userName }
};
var rows = _database.QuerySP("sps_obtenerDataUsuario", parameters);
foreach (var row in rows)
{
_veUser = new VE_User();
_veUser.firstName = row["FirstName"];
_veUser.lastName = row["LastName"];
_veUser.email = row["Email"];
_veUser.id = row["Id"];
_veUser.companyName = row["CompanyName"];
_veUser.companyDocumento = row["CompanyRUC"];
_veUser.companyCode = row["CompanyCode"];
}
return(_veUser);
}
public List <VE_User> getUser()
{
VE_User _VeUser = null;
List <VE_User> _lstUser = new List <VE_User>();
Dictionary <string, object> parameters = new Dictionary <string, object>();
var rows = _database.QuerySP("sps_getAspnetuser", parameters);
foreach (var row in rows)
{
_VeUser = new VE_User();
_VeUser.id = row["Id"];
_VeUser.accessFailedCount = string.IsNullOrEmpty(row["AccessFailedCount"]) ? 0 : int.Parse(row["AccessFailedCount"]);
_VeUser.concurrencyStamp = row["ConcurrencyStamp"];
_VeUser.configuration = row["Configuration"];
_VeUser.email = row["Email"];
_VeUser.emailConfirmed = string.IsNullOrEmpty(row["EmailConfirmed"]) ? false : row["EmailConfirmed"].Equals("1") ? true : false;
_VeUser.firstName = row["FirstName"];
_VeUser.isEnabled = string.IsNullOrEmpty(row["IsEnabled"]) ? false : row["IsEnabled"].Equals("1") ? true : false;
_VeUser.lastName = row["LastName"];
_VeUser.lockoutEnabled = string.IsNullOrEmpty(row["LockoutEnabled"]) ? false : row["LockoutEnabled"].Equals("1") ? true : false;
_VeUser.lockoutEnd = string.IsNullOrEmpty(row["LockoutEnd"]) ? DateTime.MinValue : DateTime.Parse(row["LockoutEnd"]);
_VeUser.lockoutEndFormat = _VeUser.lockoutEnd.ToShortDateString();
_VeUser.normalizedEmail = row["NormalizedEmail"];
_VeUser.normalizedUserName = row["NormalizedUserName"];
_VeUser.passwordHash = row["PasswordHash"];
_VeUser.phoneNumber = row["PhoneNumber"];
_VeUser.phoneNumberConfirmed = string.IsNullOrEmpty(row["PhoneNumberConfirmed"]) ? false : row["PhoneNumberConfirmed"].Equals("1") ? true : false;
_VeUser.securityStamp = row["SecurityStamp"];
_VeUser.twoFactorEnabled = string.IsNullOrEmpty(row["TwoFactorEnabled"]) ? false : row["TwoFactorEnabled"].Equals("1") ? true : false;
_VeUser.userName = row["UserName"];
_lstUser.Add(_VeUser);
}
return(_lstUser);
}
public int DeleteUserGeneral(VE_User vE_User)
{
_database = new MySQLDatabase(connectionString);
return(new DA_User(_database).deleteUserGeneral(vE_User));
}
public VE_User DeleteUser(VE_User _VeUser)
{
_database = new MySQLDatabase(connectionString);
return(new DA_User(_database).deleteUser(_VeUser));
}
public VE_User createUser(Guid guid, VE_User user)
{
throw new NotImplementedException();
}
