public void SaveOrUpdate(Deudor unDeudor)
{
string connectionString = System.Configuration.ConfigurationManager.ConnectionStrings["RecuperosYMandatos"].ConnectionString;
using (SqlConnection con = new SqlConnection(connectionString))
{
SqlCommand cmd = new SqlCommand();
cmd.Connection = con;
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Id", unDeudor.ID);
cmd.Parameters.AddWithValue("@Apellido", unDeudor.Apellido);
cmd.Parameters.AddWithValue("@Nombre", unDeudor.Nombre);
cmd.Parameters.AddWithValue("@Telefono_celular", unDeudor.Telefono_celular);
cmd.Parameters.AddWithValue("@Correo_electronico", unDeudor.Correo_electronico);
cmd.CommandText = "[Deudores_Grabar]";
con.Open();
cmd.ExecuteNonQuery();
}
}
public Deudor GetDeudorByID(long ID)
{
string connectionString = System.Configuration.ConfigurationManager.ConnectionStrings["RecuperosYMandatos"].ConnectionString;
Deudor unDeudor = new Deudor();
using (SqlConnection con = new SqlConnection(connectionString))
{
SqlCommand cmd = new SqlCommand();
cmd.Connection = con;
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Id", ID);
cmd.CommandText = "[Deudores_Buscar]";
con.Open();
SqlDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
unDeudor.ID = Convert.ToInt64(rdr["ID"]);
unDeudor.IdEmpresa = Convert.ToInt64(rdr["IdEmpresa"]);
unDeudor.Apellido = string.IsNullOrEmpty(rdr["Apellido"].ToString()) ? "" : rdr["Apellido"].ToString();
unDeudor.Nombre = string.IsNullOrEmpty(rdr["Nombre"].ToString()) ? "" : rdr["Nombre"].ToString();
}
return(unDeudor);
}
}