示例#1
0
        // methods for listing all.
        public static List <facturacion> listAllRent()
        {
            List <facturacion> list = new List <facturacion>();

            using (SqlConnection con = DBcomun.getConnection())
            {
                SqlCommand    comand = new SqlCommand(string.Format("SELECT rentFacturacion.ID, services.cService, Rent.ID AS CasoID, customers.name, customers.lastname, customers.ID, customers.idcard, rentFacturacion.Mensualidad, rentFacturacion.Deposito, rentFacturacion.contratoCant FROM rentFacturacion INNER JOIN customers ON customers.ID = rentFacturacion.clienteID INNER JOIN Rent ON Rent.ID = rentFacturacion.caseID INNER JOIN services ON services.ID = rentFacturacion.serviceID"), con);
                SqlDataReader re     = comand.ExecuteReader();
                while (re.Read())
                {
                    facturacion pFactura = new facturacion();

                    pFactura.ID               = re["ID"].ToString();
                    pFactura.Abono            = "No hay abono registrado";
                    pFactura.CasoNO           = re["CasoID"].ToString();
                    pFactura.Apellido_Cliente = re["lastname"].ToString();
                    pFactura.Cedula           = re["idcard"].ToString();
                    pFactura.Nombre_Cliente   = re["name"].ToString();
                    pFactura.Pago_Total       = Convert.ToDouble(re["Mensualidad"]).ToString("f2");
                    pFactura.Servicio         = re["cService"].ToString();
                    pFactura.Deposito         = Convert.ToDouble(re["ContratoCant"]).ToString("f2");

                    list.Add(pFactura);
                }
                con.Close();
            }
            return(list);
        }
示例#2
0
        // methods for listing all.
        public static List<facturacion> listAllRent()
        {
            List<facturacion> list = new List<facturacion>();
            using(SqlConnection con = DBcomun.getConnection())
            {
                SqlCommand comand = new SqlCommand(string.Format("SELECT rentFacturacion.ID, services.cService, Rent.ID AS CasoID, customers.name, customers.lastname, customers.ID, customers.idcard, rentFacturacion.Mensualidad, rentFacturacion.Deposito, rentFacturacion.contratoCant FROM rentFacturacion INNER JOIN customers ON customers.ID = rentFacturacion.clienteID INNER JOIN Rent ON Rent.ID = rentFacturacion.caseID INNER JOIN services ON services.ID = rentFacturacion.serviceID"), con);
                SqlDataReader re = comand.ExecuteReader();
                while (re.Read())
                {
                    facturacion pFactura = new facturacion();

                    pFactura.ID = re["ID"].ToString();
                    pFactura.Abono = "No hay abono registrado";
                    pFactura.CasoNO = re["CasoID"].ToString();
                    pFactura.Apellido_Cliente = re["lastname"].ToString();
                    pFactura.Cedula = re["idcard"].ToString();
                    pFactura.Nombre_Cliente = re["name"].ToString();
                    pFactura.Pago_Total = Convert.ToDouble(re["Mensualidad"]).ToString("f2");
                    pFactura.Servicio = re["cService"].ToString();
                    pFactura.Deposito = Convert.ToDouble(re["ContratoCant"]).ToString("f2");

                    list.Add(pFactura);
                }
                con.Close();
            }
            return list;
        }
示例#3
0
        public static List <facturacion> searchVentas(string cedulaVe, string cedulaC)
        {
            List <facturacion> list = new List <facturacion>();

            using (SqlConnection con = DBcomun.getConnection())
            {
                SqlCommand comand = new SqlCommand(string.Format("SELECT ventaFacturacion.ID, services.cService, Venta.ID AS CasoID, VENDEDOR.name, VENDEDOR.lastname, VENDEDOR.idcard, ventaFacturacion.TotalPago, ventaFacturacion.Abono FROM Venta INNER JOIN ventaFacturacion ON Venta.ID = ventaFacturacion.caseID INNER JOIN customers AS VENDEDOR ON VENDEDOR.ID = Venta.VendedorID INNER JOIN services ON services.ID = ventaFacturacion.serviceID INNER JOIN customers AS COMPRADOR ON COMPRADOR.ID = Venta.CompradorID " +
                                                                 " WHERE VENDEDOR.idcard LIKE '{0}%' AND COMPRADOR.idcard LIKE '{1}%'", cedulaVe, cedulaC), con);
                SqlDataReader reader = comand.ExecuteReader();
                while (reader.Read())
                {
                    facturacion pFactura = new facturacion();

                    pFactura.ID               = reader["ID"].ToString();
                    pFactura.Abono            = Convert.ToDouble(reader["Abono"]).ToString("f2");
                    pFactura.CasoNO           = reader["CasoID"].ToString();
                    pFactura.Apellido_Cliente = reader["lastname"].ToString();
                    pFactura.Cedula           = reader["idcard"].ToString();
                    pFactura.Nombre_Cliente   = reader["name"].ToString();
                    pFactura.Pago_Total       = Convert.ToDouble(reader["TotalPago"]).ToString("f2");
                    pFactura.Servicio         = reader["cService"].ToString();
                    pFactura.Deposito         = "No hay deposito registrado";

                    list.Add(pFactura);
                }
                con.Close();
            }
            return(list);
        }
