public static ResponseParent GetParent(string identification)
{
ParentModel parentModel = new ParentModel();
using (MySqlConnection conn = ConecctionModel.conn)
{
conn.Open();
string SP = AppManagement.SP_GetParent;
MySqlCommand cmd = new MySqlCommand(SP, conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@identification", identification);
MySqlDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
parentModel.Email = rdr["email"].ToString();
parentModel.Name = rdr["name"].ToString();
parentModel.Identification = rdr["id_user"].ToString();
}
rdr.Close();
return(new ResponseParent {
IsSuccessful = true, ResponseMessage = AppManagement.MSG_GetParent_Success, Parent = parentModel
});
}
}
public static Response SendMail(string identification, string condition = "Roja")
{
try
{
string causes = string.Empty;
string strEmail = System.IO.File.ReadAllText(@"..\AITestBackend\Util\EmailTemplate.html");
var Patient = PatientModel.GetPatient(identification).Patient;
var Parent = ParentModel.GetParent(Patient.IdParent).Parent;
if (PatientCaseModel.GetAllPatientCases(Patient.Identification) != null &&
PatientCaseModel.GetAllPatientCases(Patient.Identification).IsSuccessful&&
PatientCaseModel.GetAllPatientCases(Patient.Identification).PatientCases.Count() > 0)
{
causes = PatientCaseModel.GetAllPatientCases(Patient.Identification).PatientCases[0].Procesed_Data;
}
//string path = Server.MapPath($"~/EmailTemplate/index.html");
strEmail = strEmail.Replace("[Nombre del Encargado]", Parent.Name).Replace("[NombreDelPaciente]", Patient.Name).Replace("[NumeroCedula]", Parent.Identification).Replace("[CondicionPaciente]", condition).Replace("[SintomasPaciente]", causes);
//AlternateView htmlView = AlternateView.CreateAlternateViewFromString(strEmail, System.Text.Encoding.UTF8, "text/html");
MailMessage correo = new MailMessage("*****@*****.**", "*****@*****.**");
// Agregar vista a email
//correo.AlternateViews.Add(htmlView);
correo.Subject = "Prueba Send Mail Programathon";
correo.IsBodyHtml = true;
correo.Priority = MailPriority.Normal;
correo.Body = strEmail;
// mail to
// Set SMTP Client;
SmtpClient smtp = new SmtpClient("smtp.gmail.com", 587)
{
UseDefaultCredentials = false,
EnableSsl = true,
Credentials = new System.Net.NetworkCredential(AppManagement.emailUser, AppManagement.emailPass),
DeliveryMethod = SmtpDeliveryMethod.Network,
};
smtp.Send(correo);
return(new Response {
IsSuccessful = true, ResponseMessage = "Enviado Exitosamente!"
});;
}
catch (Exception ex)
{
return(new Response {
IsSuccessful = false, ResponseMessage = ex.Message
});
}
}
public static Response RegisterParent(ParentModel parentModel)
{
using (MySqlConnection conn = ConecctionModel.conn)
{
conn.Open();
int idresult = 0;
string SP = AppManagement.SP_SaveParent;
MySqlCommand cmd = new MySqlCommand(SP, conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@id_user", parentModel.Identification);
cmd.Parameters.AddWithValue("@name", parentModel.Name);
cmd.Parameters.AddWithValue("@password", parentModel.Password);
cmd.Parameters.AddWithValue("@phone", parentModel.Mobile);
cmd.Parameters.AddWithValue("@parent", 1);
cmd.Parameters.AddWithValue("@email", parentModel.Email);
MySqlParameter NroIdInvoice = new MySqlParameter("@result", idresult);
NroIdInvoice.Direction = ParameterDirection.Output;
cmd.Parameters.Add(NroIdInvoice);
cmd.ExecuteNonQuery();
idresult = Int32.Parse(cmd.Parameters["@result"].Value.ToString());
cmd.ExecuteNonQuery();
if (idresult != 0)
{
if (idresult == 1)//email duplicado
{
return new Response {
IsSuccessful = false, ResponseMessage = AppManagement.MSG_SaveParent_FailureEmail
}
}
;
if (idresult == 2)//identificacion duplicada
{
return new Response {
IsSuccessful = false, ResponseMessage = AppManagement.MSG_SaveParent_FailureIdentification
}
}
;
else
{
return new Response {
IsSuccessful = false, ResponseMessage = AppManagement.MSG_SaveParent_FailureDefault
}
};
}
else
{
return new Response {
IsSuccessful = true, ResponseMessage = AppManagement.MSG_SaveParent_Success
}
};
}
}
public static Response Login(ParentModel parent)
{
try
{
using (MySqlConnection conn = ConecctionModel.conn)
{
conn.Open();
int idresult = 0;
string SP = AppManagement.SP_LoginUser;
MySqlCommand cmd = new MySqlCommand(SP, conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@identification", parent.Identification);
cmd.Parameters.AddWithValue("@password", parent.Password);
MySqlParameter NroIdInvoice = new MySqlParameter("@result", idresult);
NroIdInvoice.Direction = ParameterDirection.Output;
cmd.Parameters.Add(NroIdInvoice);
cmd.ExecuteNonQuery();
idresult = Int32.Parse(cmd.Parameters["@result"].Value.ToString());
if (idresult != 0)
{
if (idresult == 1)//usuario no existe
{
return new Response {
IsSuccessful = false, ResponseMessage = AppManagement.MSG_Login_Failure1
}
}
;
if (idresult == 2)//contraseña incorrecta
{
return new Response {
IsSuccessful = false, ResponseMessage = AppManagement.MSG_Login_Failure2
}
}
;
else
{
return new Response {
IsSuccessful = false, ResponseMessage = AppManagement.MSG_Login_FailureDefault
}
};
}
else
{
return new Response {
IsSuccessful = true, ResponseMessage = AppManagement.MSG_Login_Success
}
};
}
}
catch (Exception)
{
return(new Response {
IsSuccessful = false, ResponseMessage = AppManagement.MSG_Login_FailureDefault
});
}
}
