private void ucViewSelectedCar_Load(object sender, EventArgs e)
        {
            string queryOffer = "SELECT customerFirstName as 'Name', offerAmount as 'Amount', customerContact as 'Contact', offerDate as 'To Purchase Date', offerSpecialNote as 'Notes' from tbloffers where vehicleId = '" + GlobalLoginData.vehicleId + "'";

            DatabaseHandler.populateGridViewWithBinding(queryOffer, datagridOffersVehicle);

            string queryVehicle = "select * from tblvehicle where tblvehicle.vehicleID = vehicleId";

            txtPriceViewVehicle.Text             = DatabaseHandler.returnOneValueWithoutParams(queryVehicle, "price");
            txtMakeViewVehicle.Text              = DatabaseHandler.returnOneValueWithoutParams(queryVehicle, "vehicleMake");
            txtMadelViewVehicle.SelectedText     = DatabaseHandler.returnOneValueWithoutParams(queryVehicle, "vehicleModel");
            txtStatusViewVehicle.SelectedText    = DatabaseHandler.returnOneValueWithoutParams(queryVehicle, "vehicleStatus");
            txtYearOfManufactureViewVehicle.Text = DatabaseHandler.returnOneValueWithoutParams(queryVehicle, "vehicleManufacturedDate");

            //byte[] img1 = Encoding.ASCII.GetBytes(DatabaseHandler.returnOneValueWithoutParams(queryVehicle, "vehicleImageOne"));
            //byte[] img2 = Encoding.ASCII.GetBytes(DatabaseHandler.returnOneValueWithoutParams(queryVehicle, "vehicleImageTwo"));
            //byte[] img3 = Encoding.ASCII.GetBytes(DatabaseHandler.returnOneValueWithoutParams(queryVehicle, "vehicleImageThree"));
            //byte[] img4 = Encoding.ASCII.GetBytes(DatabaseHandler.returnOneValueWithoutParams(queryVehicle, "vehicleImageFour"));
            //byte[] img5 = Encoding.ASCII.GetBytes(DatabaseHandler.returnOneValueWithoutParams(queryVehicle, "vehicleImageFive"));

            //MemoryStream ms = new MemoryStream(img1);

            //picBoxViewCar01.Image = Image.FromStream(ms);
            //picBoxViewCar02.Image = Image.FromStream(new MemoryStream(img2));
            //picBoxViewCar03.Image = Image.FromStream(new MemoryStream(img3));
            //picBoxViewCar04.Image = Image.FromStream(new MemoryStream(img4));
            //picBoxViewCar05.Image = Image.FromStream(new MemoryStream(img5));
        }