示例#4
0
        public static List <facturacion> searchDivorciosAccidentes(string cedulaE, string cedulaO)
        {
            List <facturacion> list = new List <facturacion>();

            using (SqlConnection con = DBcomun.getConnection())
            {
                SqlCommand comand = new SqlCommand(string.Format("SELECT divorciosFacturacion.ID, services.cService, divorcios.ID AS CasoID, DEMANDANTE.name, DEMANDANTE.lastname, DEMANDANTE.idcard, divorciosFacturacion.TotalPago, divorciosFacturacion.Abono FROM divorcios INNER JOIN divorciosFacturacion ON divorcios.ID = divorciosFacturacion.CaseID INNER JOIN customers AS DEMANDANTE ON DEMANDANTE.ID = divorcios.DemandanteID INNER JOIN services ON services.ID = divorciosFacturacion.serviceID INNER JOIN customers AS DEMANDADO ON divorcios.DemandadoID = DEMANDADO.ID " +
                                                                 " WHERE DEMANDANTE.idcard LIKE '{0}%' AND DEMANDADO.idcard LIKE '{1}%'", cedulaE, cedulaO), con);
                SqlDataReader reader = comand.ExecuteReader();
                while (reader.Read())
                {
                    facturacion pFactura = new facturacion();

                    pFactura.ID               = reader["ID"].ToString();
                    pFactura.Abono            = Convert.ToDouble(reader["Abono"]).ToString("f2");
                    pFactura.CasoNO           = reader["CasoID"].ToString();
                    pFactura.Apellido_Cliente = reader["lastname"].ToString();
                    pFactura.Cedula           = reader["idcard"].ToString();
                    pFactura.Nombre_Cliente   = reader["name"].ToString();
                    pFactura.Pago_Total       = Convert.ToDouble(reader["TotalPago"]).ToString("f2");
                    pFactura.Servicio         = reader["cService"].ToString();
                    pFactura.Deposito         = "No hay deposito registrado";

                    list.Add(pFactura);
                }
                con.Close();
            }
            return(list);
        }
示例#5
0
        // methods for searching all.
        public static List <facturacion> searchRent(string cedulaCli, string cedulaIn, string cedulaGa)
        {
            List <facturacion> list = new List <facturacion>();

            using (SqlConnection con = DBcomun.getConnection())
            {
                SqlCommand comand = new SqlCommand(string.Format("SELECT rentFacturacion.ID, services.cService, Rent.ID AS CasoID, CLENTE.name, CLENTE.lastname, CLENTE.ID, CLENTE.idcard, rentFacturacion.Mensualidad, rentFacturacion.Deposito FROM Rent INNER JOIN customers AS CLENTE ON CLENTE.ID = Rent.CLienteID INNER JOIN rentFacturacion ON Rent.ID = rentFacturacion.caseID INNER JOIN services ON services.ID = rentFacturacion.serviceID INNER JOIN customers AS INQUILINO ON INQUILINO.ID = Rent.InquilinoID INNER JOIN customers AS GARANTE ON GARANTE.ID = Rent.GaranteID " +
                                                                 " WHERE CLENTE.idcard LIKE '{0}%' AND INQUILINO.idcard LIKE '{1}%' AND GARANTE.idcard LIKE '{2}%'", cedulaCli, cedulaIn, cedulaGa), con);
                SqlDataReader re = comand.ExecuteReader();
                while (re.Read())
                {
                    facturacion pFactura = new facturacion();

                    pFactura.ID               = re["ID"].ToString();
                    pFactura.Abono            = "No hay abono registrado";
                    pFactura.CasoNO           = re["CasoID"].ToString();
                    pFactura.Apellido_Cliente = re["lastname"].ToString();
                    pFactura.Cedula           = re["idcard"].ToString();
                    pFactura.Nombre_Cliente   = re["name"].ToString();
                    pFactura.Pago_Total       = Convert.ToDouble(re["Mensualidad"]).ToString("f2");
                    pFactura.Servicio         = re["cService"].ToString();
                    pFactura.Deposito         = Convert.ToDouble(re["Deposito"]).ToString("f2");

                    list.Add(pFactura);
                }
                con.Close();
            }
            return(list);
        }
