/// <summary>
/// This method is used to create a new user in the data base
/// </summary>
/// <param name="sMsjError"></param>
/// <param name="usersModel"></param>
public void CreateNewUser(ref string sMessage, ref UsersModel usersModel)
{
#region Local variables
string sNombreSP, sEncryptedEmailPass = usersModel.PasswordEmail, sEncryptedUserPass = "", sResultado = string.Empty;
DbModel dbModel = new DbModel();
DbViewModel dbViewModel = new DbViewModel();
EncryptionViewModel encryptionViewModel = new EncryptionViewModel();
#endregion
if (!IsEmailGood(usersModel.UserEmail))
{
sMessage = "Por favor verifique que el correo electrónico se haya ingresado en el formato correcto";
}
else if (usersModel.PasswordEmail == string.Empty || usersModel.PasswordEmail is null)
{
sMessage = "Por favor ingrese la contraseña del correo electrónico";
}
else if (usersModel.UserIdType == "Nacional" && !IsIdNumberGood(usersModel.UserIdNumber))
{
sMessage = "Por favor verifique que el número de identificación se haya ingresado en el formato correcto";
}
else if (usersModel.UserAddress == string.Empty || usersModel.UserAddress is null ||
usersModel.UserProvince == string.Empty || usersModel.UserProvince is null ||
usersModel.UserCanton == string.Empty || usersModel.UserCanton is null ||
usersModel.UserDistrict == string.Empty || usersModel.UserDistrict is null)
{
sMessage = "Por favor ingrese una dirección de residencia";
}
public void AuthenticateUser(ref AuthenticationModel authenticationModel, ref string sMsjError)
{
#region Local variables
string sNombreTabla, sNombreSP, sEncryptedPass = authenticationModel.UserPassword;
DbModel dbModel = new DbModel();
DbViewModel dbViewModel = new DbViewModel();
EncryptionViewModel encryptionViewModel = new EncryptionViewModel();
#endregion
encryptionViewModel.EncryptString(ref sEncryptedPass);
dbViewModel.GenerarDataTableParametros(ref dbModel);
DataRow dr1 = dbModel.dtParametros.NewRow();
dr1["Nombre"] = "@email";
dr1["TipoDato"] = "4";
dr1["Valor"] = authenticationModel.UserName;
DataRow dr2 = dbModel.dtParametros.NewRow();
dr2["Nombre"] = "@s_contrasena";
dr2["TipoDato"] = "4";
dr2["Valor"] = sEncryptedPass;
dbModel.dtParametros.Rows.Add(dr1);
dbModel.dtParametros.Rows.Add(dr2);
sNombreTabla = (App.Current as App).TblAuthentication.ToString();
sNombreSP = (App.Current as App).SpAuthentication.ToString();
dbViewModel.ExecuteFill(sNombreTabla, sNombreSP, ref dbModel);
if (dbModel.sMsjError != string.Empty)
{
sMsjError = dbModel.sMsjError;
authenticationModel.UserProfile = String.Empty;
}
else
{
sMsjError = string.Empty;
if (dbModel.DS.Tables[sNombreTabla].Rows.Count > 0)
{
authenticationModel.UserProfile = dbModel.DS.Tables[sNombreTabla].Rows[0][0].ToString();
if (authenticationModel.UserProfile == "Invalid Credentials")
{
authenticationModel.IsErrorMessageVisible = true;
authenticationModel.UserProfile = "";
}
}
else
{
authenticationModel.UserProfile = string.Empty;
authenticationModel.IsErrorMessageVisible = true;
}
}
}