public VehicleObject getAVehicle(string connectionString, int Stock_Code)
{
DataTable results = new DataTable();
VehicleObject vehicle = new VehicleObject();
try
{
conn = DBUtility.createConnection(connectionString);
SqlCommand cmdIns = DBUtility.PrepareReadCommand("GetAVehicle", conn);
cmdIns.Parameters.Add(new SqlParameter("@Stock_Code", Stock_Code));
using (conn)
using (cmdIns)
using (SqlDataAdapter dataAdapter = new SqlDataAdapter(cmdIns))
{
dataAdapter.Fill(results);
}
vehicle = getVehicleObject(results);
cmdIns.Dispose();
DBUtility.Close(conn);
conn.Dispose();
return vehicle;
}
catch (Exception ex)
{
throw new Exception(ex.ToString(), ex);
}
finally
{
DBUtility.Close(conn);
conn.Dispose();
}
}
protected void btnSaveVehicle_ServerClick(object sender, EventArgs e)
{
VehicleObject obj = new VehicleObject();
imageUtil = new ImageUtility();
obj.AC = chkBoxAC.Checked;
obj.Airbag = chkBoxAirbags.Checked;
obj.AL = chkBoxAL.Checked;
if (dateVehicleArrivalDate.Value != "")
{
obj.Arrival_Date = DateTime.ParseExact(dateVehicleArrivalDate.Value, "dd/MM/yyyy", System.Globalization.CultureInfo.InvariantCulture);
}
obj.Automatic_Transmission = chkBoxAL.Checked;
obj.CD = chkBoxAL.Checked;
obj.Chassis_Number = txtVehicleChassisNumber.Value;
obj.CI = chkBoxCI.Checked;
obj.Colour = txtVehicleColour.Value;
obj.Condition = txtVehicleCondition.Value;
obj.COR = chkBoxCOR.Checked;
if (txtVehicleCostPrice.Value != "")
{
obj.Cost_Price = Convert.ToDecimal(txtVehicleCostPrice.Value);
}
obj.Engine_Number = txtVehicleEngineNumber.Value;
obj.Extra_Features = txtVehicleExtraFeatures.Value;
obj.FSH = chkBoxFSH.Checked;
obj.Gearlock = chkBoxGearlock.Checked;
obj.Leather = chkBoxLeather.Checked;
obj.Location_Name = lstVehicleLocation.Value;
obj.Mags = chkBoxMags.Checked;
obj.Manufacturer_Name = lstVehicleManufacturerName.Value;
if (txtVehicleMileage.Value != "")
{
obj.Mileage = Convert.ToInt32(txtVehicleMileage.Value);
}
obj.Model_Name = lstVehicleModelName.Value;
obj.MP3 = chkBoxMP3.Checked;
if (Session["Image1"] != null)
{
obj.Picture_1 = imageUtil.imageToByteArray(Session["Image1"].ToString());
}
if (Session["Image2"] != null)
{
obj.Picture_2 = imageUtil.imageToByteArray(Session["Image2"].ToString());
}
if (Session["Image3"] != null)
{
obj.Picture_3 = imageUtil.imageToByteArray(Session["Image3"].ToString());
}
obj.PS = chkBoxPS.Checked;
obj.Registration_Number = txtVehicleRegistrationNumber.Value;
if (txtVehicleRetailPrice.Value != "")
{
obj.Retail_Price = Convert.ToDecimal(txtVehicleRetailPrice.Value);
}
obj.RT = chkBoxRT.Checked;
obj.Sports_Kit = chkBoxSportsKit.Checked;
obj.SR = chkBoxSR.Checked;
obj.Supplier_NameProp = lstVehicleSupplier.Value;
obj.Vehicle_Status = lstVehicleStatus.Value;
if (txtVehicleWholesalePrice.Value != "")
{
obj.Wholesale_Price = Convert.ToDecimal(txtVehicleWholesalePrice.Value);
}
ManageVehicle vehicleObj = new ManageVehicle();
bool success = vehicleObj.updateAVehicle(ConfigurationManager.ConnectionStrings["MVSSqlDev2008ConnectionString"].ConnectionString,obj,(int)ViewState["id"]);
if (success)
{
divSuccess.Visible = true;
}
else
divFailure.Visible = true;
imageUtil = null;
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
int id = 0;
if (Request.QueryString["id"] != null)
{
id = int.Parse(Request.QueryString["id"]);
ViewState.Add("id", id);
editVehicle = new ManageVehicle().getAVehicle(ConfigurationManager.ConnectionStrings["MVSSqlDev2008ConnectionString"].ConnectionString, id);
}
bindLstManufacturer();
ListItem liManName = lstVehicleManufacturerName.Items.FindByValue(editVehicle.Manufacturer_Name.Trim());
liManName.Selected = true;
bindLstModel();
ListItem liModelName = lstVehicleModelName.Items.FindByText(editVehicle.Model_Name.Trim());
liModelName.Selected = true;
bindLstSupplier();
ListItem liSupplier = lstVehicleSupplier.Items.FindByText(editVehicle.Supplier_NameProp.Trim());
liSupplier.Selected = true;
bindLstLocation();
ListItem liLocation = lstVehicleLocation.Items.FindByText(editVehicle.Location_Name.Trim());
liLocation.Selected = true;
bindImages();
bindControls();
}
}
public Boolean updateAVehicle(string connectionString, VehicleObject VehicleObj, int rowIndex)
{
try
{
conn = DBUtility.createConnection(connectionString);
SqlCommand cmdIns = DBUtility.PrepareSPCommand("sp_UpdateVehicle", insertParameters(VehicleObj), conn);
cmdIns.Parameters.Add(new SqlParameter("@Stock_Code", rowIndex));
int rowsUpdated = cmdIns.ExecuteNonQuery();
cmdIns.Dispose();
DBUtility.Close(conn);
conn.Dispose();
if (rowsUpdated > 0)
{
return true;
}
else return false;
}
catch (Exception ex)
{
throw new Exception(ex.ToString(), ex);
}
finally
{
DBUtility.Close(conn);
conn.Dispose();
}
}
public List<SqlParameter> insertParameters(VehicleObject VehicleObj)
{
List<SqlParameter> insertParamsArray = new List<SqlParameter>();
insertParamsArray.Add(new SqlParameter("@Manufacturer_Name", VehicleObj.Manufacturer_Name));
insertParamsArray.Add(new SqlParameter("@Model_Name", VehicleObj.Model_Name));
insertParamsArray.Add(new SqlParameter("@Location_Name", VehicleObj.Location_Name));
insertParamsArray.Add(new SqlParameter("@Supplier_Name", VehicleObj.Supplier_NameProp));
insertParamsArray.Add(new SqlParameter("@Cost_Price", VehicleObj.Cost_Price));
insertParamsArray.Add(new SqlParameter("@Retail_Price", VehicleObj.Retail_Price));
insertParamsArray.Add(new SqlParameter("@Wholesale_Price", VehicleObj.Wholesale_Price));
insertParamsArray.Add(new SqlParameter("@Colour", VehicleObj.Colour));
insertParamsArray.Add(new SqlParameter("@Picture_1", VehicleObj.Picture_1));
insertParamsArray.Add(new SqlParameter("@Picture_2", VehicleObj.Picture_2));
insertParamsArray.Add(new SqlParameter("@Picture_3", VehicleObj.Picture_3));
insertParamsArray.Add(new SqlParameter("@Chassis_Number", VehicleObj.Chassis_Number));
insertParamsArray.Add(new SqlParameter("@Engine_Number", VehicleObj.Engine_Number));
insertParamsArray.Add(new SqlParameter("@Registration_Number", VehicleObj.Registration_Number));
insertParamsArray.Add(new SqlParameter("@Extra_Features", VehicleObj.Extra_Features));
insertParamsArray.Add(new SqlParameter("@Mileage", VehicleObj.Mileage));
insertParamsArray.Add(new SqlParameter("@Automatic_Transmission", VehicleObj.Automatic_Transmission));
insertParamsArray.Add(new SqlParameter("@COR", VehicleObj.COR));
insertParamsArray.Add(new SqlParameter("@AC", VehicleObj.AC));
insertParamsArray.Add(new SqlParameter("@Cl", VehicleObj.CI));
insertParamsArray.Add(new SqlParameter("@PS", VehicleObj.PS));
insertParamsArray.Add(new SqlParameter("@AL", VehicleObj.AL));
insertParamsArray.Add(new SqlParameter("@Leather", VehicleObj.Leather));
insertParamsArray.Add(new SqlParameter("@RT", VehicleObj.RT));
insertParamsArray.Add(new SqlParameter("@CD", VehicleObj.CD));
insertParamsArray.Add(new SqlParameter("@MP3", VehicleObj.MP3));
insertParamsArray.Add(new SqlParameter("@FSH", VehicleObj.FSH));
insertParamsArray.Add(new SqlParameter("@SR", VehicleObj.SR));
insertParamsArray.Add(new SqlParameter("@Sports_Kit", VehicleObj.Sports_Kit));
insertParamsArray.Add(new SqlParameter("@Airbag", VehicleObj.Airbag));
insertParamsArray.Add(new SqlParameter("@Mags", VehicleObj.Mags));
insertParamsArray.Add(new SqlParameter("@Gearlock", VehicleObj.Gearlock));
insertParamsArray.Add(new SqlParameter("@Condition", VehicleObj.Condition));
insertParamsArray.Add(new SqlParameter("@Arrival_Date", VehicleObj.Arrival_Date));
insertParamsArray.Add(new SqlParameter("@Vehicle_Status", VehicleObj.Vehicle_Status));
return insertParamsArray;
}
public bool insert(VehicleObject VehicleObj, string connectionString)
{
try
{
conn = DBUtility.createConnection(connectionString);
SqlCommand cmdIns = DBUtility.PrepareSPCommand("sp_InsertVehicle", insertParameters(VehicleObj), conn);
int rowsUpdated = cmdIns.ExecuteNonQuery();
// cmdIns.Parameters.Clear();
// cmdIns.CommandText = "SELECT @@IDENTITY";
// // Get the last inserted id.
// int insertID = Convert.ToInt32(cmdIns.ExecuteScalar());
cmdIns.Dispose();
DBUtility.Close(conn);
conn.Dispose();
if (rowsUpdated > 0)
{
return true;
}
else return false;
}
catch (Exception ex)
{
throw new Exception(ex.ToString(), ex);
}
finally
{
DBUtility.Close(conn);
conn.Dispose();
}
}
public VehicleObject getVehicleObject(DataTable dtVehicle)
{
VehicleObject vehicle = new VehicleObject();
if (dtVehicle.Rows.Count > 0)
{
DataRow dr = dtVehicle.Rows[0];
vehicle.AC = DBUtility.readDBBool(dr, "AC");
vehicle.Airbag = DBUtility.readDBBool(dr, "Airbag");
vehicle.AL = DBUtility.readDBBool(dr, "AL");
vehicle.Arrival_Date = DBUtility.readDBDate(dr, "Arrival_Date");
vehicle.Automatic_Transmission = DBUtility.readDBBool(dr, "Automatic_Transmission");
vehicle.CD = DBUtility.readDBBool(dr, "CD");
vehicle.Chassis_Number = DBUtility.readDBString(dr, "Chassis_Number");
vehicle.CI = DBUtility.readDBBool(dr, "Cl");
vehicle.Colour = DBUtility.readDBString(dr, "Colour");
vehicle.Condition = DBUtility.readDBString(dr,"Condition");
vehicle.COR = DBUtility.readDBBool(dr, "COR");
vehicle.Cost_Price = DBUtility.readDBDecimal(dr, "Cost_Price");
vehicle.Engine_Number = DBUtility.readDBString(dr, "Engine_Number");
vehicle.Extra_Features = DBUtility.readDBString(dr, "Extra_Features");
vehicle.FSH = DBUtility.readDBBool(dr, "FSH");
vehicle.Gearlock = DBUtility.readDBBool(dr, "Gearlock");
vehicle.Leather = DBUtility.readDBBool(dr, "Leather");
vehicle.Location_Name = DBUtility.readDBString(dr, "Location_Name");
vehicle.Mags = DBUtility.readDBBool(dr, "Mags");
vehicle.Manufacturer_Name = DBUtility.readDBString(dr, "Manufacturer_Name");
vehicle.Mileage = DBUtility.readDBInt(dr,"Mileage");
vehicle.Model_Name = DBUtility.readDBString(dr, "Model_Name");
vehicle.MP3 = DBUtility.readDBBool(dr,"MP3");
vehicle.Picture_1 = DBUtility.readDBImage(dr,"Picture_1");
vehicle.Picture_2 = DBUtility.readDBImage(dr, "Picture_2");
vehicle.Picture_3 = DBUtility.readDBImage(dr, "Picture_3");
vehicle.PS = DBUtility.readDBBool(dr,"PS");
vehicle.Registration_Number = DBUtility.readDBString(dr,"Registration_Number");
vehicle.Retail_Price = DBUtility.readDBDecimal(dr,"Retail_Price");
vehicle.RT = DBUtility.readDBBool(dr,"RT");
vehicle.Sports_Kit = DBUtility.readDBBool(dr,"Sports_Kit");
vehicle.SR = DBUtility.readDBBool(dr, "SR");
vehicle.Supplier_NameProp = DBUtility.readDBString(dr,"Supplier_Name");
vehicle.Vehicle_Status = DBUtility.readDBString(dr,"Vehicle_Status");
vehicle.Wholesale_Price = DBUtility.readDBDecimal(dr,"Wholesale_Price");
}
return vehicle;
}
