public static List <entTipoDoc> listarTiposDocs()
{
SqlCommand cmd = null;
SqlDataReader dr = null;
List <entTipoDoc> listTdocs = null;
try
{
daoConexion cn = new daoConexion();
SqlConnection cnx = cn.conectar();
cmd = new SqlCommand("SP_CARGAR_TDOCS", cnx);
cmd.CommandType = CommandType.StoredProcedure;
cnx.Open();
dr = cmd.ExecuteReader();
listTdocs = new List <entTipoDoc>();
while (dr.Read())
{
entTipoDoc iden = new entTipoDoc();
iden.id = Convert.ToInt32(dr["id"].ToString());
iden.descripcion = dr["descripcion"].ToString();
listTdocs.Add(iden);
}
}
catch (Exception ex)
{
listTdocs = null;
}
finally
{
cmd.Connection.Close();
}
return(listTdocs);
}
public static int AgregarProductos(entProductos obj)
{
int indicador = 0;
SqlCommand cmd = null;
try
{
daoConexion cn = new daoConexion();
SqlConnection cnx = cn.conectar();
cmd = new SqlCommand("SP_TRANSAC_PRODUCTOS", cnx);
cmd.Parameters.AddWithValue("@Operacion", obj.Operacion);
cmd.Parameters.AddWithValue("@id", obj.id);
cmd.Parameters.AddWithValue("@nombre", obj.nombre);
cmd.Parameters.AddWithValue("@descripcion", obj.descripcion);
cmd.Parameters.AddWithValue("@valor", obj.valor);
cmd.CommandType = CommandType.StoredProcedure;
cnx.Open();
cmd.ExecuteNonQuery();
indicador = 1;
}
catch (Exception ex)
{
throw ex;
//indicador = 0;
}
finally
{
cmd.Connection.Close();
}
return(indicador);
}
public static int AgregarClientes(entClientes obj)
{
int indicador = 0;
SqlCommand cmd = null;
try
{
daoConexion cn = new daoConexion();
SqlConnection cnx = cn.conectar();
cmd = new SqlCommand("SP_TRANSAC_CLIENTES", cnx);
cmd.Parameters.AddWithValue("@Operacion", obj.Operacion);
cmd.Parameters.AddWithValue("@id", obj.id);
cmd.Parameters.AddWithValue("@nombre", obj.nombre);
cmd.Parameters.AddWithValue("@tipo_doc", obj.tipo_doc);
cmd.Parameters.AddWithValue("@identificacion", obj.identificacion);
cmd.Parameters.AddWithValue("@telefono", obj.telefono);
cmd.Parameters.AddWithValue("@direccion", obj.direccion);
cmd.CommandType = CommandType.StoredProcedure;
cnx.Open();
cmd.ExecuteNonQuery();
indicador = 1;
}
catch (Exception ex)
{
throw ex;
//indicador = 0;
}
finally
{
cmd.Connection.Close();
}
return(indicador);
}
//paso los parametros para la consulta del usuario y permitir su login
public static entUsuario Login(String usuario, String contrasena)
{
entUsuario obj = null;
SqlCommand cmd = null;
SqlDataReader dr = null;
try
{
daoConexion cn = new daoConexion();
SqlConnection cnx = cn.conectar();
cmd = new SqlCommand("SP_VALIDAR_USUARIO", cnx);
cmd.Parameters.AddWithValue("@usuario", usuario);
cmd.Parameters.AddWithValue("@clave", contrasena);
cmd.CommandType = CommandType.StoredProcedure;
cnx.Open();
dr = cmd.ExecuteReader();
obj = new entUsuario();
dr.Read();
obj.id = Convert.ToInt32(dr["id"].ToString());
obj.usuario = dr["usuario"].ToString();
obj.clave = dr["clave"].ToString();
obj.nombre = dr["nombre"].ToString();
}
catch (Exception ex)
{
//throw ex;
obj = null;
}
finally
{
cmd.Connection.Close();
}
return(obj);
}
public static int AgregarCompanias(entCompanias obj)
{
int indicador = 0;
SqlCommand cmd = null;
try
{
daoConexion cn = new daoConexion();
SqlConnection cnx = cn.conectar();
cmd = new SqlCommand("SP_TRANSAC_COMPANIAS", cnx);
cmd.Parameters.AddWithValue("@Operacion", obj.Operacion);
cmd.Parameters.AddWithValue("@id", obj.id);
cmd.Parameters.AddWithValue("@nombre", obj.nombre);
cmd.Parameters.AddWithValue("@nit", obj.nit);
cmd.Parameters.AddWithValue("@dig_ver", obj.dig_ver);
cmd.Parameters.AddWithValue("@telefono1", obj.telefono1);
cmd.Parameters.AddWithValue("@telefono2", obj.telefono2);
cmd.Parameters.AddWithValue("@direccion", obj.direccion);
cmd.CommandType = CommandType.StoredProcedure;
cnx.Open();
cmd.ExecuteNonQuery();
indicador = 1;
}
catch (Exception ex)
{
throw ex;
//indicador = 0;
}
finally
{
cmd.Connection.Close();
}
return(indicador);
}
public static int AgregarVentasClientes(entVentas obj)
{
int indicador = 0;
SqlCommand cmd = null;
try
{
daoConexion cn = new daoConexion();
SqlConnection cnx = cn.conectar();
cmd = new SqlCommand("SP_TRANSAC_VENTAS_CLIENTES", cnx);
cmd.Parameters.AddWithValue("@Operacion", obj.Operacion);
cmd.Parameters.AddWithValue("@id", obj.id);
cmd.Parameters.AddWithValue("@id_compania", obj.id_compania);
cmd.Parameters.AddWithValue("@id_producto", obj.id_producto);
cmd.CommandType = CommandType.StoredProcedure;
cnx.Open();
cmd.ExecuteNonQuery();
indicador = 1;
}
catch (Exception ex)
{
throw ex;
//indicador = 0;
}
finally
{
cmd.Connection.Close();
}
return(indicador);
}
public static entCompanias ListarCompaniasEditar(int operacion, int idcom)
{
SqlCommand cmd = null;
SqlDataReader dr = null;
entCompanias obj = null;
try
{
daoConexion cn = new daoConexion();
SqlConnection cnx = cn.conectar();
cmd = new SqlCommand("SP_TRANSAC_COMPANIAS", cnx);
cmd.Parameters.AddWithValue("@Operacion", operacion);
cmd.Parameters.AddWithValue("@id", idcom);
cmd.Parameters.AddWithValue("@nombre", "");
cmd.Parameters.AddWithValue("@nit", "");
cmd.Parameters.AddWithValue("@dig_ver", "");
cmd.Parameters.AddWithValue("@telefono1", "");
cmd.Parameters.AddWithValue("@telefono2", "");
cmd.Parameters.AddWithValue("@direccion", "");
cmd.CommandType = CommandType.StoredProcedure;
cnx.Open();
dr = cmd.ExecuteReader();
obj = new entCompanias();
dr.Read();
entCompanias c = new entCompanias();
obj.id = Convert.ToInt32(dr["id"].ToString());
obj.nombre = dr["nombre"].ToString();
obj.nit = dr["nit"].ToString();
obj.dig_ver = dr["dve"].ToString();
obj.telefono1 = dr["telefono1"].ToString();
obj.telefono2 = dr["telefono2"].ToString();
obj.direccion = dr["direccion"].ToString();
obj.estado = dr["estado"].ToString();
}
catch (Exception e)
{
throw e;
//listacom = null;
}
finally
{
cmd.Connection.Close();
}
return(obj);
}
public static entClientes ListarClientesEditar(int operacion, int idcli)
{
SqlCommand cmd = null;
SqlDataReader dr = null;
entClientes obj = null;
try
{
daoConexion cn = new daoConexion();
SqlConnection cnx = cn.conectar();
cmd = new SqlCommand("SP_TRANSAC_CLIENTES", cnx);
cmd.Parameters.AddWithValue("@Operacion", operacion);
cmd.Parameters.AddWithValue("@id", idcli);
cmd.Parameters.AddWithValue("@nombre", "");
cmd.Parameters.AddWithValue("@tipo_doc", "");
cmd.Parameters.AddWithValue("@identificacion", "");
cmd.Parameters.AddWithValue("@telefono", "");
cmd.Parameters.AddWithValue("@direccion", "");
cmd.CommandType = CommandType.StoredProcedure;
cnx.Open();
dr = cmd.ExecuteReader();
obj = new entClientes();
dr.Read();
entClientes c = new entClientes();
obj.id = Convert.ToInt32(dr["id"].ToString());
obj.nombre = dr["nombre"].ToString();
obj.idtdoc = Convert.ToInt32(dr["idtdoc"].ToString());
obj.tdocumento = dr["tdocumento"].ToString();
obj.identificacion = dr["identi"].ToString();
obj.telefono = dr["telefono"].ToString();
obj.direccion = dr["direccion"].ToString();
}
catch (Exception e)
{
throw e;
//listacom = null;
}
finally
{
cmd.Connection.Close();
}
return(obj);
}
public static List <entCompanias> ListarCompanias()
{
SqlCommand cmd = null;
SqlDataReader dr = null;
List <entCompanias> listacom = null;
try
{
daoConexion cn = new daoConexion();
SqlConnection cnx = cn.conectar();
cmd = new SqlCommand("SP_CARGAR_COMPANIAS", cnx);
cmd.CommandType = CommandType.StoredProcedure;
cnx.Open();
dr = cmd.ExecuteReader();
listacom = new List <entCompanias>();
while (dr.Read())
{
entCompanias c = new entCompanias();
c.id = Convert.ToInt32(dr["id"].ToString());
c.nombre = dr["nombre"].ToString();
c.nit = dr["nit"].ToString();
c.telefono1 = dr["telefono1"].ToString();
c.telefono2 = dr["telefono2"].ToString();
c.direccion = dr["direccion"].ToString();
c.estado = dr["estado"].ToString();
listacom.Add(c);
}
}
catch (Exception e)
{
throw e;
//listacom = null;
}
finally
{
cmd.Connection.Close();
}
return(listacom);
}
public static List <entClientes> ListarClientes()
{
SqlCommand cmd = null;
SqlDataReader dr = null;
List <entClientes> listacli = null;
try
{
daoConexion cn = new daoConexion();
SqlConnection cnx = cn.conectar();
cmd = new SqlCommand("SP_CARGAR_CLIENTES", cnx);
cmd.CommandType = CommandType.StoredProcedure;
cnx.Open();
dr = cmd.ExecuteReader();
listacli = new List <entClientes>();
while (dr.Read())
{
entClientes c = new entClientes();
c.id = Convert.ToInt32(dr["id"].ToString());
c.nombre = dr["nombre"].ToString();
c.tdocumento = dr["tipo_doc"].ToString();
c.identificacion = dr["identificacion"].ToString();
c.telefono = dr["telefono"].ToString();
c.direccion = dr["direccion"].ToString();
listacli.Add(c);
}
}
catch (Exception e)
{
throw e;
//listacom = null;
}
finally
{
cmd.Connection.Close();
}
return(listacli);
}
public static List <entVentas> ListarVentasxClientes(int idcli)
{
SqlCommand cmd = null;
SqlDataReader dr = null;
List <entVentas> listavtacli = null;
try
{
daoConexion cn = new daoConexion();
SqlConnection cnx = cn.conectar();
cmd = new SqlCommand("SP_CARGAR_VENTAS_X_CLI", cnx);
cmd.Parameters.AddWithValue("@id", idcli);
cmd.CommandType = CommandType.StoredProcedure;
cnx.Open();
dr = cmd.ExecuteReader();
listavtacli = new List <entVentas>();
while (dr.Read())
{
entVentas c = new entVentas();
c.id = Convert.ToInt32(dr["id"].ToString());
c.idpro = Convert.ToInt32(dr["idpro"].ToString());
c.descproducto = dr["descproducto"].ToString();
c.descripcion = dr["descripcion"].ToString();
c.valor = dr["valor"].ToString();
listavtacli.Add(c);
}
}
catch (Exception e)
{
throw e;
//listacom = null;
}
finally
{
cmd.Connection.Close();
}
return(listavtacli);
}
public static entProductos ListarProductosEditar(int operacion, int idpro)
{
SqlCommand cmd = null;
SqlDataReader dr = null;
entProductos obj = null;
try
{
daoConexion cn = new daoConexion();
SqlConnection cnx = cn.conectar();
cmd = new SqlCommand("SP_TRANSAC_PRODUCTOS", cnx);
cmd.Parameters.AddWithValue("@Operacion", operacion);
cmd.Parameters.AddWithValue("@id", idpro);
cmd.Parameters.AddWithValue("@nombre", "");
cmd.Parameters.AddWithValue("@descripcion", "");
cmd.Parameters.AddWithValue("@valor", "");
cmd.CommandType = CommandType.StoredProcedure;
cnx.Open();
dr = cmd.ExecuteReader();
obj = new entProductos();
dr.Read();
entProductos c = new entProductos();
obj.id = Convert.ToInt32(dr["id"].ToString());
obj.nombre = dr["nombre"].ToString();
obj.descripcion = dr["descripcion"].ToString();
obj.valor = dr["valor"].ToString();
}
catch (Exception e)
{
throw e;
//listacom = null;
}
finally
{
cmd.Connection.Close();
}
return(obj);
}
public static List <entVentas> ListarVentasCompanias()
{
SqlCommand cmd = null;
SqlDataReader dr = null;
List <entVentas> listavta = null;
try
{
daoConexion cn = new daoConexion();
SqlConnection cnx = cn.conectar();
cmd = new SqlCommand("SP_CARGAR_VENTAS_TOTAL_COM", cnx);
cmd.CommandType = CommandType.StoredProcedure;
cnx.Open();
dr = cmd.ExecuteReader();
listavta = new List <entVentas>();
while (dr.Read())
{
entVentas c = new entVentas();
c.id = Convert.ToInt32(dr["id"].ToString());
c.idcom = Convert.ToInt32(dr["idcom"].ToString());
c.descCompania = dr["descCompania"].ToString();
c.idpro = Convert.ToInt32(dr["idpro"].ToString());
c.descproducto = dr["descproducto"].ToString();
listavta.Add(c);
}
}
catch (Exception e)
{
throw e;
//listacom = null;
}
finally
{
cmd.Connection.Close();
}
return(listavta);
}
public static entVentas ListarVentasEditarClientes(int operacion, int idvta)
{
SqlCommand cmd = null;
SqlDataReader dr = null;
entVentas obj = null;
try
{
daoConexion cn = new daoConexion();
SqlConnection cnx = cn.conectar();
cmd = new SqlCommand("SP_TRANSAC_VENTAS_CLIENTES", cnx);
cmd.Parameters.AddWithValue("@Operacion", operacion);
cmd.Parameters.AddWithValue("@id", idvta);
cmd.Parameters.AddWithValue("@id_compania", "");
cmd.Parameters.AddWithValue("@id_producto", "");
cmd.CommandType = CommandType.StoredProcedure;
cnx.Open();
dr = cmd.ExecuteReader();
obj = new entVentas();
dr.Read();
entVentas c = new entVentas();
obj.id = Convert.ToInt32(dr["id"].ToString());
obj.idcli = Convert.ToInt32(dr["idcli"].ToString());
obj.nombre = dr["nombre"].ToString();
obj.idpro = Convert.ToInt32(dr["idpro"].ToString());
obj.descproducto = dr["descproducto"].ToString();
}
catch (Exception e)
{
throw e;
//listacom = null;
}
finally
{
cmd.Connection.Close();
}
return(obj);
}
public static List <entProductos> ListarProductos()
{
SqlCommand cmd = null;
SqlDataReader dr = null;
List <entProductos> listapro = null;
try
{
daoConexion cn = new daoConexion();
SqlConnection cnx = cn.conectar();
cmd = new SqlCommand("SP_CARGAR_PRODUCTOS", cnx);
cmd.CommandType = CommandType.StoredProcedure;
cnx.Open();
dr = cmd.ExecuteReader();
listapro = new List <entProductos>();
while (dr.Read())
{
entProductos c = new entProductos();
c.id = Convert.ToInt32(dr["id"].ToString());
c.nombre = dr["nombre"].ToString();
c.descripcion = dr["descripcion"].ToString();
c.valor = dr["valor"].ToString();
listapro.Add(c);
}
}
catch (Exception e)
{
throw e;
//listacom = null;
}
finally
{
cmd.Connection.Close();
}
return(listapro);
}
