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 bool OutBox(BE_Mail bE_Mail)
{
int filasAfectadas = 0;
string strError_Mensaje = string.Empty;
bool boResultado = false;
Dictionary <string, object> parameters = new Dictionary <string, object>();
parameters.Add("_mailId", bE_Mail.idMail);
parameters.Add("_bodyMail", bE_Mail.bodyMail);
parameters.Add("_descriptionMail", bE_Mail.descriptionMail);
parameters.Add("_subjectMail", bE_Mail.subjectMail);
parameters.Add("_toMail", bE_Mail.toMail);
filasAfectadas = _database.ExecuteSP("sp_addCostCenterToInvoice", parameters);
boResultado = (filasAfectadas > 0);
return(boResultado);
}
public BE_Mail GetMail(int mailId)
{
BE_Mail bE_Mail = null;
List <BE_Mail> bE_Mails = new List <BE_Mail>();
Dictionary <string, object> parameters = new Dictionary <string, object>();
parameters.Add("_mailId", mailId);
var rows = _database.QuerySP("sp_getMail", parameters);
foreach (var row in rows)
{
bE_Mail = new BE_Mail();
bE_Mail.idMail = string.IsNullOrEmpty(row["IdMail"]) ? 0 : int.Parse(row["IdMail"]);;
bE_Mail.subjectMail = row["SubjectMail"];
bE_Mail.bodyMail = row["BodyMail"];
bE_Mail.descriptionMail = row["DescriptionMail"];
bE_Mail.toMail = row["ToMail"];
}
return(bE_Mail);
}
public BE_Mail getMailInfo(int idMail)
{
BE_Mail _BeMail = null;
Dictionary <string, object> parameters = new Dictionary <string, object>()
{
{ "_idMail", idMail }
};
var rows = _database.QuerySP("sps_getMailInfo", parameters);
foreach (var row in rows)
{
_BeMail = new BE_Mail();
_BeMail.idMail = string.IsNullOrEmpty(row["IdMail"]) ? 0 : int.Parse(row["IdMail"]);
_BeMail.subjectMail = row["SubjectMail"];
_BeMail.bodyMail = row["BodyMail"];
_BeMail.descriptionMail = row["DescriptionMail"];
_BeMail.toMail = row["ToMail"];
}
return(_BeMail);
}
public bool OutBox(BE_Mail bE_Mail)
{
_database = new MySQLDatabase(connectionString);
return(new DA_Mail(_database).OutBox(bE_Mail));
}
