public Boolean EmailNew(EmailBE emBe)
{
con.ConnectionString = conection.GetCon();
cmd.Connection = con;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "PERSONA.EmailNew";
try {
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("@id_persona", emBe.Id_persona);
cmd.Parameters.AddWithValue("@tipo_email", emBe.Tipo_email);
cmd.Parameters.AddWithValue("@direccion_email", emBe.Direccion_email);
con.Open();
cmd.ExecuteNonQuery();
success = true;
} catch (SqlException x) {
success = false;
throw new Exception(x.Message);
} finally {
if (con.State == ConnectionState.Open)
{
con.Close();
}
cmd.Parameters.Clear();
}
return(success);
}
private void NewEmail(int idCliente)
{
EmailBE embe = new EmailBE(
short.Parse(cboEmailTipo.SelectedValue.ToString()),
idCliente,
txtEmailEmail.Text.Trim()
);
EmailsBL emailBL = new EmailsBL();
emailBL.EmailNew(embe);
}
public dynamic Email_InsertUpdate(EmailBE objList)
{
EmailBE_SQL Sql = new EmailBE_SQL();
objList = Sql.Insert_Update(objList);
JsonResult jsonResult = Json(new { objList }, JsonRequestBehavior.AllowGet);
jsonResult.MaxJsonLength = int.MaxValue;
return(jsonResult);
}
private void btnGuardar_Click(object sender, EventArgs e)
{
int idPersona = int.Parse(cboPersonas.SelectedValue.ToString());
EmailBE emBE = new EmailBE(short.Parse(cboEmailTipo.SelectedValue.ToString()), idPersona, txtEmailEmail.Text.Trim());
EmailsBL emBL = new EmailsBL();
if (emBL.EmailNew(emBE) == true)
{
MessageBox.Show(this, "Se guardo correctamente", "Alerta", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show(this, "Ocurrió un error", "Alerta", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public EmailBE SelectEmail(int id_email)
{
DataSet dts = new DataSet();
EmailBE emBE = new EmailBE();
try {
con.ConnectionString = conection.GetCon();
cmd.Connection = con;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "PERSONA.SelectEmail";
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("@id_email", id_email);
con.Open();
SqlDataReader dtr = cmd.ExecuteReader();
if (dtr.HasRows == true)
{
dtr.Read();
emBE.Direccion_email = dtr["direccion_email"].ToString();
emBE.Id_email = int.Parse(dtr["id_email"].ToString());
emBE.Id_persona = int.Parse(dtr["id_persona"].ToString());
emBE.Tipo_email = short.Parse(dtr["tipo_email"].ToString());
}
else
{
throw new Exception("Error al buscar el email.");
}
dtr.Close();
} catch (Exception ex) {
throw new Exception("Error mostrando los emails: " + ex.Message);
} finally {
con.Close();
cmd.Parameters.Clear();
}
return(emBE);
}
public Boolean EmailNew(EmailBE emailbe)
{
return(email.EmailNew(emailbe));
}
public bool ModificarEmail(EmailBE emailBE)
{
return(email.ModificarEmail(emailBE));
}
public bool Delete(EmailBE obj)
{
return(new EmailDao().Delete(obj).Value);
}
public bool Update(EmailBE obj)
{
var result = new EmailDao().Update(obj);
return(result.Value);
}
public bool Insert(EmailBE obj)
{
var result = new EmailDao().Insert(obj);
return(Convert.ToBoolean(result));
}
public EmailBE SelectId(EmailBE obj)
{
return(new EmailDao().SelectId <EmailBE>(obj));
}
public List <EmailBE> Select(EmailBE obj)
{
return(new EmailDao().Select <EmailBE>(obj).ToList());
}
