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); }