示例#6
0
        public static List <facturacion> listAllVentas()
        {
            List <facturacion> list = new List <facturacion>();

            using (SqlConnection con = DBcomun.getConnection())
            {
                SqlCommand    comand = new SqlCommand("SELECT ventaFacturacion.ID, services.cService, Venta.ID AS CasoID, customers.name, customers.lastname, customers.idcard, ventaFacturacion.TotalPago, ventaFacturacion.Abono FROM ventaFacturacion INNER JOIN Venta ON Venta.ID = ventaFacturacion.caseID INNER JOIN customers ON customers.ID = ventaFacturacion.clienteID INNER JOIN services ON services.ID = ventaFacturacion.serviceID", con);
                SqlDataReader re     = comand.ExecuteReader();
                while (re.Read())
                {
                    facturacion pFactura = new facturacion();

                    pFactura.ID               = re["ID"].ToString();
                    pFactura.Abono            = Convert.ToDouble(re["Abono"]).ToString("f2");
                    pFactura.CasoNO           = re["CasoID"].ToString();
                    pFactura.Apellido_Cliente = re["lastname"].ToString();
                    pFactura.Cedula           = re["idcard"].ToString();
                    pFactura.Nombre_Cliente   = re["name"].ToString();
                    pFactura.Pago_Total       = Convert.ToDouble(re["TotalPago"]).ToString("f2");
                    pFactura.Servicio         = re["cService"].ToString();
                    pFactura.Deposito         = "No hay deposito registrado";

                    list.Add(pFactura);
                }
                con.Close();
            }
            return(list);
        }
示例#7
0
        public static List<facturacion> listAllDivorciosAccidentes()
        {
            List<facturacion> list = new List<facturacion>();
            using(SqlConnection con = DBcomun.getConnection())
            {
                SqlCommand comand = new SqlCommand("SELECT divorciosFacturacion.ID, services.cService, divorcios.ID AS CasoID, customers.name, customers.lastname, customers.idcard, divorciosFacturacion.TotalPago, divorciosFacturacion.Abono FROM divorciosFacturacion INNER JOIN divorcios ON divorcios.ID = divorciosFacturacion.CaseID INNER JOIN customers ON customers.ID = divorciosFacturacion.clienteID INNER JOIN services ON services.ID = divorciosFacturacion.serviceID", con);
                SqlDataReader re = comand.ExecuteReader();
                while (re.Read())
                {
                    facturacion pFactura = new facturacion();

                    pFactura.ID = re["ID"].ToString();
                    pFactura.Abono = Convert.ToDouble(re["Abono"]).ToString("f2");
                    pFactura.CasoNO = re["CasoID"].ToString();
                    pFactura.Apellido_Cliente = re["lastname"].ToString();
                    pFactura.Cedula = re["idcard"].ToString();
                    pFactura.Nombre_Cliente = re["name"].ToString();
                    pFactura.Pago_Total = Convert.ToDouble(re["TotalPago"]).ToString("f2");
                    pFactura.Servicio = re["cService"].ToString();
                    pFactura.Deposito = "No hay deposito registrado";

                    list.Add(pFactura);
                }
                con.Close();
            }
            return list;
        }
示例#8
0
        public static List<facturacion> searchVentas(string cedulaVe, string cedulaC)
        {
            List<facturacion> list = new List<facturacion>();
            using (SqlConnection con = DBcomun.getConnection())
            {
                SqlCommand comand = new SqlCommand(string.Format("SELECT ventaFacturacion.ID, services.cService, Venta.ID AS CasoID, VENDEDOR.name, VENDEDOR.lastname, VENDEDOR.idcard, ventaFacturacion.TotalPago, ventaFacturacion.Abono FROM Venta INNER JOIN ventaFacturacion ON Venta.ID = ventaFacturacion.caseID INNER JOIN customers AS VENDEDOR ON VENDEDOR.ID = Venta.VendedorID INNER JOIN services ON services.ID = ventaFacturacion.serviceID INNER JOIN customers AS COMPRADOR ON COMPRADOR.ID = Venta.CompradorID " +
                    " WHERE VENDEDOR.idcard LIKE '{0}%' AND COMPRADOR.idcard LIKE '{1}%'", cedulaVe, cedulaC), con);
                SqlDataReader reader = comand.ExecuteReader();
                while (reader.Read())
                {
                    facturacion pFactura = new facturacion();

                    pFactura.ID = reader["ID"].ToString();
                    pFactura.Abono = Convert.ToDouble(reader["Abono"]).ToString("f2");
                    pFactura.CasoNO = reader["CasoID"].ToString();
                    pFactura.Apellido_Cliente = reader["lastname"].ToString();
                    pFactura.Cedula = reader["idcard"].ToString();
                    pFactura.Nombre_Cliente = reader["name"].ToString();
                    pFactura.Pago_Total = Convert.ToDouble(reader["TotalPago"]).ToString("f2");
                    pFactura.Servicio = reader["cService"].ToString();
                    pFactura.Deposito = "No hay deposito registrado";

                    list.Add(pFactura);
                }
                con.Close();
            }
            return list;
        }
