public override bool agregarContrato()
        {
            string sql = "INSERT INTO Contrato VALUES ('" + NumeroContrato + "', GETDATE(), " +
                         "convert(date, '" + FechaFinVigencia + "'), '" + RutCliente +
                         "',(SELECT idPlan FROM [Plan] WHERE Nombre = '" + CodigoPlan + "'), " + TipoContrato
                         + ", convert(date, '" + FechaInicioVigencia + "'), convert(date, '" + FechaFinVigencia + "'), "
                         + Vigente + ", 0," + PrimaAnual.Replace(",", ".") + "," + PrimaMensual.Replace(",", ".") +
                         ",'" + Observaciones + "');";

            string sql1 = "INSERT INTO Vivienda VALUES ('" + CodigoPostal + "', " + Anio + ",'" + Direccion + "', " + ValorInmu + ","
                          + ValorConte + "," + Region + ",(SELECT idComuna FROM Comuna WHERE NombreComuna = '" + Comuna + "'));";
            string sql2 = "INSERT INTO Contrato_vivienda VALUES ('" + NumeroContrato + "', '" + CodigoPostal + "');";

            bool guarda = objConec.insertar(sql);

            bool guarda1 = objConec.insertar(sql1);

            bool guarda2 = objConec.insertar(sql2);

            if (guarda == true)
            {
                return(guarda);
            }
            else
            {
                return(guarda);
            }
        }
示例#2
0
        public override bool agregarContrato()
        {
            string sql = "INSERT INTO Contrato VALUES ('" + NumeroContrato + "', GETDATE(), " +
                         "convert(date, '" + FechaFinVigencia + "'), '" + RutCliente +
                         "',(SELECT idPlan FROM [Plan] WHERE Nombre = '" + CodigoPlan + "'), " + TipoContrato
                         + ", convert(date, '" + FechaInicioVigencia + "'), convert(date, '" + FechaFinVigencia + "'), "
                         + Vigente + ", 0," + PrimaAnual.Replace(",", ".") + "," + PrimaMensual.Replace(",", ".") +
                         ",'" + Observaciones + "');";

            string sql1 = "INSERT INTO Vehiculo VALUES ('" + Patente + "'," + Marca
                          + ", (SELECT IdModelo FROM ModeloVehiculo WHERE Descripcion = '" + Modelo + "')," + Anio + ");";
            string sql2 = "INSERT INTO contratoVehiculo VALUES ('" + NumeroContrato + "', '" + Patente + "');";

            bool guarda = objConec.insertar(sql);

            bool guarda1 = objConec.insertar(sql1);

            bool guarda2 = objConec.insertar(sql2);

            if (guarda == true)
            {
                return(guarda);
            }
            else
            {
                return(guarda);
            }
        }
示例#3
0
        public override bool editarContrato()
        {
            string campos = "CodigoPlan = (SELECT idPlan FROM [Plan] WHERE Nombre = '" + CodigoPlan + "') " +
                            ", PrimaAnual = " + PrimaAnual.Replace(",", ".") + ", " +
                            "PrimaMensual = " + PrimaMensual.Replace(",", ".") + ", Observaciones = '" + Observaciones + "' ";
            string condicion = " Numero = '" + NumeroContrato + "';";
            bool   edita     = objConec.actualizar("Contrato", campos, condicion);

            string campos1 = "IdMarca =" + Marca
                             + ", IdModelo = (SELECT IdModelo FROM ModeloVehiculo WHERE Descripcion = '" + Modelo + "')," +
                             "Anho = " + Anio + "";
            string condicion1 = "Patente = '" + Patente + "';";

            bool edita1 = objConec.actualizar("Vehiculo", campos1, condicion1);


            if (edita == true)
            {
                return(edita);
            }
            else
            {
                return(edita);
            }
        }
示例#4
0
        public override bool editarContrato()
        {
            string campos = "CodigoPlan = (SELECT idPlan FROM [Plan] WHERE Nombre = '" + CodigoPlan + "') " +
                            ", PrimaAnual = " + PrimaAnual.Replace(",", ".") + ", " +
                            "PrimaMensual = " + PrimaMensual.Replace(",", ".") + ", Observaciones = '" + Observaciones + "' ";
            string condicion = " Numero = '" + NumeroContrato + "';";
            bool   edita     = objConec.actualizar("Contrato", campos, condicion);

            string campos1 = "Anho = " + Anio + ", Direccion = '" + Direccion + "', ValorInmueble= " + ValorInmu
                             + ", ValorContenido = " + ValorConte + ", IdRegion = " + Region
                             + ", idComuna = (SELECT idComuna FROM Comuna WHERE NombreComuna = '" + Comuna + "') ";

            string condicion1 = "CodigoPostal = '" + CodigoPostal + "';";

            bool edita1 = objConec.actualizar("Vivienda", campos1, condicion1);

            if (edita == true)
            {
                return(edita);
            }
            else
            {
                return(edita);
            }
        }
示例#5
0
        public override bool agregarContrato()
        {
            string sql = "INSERT INTO Contrato VALUES ('" + NumeroContrato + "', GETDATE(), " +
                         "convert(date, '" + FechaFinVigencia + "'), '" + RutCliente +
                         "',(SELECT idPlan FROM [Plan] WHERE Nombre = '" + CodigoPlan + "'), " + TipoContrato
                         + ", convert(date, '" + FechaInicioVigencia + "'), convert(date, '" + FechaFinVigencia + "'), "
                         + Vigente + ", " + DeclaracionSalud + "," + PrimaAnual.Replace(",", ".") + ","
                         + PrimaMensual.Replace(",", ".") + ",'" + Observaciones + "');";

            bool guarda = objConec.insertar(sql);

            if (guarda == true)
            {
                return(guarda);
            }
            else
            {
                return(guarda);
            }
        }
示例#6
0
        public override bool editarContrato()
        {
            string campos = "CodigoPlan = (SELECT idPlan FROM [Plan] WHERE Nombre = '" + CodigoPlan + "'),  " +
                            "DeclaracionSalud = " + DeclaracionSalud + ", PrimaAnual = " + PrimaAnual.Replace(",", ".") + ", " +
                            "PrimaMensual = " + PrimaMensual.Replace(",", ".") + ", Observaciones = '" + Observaciones + "' ";
            string condicion = " Numero = '" + NumeroContrato + "';";
            bool   edita     = objConec.actualizar("Contrato", campos, condicion);

            if (edita == true)
            {
                return(edita);
            }
            else
            {
                return(edita);
            }
        }