public OutValidateUser ValidateUser(Login usr)
{
InValidateUser userData = new InValidateUser();
OutValidateUser uservalidated = new OutValidateUser();
try
{
AuthenticationDAO dao = new AuthenticationDAO();
userData.password = usr.password;
userData.userID = usr.userName;
userData.sucursal = usr.sucursal;
uservalidated = dao.ValidateUser(userData);
if (uservalidated.changePassword == 1)
{
uservalidated.url = "ChangePwd";
}
}
catch (Exception ex)
{
//escribir en el log
System.Diagnostics.Debug.WriteLine("Error --> ", ex);
LogHelper.WriteLog("Models", "ManagerLogin", "ValidateUser", ex, userData.userID);
}
return(uservalidated);
}
public OutValidateUser ValidateUser(string asesor, ref InValidateUser user)
{
string connectionString = DataBaseHelper.GetConnectionString("DLG");
OutValidateUser response = new OutValidateUser();
var ora = new OracleServer(connectionString);
try
{
var pi_Company = new OracleParameter("fa_empresa", OracleDbType.Double, user.company, ParameterDirection.Input);
var pi_asesor = new OracleParameter("fa_asesor", OracleDbType.Varchar2, asesor, ParameterDirection.Input);
var po_User = new OracleParameter("fa_usuario", OracleDbType.Varchar2, user.userID, ParameterDirection.Output)
{
Size = 100
};
var po_Password = new OracleParameter("fa_clave", OracleDbType.Varchar2, user.password, ParameterDirection.Output)
{
Size = 100
};
var po_ErrorCode = new OracleParameter("fa_Error", OracleDbType.Double, ParameterDirection.Output);
var po_ErrorMessage = new OracleParameter("fa_Descripcion_Error", OracleDbType.Varchar2, ParameterDirection.Output);
var po_ChangePassword = new OracleParameter("fa_ind_obliga_cambio", OracleDbType.Double, ParameterDirection.Output);
var po_UserName = new OracleParameter("fa_nombre_usuario", OracleDbType.Varchar2, ParameterDirection.Output)
{
Size = 100
};
po_ErrorMessage.Size = 100;
ora.AddParameter(pi_Company);
ora.AddParameter(pi_asesor);
ora.AddParameter(po_User);
ora.AddParameter(po_Password);
ora.AddParameter(po_ErrorCode);
ora.AddParameter(po_ErrorMessage);
ora.AddParameter(po_ChangePassword);
ora.AddParameter(po_UserName);
ora.ExecuteProcedureNonQuery("dlg_portal_val_ingreso_asesor");
response.msg.errorCode = ora.GetParameter("fa_Error").ToString();
response.msg.errorMessage = ora.GetParameter("fa_Descripcion_Error").ToString();
response.userName = ora.GetParameter("fa_nombre_usuario").ToString();
response.userName = CultureInfo.CurrentCulture.TextInfo.ToTitleCase(response.userName.ToLower());
response.changePassword = int.Parse(ora.GetParameter("fa_ind_obliga_cambio").ToString());
response.userID = ora.GetParameter("fa_usuario").ToString();
response.password = ora.GetParameter("fa_clave").ToString();
}
catch (Exception ex)
{
throw new Exception("AuthenticationDAO.ValidateUser", ex);
}
finally
{
ora.Dispose();
}
return(response);
}
public OutValidateUser ValidateUser(InValidateUser user)
{
string connectionString = DataBaseHelper.GetConnectionString("DLG");
OutValidateUser response = new OutValidateUser();
var ora = new OracleServer(connectionString);
try
{
System.Diagnostics.Debug.WriteLine("empresa --> ", user.company);
var pi_Company = new OracleParameter("fa_empresa", OracleDbType.Double, user.company, ParameterDirection.Input);
var pi_User = new OracleParameter("fa_usuario", OracleDbType.Varchar2, user.userID, ParameterDirection.Input);
var pi_Password = new OracleParameter("fa_clave", OracleDbType.Varchar2, user.password, ParameterDirection.Input);
var po_ErrorCode = new OracleParameter("fa_Error", OracleDbType.Double, ParameterDirection.Output);
var po_ErrorMessage = new OracleParameter("fa_Descripcion_Error", OracleDbType.Varchar2, ParameterDirection.Output);
var po_ChangePassword = new OracleParameter("fa_ind_obliga_cambio", OracleDbType.Double, ParameterDirection.Output);
var po_UserName = new OracleParameter("fa_nombre_usuario", OracleDbType.Varchar2, ParameterDirection.Output);
var po_sucursal = new OracleParameter("fa_sucursal", OracleDbType.Double, ParameterDirection.Output);
var po_asesor = new OracleParameter("fa_codigo_asesor", OracleDbType.Double, ParameterDirection.Output);
po_UserName.Size = 300;
po_ErrorMessage.Size = 300;
ora.AddParameter(pi_Company);
ora.AddParameter(pi_User);
ora.AddParameter(pi_Password);
ora.AddParameter(po_ErrorCode);
ora.AddParameter(po_ErrorMessage);
ora.AddParameter(po_ChangePassword);
ora.AddParameter(po_UserName);
ora.AddParameter(po_sucursal);
ora.AddParameter(po_asesor);
ora.ExecuteProcedureNonQuery("BBS_PORTAL_F_VALIDA_INGRESO");
response.msg.errorCode = ora.GetParameter("fa_Error").ToString();
response.msg.errorMessage = ora.GetParameter("fa_Descripcion_Error").ToString();
response.userName = ora.GetParameter("fa_nombre_usuario").ToString();
response.changePassword = int.Parse(ora.GetParameter("fa_ind_obliga_cambio").ToString());
response.sucursal = double.Parse(ora.GetParameter("fa_sucursal").ToString());
response.asesor = double.Parse(ora.GetParameter("fa_codigo_asesor").ToString());
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine(ex);
throw new Exception("AuthenticationDAO.ValidateUser", ex);
}
finally {
ora.Dispose();
}
return(response);
}
// GET: ChangePwd
public ActionResult Index(OutValidateUser usr)
{
if (usr.changePassword == 1)
{
var ViewModel = new UserPwdChgViewModel
{
name = usr.userName,
pwd1 = string.Empty,
pwd2 = string.Empty,
userID = usr.userID
};
return(View(ViewModel));
}
else
{
return(RedirectToAction("MainMenu", "Home"));
}
}
public OutValidateUser ValidateUser(string asesor, ref Login usr)
{
InValidateUser userData = new InValidateUser();
OutValidateUser uservalidated = new OutValidateUser();
try
{
AuthenticationDAO dao = new AuthenticationDAO();
uservalidated = dao.ValidateUser(asesor, ref userData);
usr.password = uservalidated.password;
usr.userName = uservalidated.userID;
if (uservalidated.changePassword == 1)
{
uservalidated.url = "ChangePwd";
}
}
catch (Exception ex)
{
//escribir en el log
LogHelper.WriteLog("Models", "ManagerLogin", "ValidateUser", ex, userData.userID);
}
return(uservalidated);
}