示例#9
0
        public static List<facturacion> searchDivorciosAccidentes(string cedulaE, string cedulaO)
        {
            List<facturacion> list = new List<facturacion>();
            using(SqlConnection con = DBcomun.getConnection())
            {
                SqlCommand comand = new SqlCommand(string.Format("SELECT divorciosFacturacion.ID, services.cService, divorcios.ID AS CasoID, DEMANDANTE.name, DEMANDANTE.lastname, DEMANDANTE.idcard, divorciosFacturacion.TotalPago, divorciosFacturacion.Abono FROM divorcios INNER JOIN divorciosFacturacion ON divorcios.ID = divorciosFacturacion.CaseID INNER JOIN customers AS DEMANDANTE ON DEMANDANTE.ID = divorcios.DemandanteID INNER JOIN services ON services.ID = divorciosFacturacion.serviceID INNER JOIN customers AS DEMANDADO ON divorcios.DemandadoID = DEMANDADO.ID " +
                    " WHERE DEMANDANTE.idcard LIKE '{0}%' AND DEMANDADO.idcard LIKE '{1}%'", cedulaE, cedulaO), con);
                SqlDataReader reader = comand.ExecuteReader();
                while (reader.Read())
                {
                    facturacion pFactura = new facturacion();

                    pFactura.ID = reader["ID"].ToString();
                    pFactura.Abono = Convert.ToDouble(reader["Abono"]).ToString("f2");
                    pFactura.CasoNO = reader["CasoID"].ToString();
                    pFactura.Apellido_Cliente = reader["lastname"].ToString();
                    pFactura.Cedula = reader["idcard"].ToString();
                    pFactura.Nombre_Cliente = reader["name"].ToString();
                    pFactura.Pago_Total = Convert.ToDouble(reader["TotalPago"]).ToString("f2");
                    pFactura.Servicio = reader["cService"].ToString();
                    pFactura.Deposito = "No hay deposito registrado";

                    list.Add(pFactura);
                }
                con.Close();
            }
            return list;
        }
示例#10
0
        // methods for searching all.
        public static List<facturacion> searchRent(string cedulaCli, string cedulaIn, string cedulaGa)
        {
            List<facturacion> list = new List<facturacion>();
            using(SqlConnection con = DBcomun.getConnection())
            {
                SqlCommand comand = new SqlCommand(string.Format("SELECT rentFacturacion.ID, services.cService, Rent.ID AS CasoID, CLENTE.name, CLENTE.lastname, CLENTE.ID, CLENTE.idcard, rentFacturacion.Mensualidad, rentFacturacion.Deposito FROM Rent INNER JOIN customers AS CLENTE ON CLENTE.ID = Rent.CLienteID INNER JOIN rentFacturacion ON Rent.ID = rentFacturacion.caseID INNER JOIN services ON services.ID = rentFacturacion.serviceID INNER JOIN customers AS INQUILINO ON INQUILINO.ID = Rent.InquilinoID INNER JOIN customers AS GARANTE ON GARANTE.ID = Rent.GaranteID " +
                    " WHERE CLENTE.idcard LIKE '{0}%' AND INQUILINO.idcard LIKE '{1}%' AND GARANTE.idcard LIKE '{2}%'", cedulaCli, cedulaIn, cedulaGa), con);
                SqlDataReader re = comand.ExecuteReader();
                while (re.Read())
                {
                    facturacion pFactura = new facturacion();

                    pFactura.ID = re["ID"].ToString();
                    pFactura.Abono = "No hay abono registrado";
                    pFactura.CasoNO = re["CasoID"].ToString();
                    pFactura.Apellido_Cliente = re["lastname"].ToString();
                    pFactura.Cedula = re["idcard"].ToString();
                    pFactura.Nombre_Cliente = re["name"].ToString();
                    pFactura.Pago_Total = Convert.ToDouble(re["Mensualidad"]).ToString("f2");
                    pFactura.Servicio = re["cService"].ToString();
                    pFactura.Deposito = Convert.ToDouble(re["Deposito"]).ToString("f2");

                    list.Add(pFactura);
                }
                con.Close();
            }
            return list;
        }