public bool UpdateVehicle(Vehicle_ML ml)
{
try
{
var DataDic = new Dictionary<string, object>
{
{"@Id", ml.VehicleID},
{"@VehicleTypeID", ml.VehicleTypeID},
{"@ManufactureId",ml.ManufactureId},
{"@Model",ml.Model},
{"@MakeYear",ml.MakeYear},
{"@FuelType", ml.FuelType},
{"@EngineCpacity",ml.EngineCpacity},
{"@seatingCapacity",ml.seatingCapacity},
{"@CarryingCapacity",ml.CarryingCapacity},
{"@PresentValue", ml.PresentValue},
{"@DutyFreeValue",ml.DutyFreeValue}
};
return new DBAccessController().UpdateRecord(StoredProcedures.sp_UpdateVehicle, DataDic);
}
catch (Exception)
{
throw;
}
}
public bool DeleteVehicle(Vehicle_ML ml)
{
try
{
var DataDic = new Dictionary<string, object>
{
{"@Id", ml.VehicleID}
};
return new DBAccessController().DeleteRecord(StoredProcedures.sp_RemoveVehicle, DataDic);
}
catch (Exception)
{
throw;
}
}
public DataTable GetVehicles(Vehicle_ML ml)
{
try
{
var DataDic = new Dictionary<string, object>
{
{"@VehicleTypeName", ml.VehicleTypeName},
{"@ManufactureName", ml.ManufactureName},
{"@Model", ml.Model},
{"@MakeYear", ml.MakeYear}
};
return new DBAccessController().RetriveRecordsWithPara(StoredProcedures.sp_GetVehicle, DataDic);
}
catch (Exception)
{
throw;
}
}
private void GetVehicles()
{
try
{
var ml = new Vehicle_ML()
{
VehicleTypeName = string.IsNullOrEmpty(ddlType.SelectedItem.Text) ? "" : ddlType.SelectedItem.Text,
ManufactureName = string.IsNullOrEmpty(ddlmanufacturer.SelectedItem.Text) ? "" : ddlmanufacturer.SelectedItem.Text,
Model = string.IsNullOrEmpty(ddlModel.SelectedItem.Text) ? "" : ddlModel.SelectedItem.Text,
MakeYear = ""
};
gridVehicles.DataSource = new Vehicle_BL().GetVehicles(ml);
gridVehicles.DataBind();
}
catch (Exception)
{
throw;
}
}
protected void btnSave_ServerClick(object sender, EventArgs e)
{
try
{
var ml = new Vehicle_ML(
"0",
ddlType.SelectedValue.ToString(),
ddlmanufacturer.SelectedValue.ToString(),
txtModel.Value,
txtYear.Value,
ddlFuel.SelectedValue.ToString(),
txtEngineCapacity.Value,
txtSeatCapacity.Value,
txtCarryCapacity.Value,
txtPresentVal.Value,
txtDutyFreeVal.Value
);
new Vehicle_BL().AddVehicle(ml);
GetVehicles();
}
catch (Exception)
{
throw;
}
}
private void GetVehicles()
{
try
{
var ml = new Vehicle_ML()
{
VehicleTypeName = string.IsNullOrEmpty(txtTypeSearch.Text) ? "" : txtTypeSearch.Text,
ManufactureName = string.IsNullOrEmpty(txtManufactureSearch.Text) ? "" : txtManufactureSearch.Text,
Model = string.IsNullOrEmpty(txtModelSearch.Text) ? "" : txtModelSearch.Text,
MakeYear = string.IsNullOrEmpty(txtYearSearch.Text) ? "" : txtYearSearch.Text
};
gridVehicle.DataSource = new Vehicle_BL().GetVehicles(ml);
gridVehicle.DataBind();
}
catch (Exception)
{
throw;
}
}
protected void btnDelete_ServerClick(object sender, EventArgs e)
{
try
{
var ml = new Vehicle_ML() { VehicleID=Convert.ToInt32(gridVehicle.GetSelectedFieldValues("VehicleID")[0])};
new Vehicle_BL().DeleteVehicle(ml);
GetVehicles();
}
catch (Exception)
{
throw;
}
}
protected void btnUpdate_ServerClick(object sender, EventArgs e)
{
try
{
var f = ddlType.SelectedValue;
var hj = ddlType.SelectedItem;
var ml = new Vehicle_ML(
gridVehicle.GetSelectedFieldValues("VehicleID")[0].ToString(),
ddlType.SelectedValue.ToString(),
ddlmanufacturer.SelectedValue.ToString(),
txtModel.Value,
txtYear.Value,
ddlFuel.SelectedValue.ToString(),
txtEngineCapacity.Value,
txtSeatCapacity.Value,
txtCarryCapacity.Value,
txtPresentVal.Value,
txtDutyFreeVal.Value
);
new Vehicle_BL().UpdateVehicle(ml);
GetVehicles();
}
catch (Exception)
{
throw;
}
}
