public DataTable ListarContacto(BEContacto objEContacto)
{
DataTable dt = new DataTable();
MySqlConnection conn = new MySqlConnection("Server=127.0.0.1; Database=MECANICSWEB; Uid=Administrador; Pwd=admin");
MySqlCommand command = new MySqlCommand("`mecanicsweb`.`ListarContacto`", conn);
command.CommandType = CommandType.StoredProcedure;
command.Parameters.Add(ObjSqlParameter("N_ID", objEContacto.ID_Contacto, ParameterDirection.Input, System.Data.DbType.String));
conn.Open();
IDataReader dr = command.ExecuteReader();
dt.Load(dr);
conn.Close();
return dt;
}
public Object MantenimientoContacto(string ACCION, BEContacto objEContacto)
{
DataTable dt = new DataTable();
MySqlConnection conn = new MySqlConnection("Server=127.0.0.1; Database=MECANICSWEB; Uid=Administrador; Pwd=admin");
MySqlCommand command = new MySqlCommand("`mecanicsweb`.`MantenimientoContacto`", conn);
command.CommandType = CommandType.StoredProcedure;
command.Parameters.Add(ObjSqlParameter("N_ID", objEContacto.ID_Contacto, ParameterDirection.Input, System.Data.DbType.Int16));
command.Parameters.Add(ObjSqlParameter("N_IDCliente", objEContacto.ID_Cliente, ParameterDirection.Input, System.Data.DbType.String));
command.Parameters.Add(ObjSqlParameter("N_Nombre", objEContacto.Nombre, ParameterDirection.Input, System.Data.DbType.String));
command.Parameters.Add(ObjSqlParameter("N_TipoDocumento", objEContacto.TipoDocumento, ParameterDirection.Input, System.Data.DbType.Int16));
command.Parameters.Add(ObjSqlParameter("N_Documento", objEContacto.Documento, ParameterDirection.Input, System.Data.DbType.String));
command.Parameters.Add(ObjSqlParameter("N_Telefono", objEContacto.Telefono, ParameterDirection.Input, System.Data.DbType.String));
command.Parameters.Add(ObjSqlParameter("N_Celular", objEContacto.Celular, ParameterDirection.Input, System.Data.DbType.String));
command.Parameters.Add(ObjSqlParameter("ACCION", ACCION, ParameterDirection.Input, System.Data.DbType.String));
conn.Open();
try
{
if (ACCION.Equals("AGREGAR") || ACCION.Equals("MODIFICAR"))
{
command.ExecuteNonQuery();
return "Exito";
}
else
{
IDataReader dr = command.ExecuteReader();
dt.Load(dr);
return dt;
}
}
catch (Exception e)
{
throw new Exception("Error interno", e);
}
finally
{
conn.Close();
}
}
public void ActualizaContacto(BEContacto objEContacto)
{
MySqlConnection conn = new MySqlConnection("Server=127.0.0.1; Database=MECANICSWEB; Uid=Administrador; Pwd=admin");
MySqlCommand command = new MySqlCommand("`mecanicsweb`.`ActualizaContacto`", conn);
command.CommandType = CommandType.StoredProcedure;
command.Parameters.Add(ObjSqlParameter("N_ID", objEContacto.ID_Contacto, ParameterDirection.Input, System.Data.DbType.Int16));
command.Parameters.Add(ObjSqlParameter("N_IDCliente", objEContacto.ID_Cliente, ParameterDirection.Input, System.Data.DbType.String));
conn.Open();
command.ExecuteNonQuery();
conn.Close();
}
public void ActualizaContacto(BEContacto objEContacto)
{
objContacto.ActualizaContacto(objEContacto);
}
public DataTable ListarContacto(BEContacto objEContacto)
{
return objContacto.ListarContacto(objEContacto);
}
public Object MantenimientoContacto(string ACCION, BEContacto objEContacto)
{
return objContacto.MantenimientoContacto(ACCION, objEContacto);
}
public DataTable ConsultarContacto(BEContacto objEContacto)
{
return objContacto.ConsultarContacto(objEContacto);
}