Beispiel #2
0
        private void viewUser_Load(object sender, EventArgs e)
        {
            string query = "select * from tblvehicle where tblvehicle.vehicleID = '" + GlobalLoginData.vehicleId + "'";
            int    rows  = DatabaseHandler.returnRowCountWithoutParams(query);

            if (rows == 1)
            {
                btnEdit.Show();

                txtVehicleRegNo.Text             = DatabaseHandler.returnOneValueWithoutParams(query, "vehicleRegNo");
                txtMake.Text                     = DatabaseHandler.returnOneValueWithoutParams(query, "vehicleMake");
                cmbModel.SelectedText            = DatabaseHandler.returnOneValueWithoutParams(query, "vehicleModel");
                cmbVehicleStatus.SelectedText    = DatabaseHandler.returnOneValueWithoutParams(query, "vehicleStatus");
                cmbFuelType.SelectedText         = DatabaseHandler.returnOneValueWithoutParams(query, "vehicleFuelType");
                cmbTransmissionGear.SelectedText = DatabaseHandler.returnOneValueWithoutParams(query, "vehicleTransmissionGear");
                txtChassisNo.Text                = DatabaseHandler.returnOneValueWithoutParams(query, "vehicleChasisNo");
                txtEngineNo.Text                 = DatabaseHandler.returnOneValueWithoutParams(query, "vehicleEngineNo");
                txtCylinderCapacity.Text         = DatabaseHandler.returnOneValueWithoutParams(query, "vehicleCylinderCapacity");
                txtColor.Text                    = DatabaseHandler.returnOneValueWithoutParams(query, "vehicleColor");
                cmbOriginCountry.SelectedText    = DatabaseHandler.returnOneValueWithoutParams(query, "countryOfOrigin");
                countPreviousOwner.Value         = Convert.ToInt16(DatabaseHandler.returnOneValueWithoutParams(query, "previousOwnerCount"));
                countSeatingCapacity.Value       = Convert.ToInt16(DatabaseHandler.returnOneValueWithoutParams(query, "vehicleSeatingCapacity"));
                countServicesDone.Value          = Convert.ToInt16(DatabaseHandler.returnOneValueWithoutParams(query, "noOfServicesDone"));
                dateFirstRegDate.Value           = Convert.ToDateTime(DatabaseHandler.returnOneValueWithoutParams(query, "vehicleRegDate"));
                dateInsurance.Value              = Convert.ToDateTime(DatabaseHandler.returnOneValueWithoutParams(query, "insuranceDate"));
                yearManufacture.Value            = Convert.ToDateTime(DatabaseHandler.returnOneValueWithoutParams(query, "vehicleManufacturedDate"));
                dateLastService.Value            = Convert.ToDateTime(DatabaseHandler.returnOneValueWithoutParams(query, "lastServiceDate"));
                txtInsuranceType.Text            = DatabaseHandler.returnOneValueWithoutParams(query, "insuranceType");
                txtInsuranceCompany.Text         = DatabaseHandler.returnOneValueWithoutParams(query, "insuranceCompany");
                txtSpecialNotes.Text             = DatabaseHandler.returnOneValueWithoutParams(query, "specialNotes");
                txtVehiclePrice.Text             = DatabaseHandler.returnOneValueWithoutParams(query, "price");

                //byte[] img = Encoding.ASCII.GetBytes(DatabaseHandler.returnOneValueWithoutParams(query, "vehicleImageOne"));
                //byte[] img2 = Encoding.ASCII.GetBytes(DatabaseHandler.returnOneValueWithoutParams(query, "vehicleImageTwo"));
                //byte[] img3 = Encoding.ASCII.GetBytes(DatabaseHandler.returnOneValueWithoutParams(query, "vehicleImageThree"));
                //byte[] img4 = Encoding.ASCII.GetBytes(DatabaseHandler.returnOneValueWithoutParams(query, "vehicleImageFour"));
                //byte[] img5 = Encoding.ASCII.GetBytes(DatabaseHandler.returnOneValueWithoutParams(query, "vehicleImageFive"));
                //byte[] img6 = Encoding.ASCII.GetBytes(DatabaseHandler.returnOneValueWithoutParams(query, "vehicleImageSix"));
                //byte[] img7 = Encoding.ASCII.GetBytes(DatabaseHandler.returnOneValueWithoutParams(query, "vehicleImageSeven"));
                //byte[] img8 = Encoding.ASCII.GetBytes(DatabaseHandler.returnOneValueWithoutParams(query, "vehicleImageEight"));
                //byte[] img9 = Encoding.ASCII.GetBytes(DatabaseHandler.returnOneValueWithoutParams(query, "vehicleImageNine"));

                //picBoxOne.Image = Image.FromStream(new MemoryStream(img));
                //picBoxTwo.Image = Image.FromStream(new MemoryStream(img2));
                //picBoxThree.Image = Image.FromStream(new MemoryStream(img3));
                //picBoxFour.Image = Image.FromStream(new MemoryStream(img4));
                //picBoxFive.Image = Image.FromStream(new MemoryStream(img5));
                //picBoxSix.Image = Image.FromStream(new MemoryStream(img6));
                //picBoxSeven.Image = Image.FromStream(new MemoryStream(img7));
                //picBoxEight.Image = Image.FromStream(new MemoryStream(img8));
                //picBoxNine.Image = Image.FromStream(new MemoryStream(img9));

                txtVehicleRegNo.ReadOnly      = true;
                txtMake.ReadOnly              = true;
                cmbModel.Enabled              = false;
                cmbVehicleStatus.Enabled      = false;
                cmbFuelType.Enabled           = false;
                cmbTransmissionGear.Enabled   = false;
                txtChassisNo.ReadOnly         = true;
                txtCylinderCapacity.ReadOnly  = true;
                txtColor.ReadOnly             = true;
                cmbOriginCountry.Enabled      = false;
                countPreviousOwner.ReadOnly   = true;
                countSeatingCapacity.ReadOnly = true;
                countServicesDone.ReadOnly    = true;
                dateFirstRegDate.Enabled      = false;
                dateInsurance.Enabled         = false;
                yearManufacture.Enabled       = false;
                dateLastService.Enabled       = false;
                txtInsuranceType.ReadOnly     = true;
                txtInsuranceCompany.ReadOnly  = true;
                txtSpecialNotes.ReadOnly      = true;
                picBoxOne.Enabled             = false;
                picBoxTwo.Enabled             = false;
                picBoxThree.Enabled           = false;
                picBoxFour.Enabled            = false;
                picBoxFive.Enabled            = false;
                picBoxSix.Enabled             = false;
                picBoxSeven.Enabled           = false;
                picBoxEight.Enabled           = false;
                picBoxNine.Enabled            = false;
                txtVehiclePrice.ReadOnly      = true;
            }
        }