Exemplo n.º 1
0
        //Get car type
        public List <CarTypeDTO> GetCartypes()
        {
            cmd.Connection  = conexion.AbrirConexion();
            cmd.CommandText = "select * from type_of_car";
            cmd.CommandType = CommandType.Text;

            List <CarTypeDTO> carTypeDtoList = new List <CarTypeDTO>();

            reader = cmd.ExecuteReader();

            while (reader.Read())
            {
                carTypeDtoList.Add(new CarTypeDTO
                {
                    CarTypeId          = reader.GetInt32(0),
                    CarTypeDescription = reader.GetString(1),
                    CarTypeStatus      = (bool)reader["status"]
                });
            }

            reader.Close();
            conexion.CerrarConexion();

            return(carTypeDtoList);
        }
Exemplo n.º 2
0
        public UserDTO ValidateLoggin(String userCard, String userClave)
        {
            cmd.Connection  = conexion.AbrirConexion();
            cmd.CommandText = "select * from users where user_name = '" + userCard + "' and user_password = '******'";
            cmd.CommandType = CommandType.Text;
            //Remember to encode the password

            reader = cmd.ExecuteReader();

            if (reader.HasRows)//Exite el carro!
            {
                reader.Read();

                status = (bool)reader["user_status"];

                if (!status)
                {
                    user = new UserDTO
                    {
                        Message = "Usuario desactivado! favor contactar al administrador..."
                    };
                    reader.Close();
                    conexion.CerrarConexion();
                    return(user);
                }
                else
                {
                    user = new UserDTO
                    {
                        UserId             = reader.GetInt32(0),
                        EmployeeId         = reader.GetInt32(1),
                        RolCode            = reader.GetString(2),
                        IdentificationCard = reader.GetString(3),
                        UserName           = reader.GetString(4),
                        Password           = reader.GetString(5),
                        Status             = status,
                        Message            = "OK"
                    };
                    reader.Close();
                    conexion.CerrarConexion();
                    return(user);
                }
            }
            else
            {
                user = new UserDTO
                {
                    Message = "Usuario o Clave erronea, favor validar o contactar al administrador!"
                };
                reader.Close();
                conexion.CerrarConexion();
                return(user);
            }
        }
Exemplo n.º 3
0
        //Searchs...

        //Add
        public void ADD(EmployeeDTO dto)
        {
            cmd.Connection  = conexion.AbrirConexion();
            cmd.CommandText = "insert into employees values(@dominicanCard, @employeeCard, @workSession, @name, @lastName, getDate(), @workPosition, @comission, @status)";
            cmd.CommandType = CommandType.Text;
            FillEmployeeDtoParams(cmd, dto);
            cmd.ExecuteNonQuery();

            cmd.Parameters.Clear();
            conexion.CerrarConexion();
        }
Exemplo n.º 4
0
        //Add
        public void ADD(CustomerDTO dto)
        {
            cmd.Connection  = conexion.AbrirConexion();
            cmd.CommandText = "insert into customers values(@name, @lastName, @cedula, @type, @creditCard, @creditLimit, @status, @RNC)";
            cmd.CommandType = CommandType.Text;

            FillCustomerDtoParams(cmd, dto);
            cmd.ExecuteNonQuery();

            cmd.Parameters.Clear();
            conexion.CerrarConexion();
        }
Exemplo n.º 5
0
        //Add
        public void ADD(CarDTO carDTO)
        {
            if (GetCarById(carDTO.LicensePlate, carDTO.ChasisNum, carDTO.EngineNum))
            {
                MessageBox.Show("ERROR : No se acepta duplicidad de registros. Este vehiculo, ya esta en el sistema! favor validar la placa: " + carDTO.LicensePlate + ", el chasis: " + carDTO.ChasisNum + " o el numero de motor: " + carDTO.EngineNum);
            }
            else
            {
                cmd.Connection  = conexion.AbrirConexion();
                cmd.CommandText = "insert into carInfo values (@Base64Photo, @CarType, @CarBrand, @CarModel, @CarFabYear, @CarChasisNum, @CarEngineNum, @CarLicensePlate, @CarColor, @FuelType, @QuantityOfFuel, @CarNumberOfDoors, @CarCapacityOfPassangers,  @CarConditions, @CarUseInKM, @CarInvComment, GETDATE(), null, @CarStatus)";
                cmd.CommandType = CommandType.Text;

                FillCarDtoParams(cmd, carDTO);

                cmd.ExecuteNonQuery();

                cmd.Parameters.Clear();
                conexion.CerrarConexion();
            }
        }
Exemplo n.º 6
0
        //Add
        public bool AddNewModel(CarModelDTO carModelDTO)
        {
            //Validate duplicates
            if (GetModelByDes(carModelDTO.ModelDescription))
            {
                MessageBox.Show("Este modelo " + carModelDTO.ModelDescription + " ya existe en el sistema");
                return(false);
            }
            else
            {
                cmd.Connection  = conexion.AbrirConexion();
                cmd.CommandText = "insert into car_model values (@CarModelDes, @CarBrandId, @CarBrand, @status)";
                cmd.CommandType = CommandType.Text;

                FillCarModelDtoParams(carModelDTO);

                cmd.ExecuteNonQuery();

                cmd.Parameters.Clear();
                conexion.CerrarConexion();

                return(true);
            }
        }
Exemplo n.º 7
0
        public List <RentDTO> GetActiveRents()
        {
            cmd.Connection  = conexion.AbrirConexion();
            cmd.CommandText = "select * from rents where state = 1";
            cmd.CommandType = CommandType.Text;
            reader          = cmd.ExecuteReader();

            List <RentDTO> ListaGenerica = new List <RentDTO>();

            while (reader.Read())
            {
                ListaGenerica.Add(new RentDTO
                {
                    Id             = reader.GetInt32(0),
                    InspectionId   = reader.GetInt32(1),
                    EmployeeInfo   = reader.GetString(2),
                    CarId          = reader.GetInt32(3), //can not be null reader.GetInt32(4)
                    CarInfo        = reader.GetString(4),
                    CustomerInfo   = reader.GetString(5),
                    RentDate       = reader.GetString(6),
                    DevolutionDate = reader.GetString(7),
                    MontPerDay     = reader.GetInt32(8),
                    QuantityOfDays = reader.GetInt32(9),
                    Comment        = reader.GetString(10),//reader.GetString(18)
                    State          = (bool)reader["state"]
                });
            }

            conexion.CerrarConexion();
            reader.Close();

            return(ListaGenerica);
        }