public Vehicle GetCustomerVehicle(int UserID, string CustomerID)
{
_userid = UserID;
_customerid = CustomerID;
DataTable dt;
dt = DABase.Instance.ExecSP(cn_spGetCustomerVehicle,
DABase.Instance.Parameter(cn_pmUserID, _userid),
DABase.Instance.Parameter(cn_pmCustomerID, _customerid));
Vehicle vehicle = new Vehicle(_userid);
foreach (DataRow dr in dt.Rows)
{
vehicle = new Vehicle(dr);
}
dt = DABase.Instance.ExecSP(cn_spGetCustomerVehicleServicePackage,
DABase.Instance.Parameter(cn_pmUserID, _userid),
DABase.Instance.Parameter(cn_pmCustomerID, _customerid),
DABase.Instance.Parameter(cn_pmVehicleID, vehicle._vehicleid));
CustomerServicePackage customervehicleservicepackage = new CustomerServicePackage();
foreach (DataRow dr in dt.Rows)
{
customervehicleservicepackage = new CustomerServicePackage(dr);
this._customervehicleservicepackage = customervehicleservicepackage;
}
return(vehicle);
}
/// <summary>
/// Private method used to populate new BO
/// </summary>
private void Populate(DataRow dr)
{
this._vehicleid = dr[cn_fVehicleID].ToString();
this._trackingid = dr[cn_fTrackingID].ToString();
this._customerid = dr[cn_fCustomerID].ToString();
this._year = dr[cn_fYear].ToString();
this._make = dr[cn_fMake].ToString();
this._model = dr[cn_fModel].ToString();
this._color = dr[cn_fColor].ToString();
this._trim = dr[cn_fTrim].ToString();
this._condition = dr[cn_fCondition].ToString();
this._mileage = Convert.ToInt32(dr[cn_fMileage].ToString());
this._vinumber = dr[cn_fVINumber].ToString();
this._note = dr[cn_fNote].ToString();
DataTable dt;
dt = DABase.Instance.ExecSP(cn_spGetCustomerVehicleServicePackage,
DABase.Instance.Parameter(cn_pmUserID, _userid),
DABase.Instance.Parameter(cn_pmCustomerID, _customerid),
DABase.Instance.Parameter(cn_pmVehicleID, this._vehicleid));
CustomerServicePackage customervehicleservicepackage = new CustomerServicePackage();
foreach (DataRow servicepackage in dt.Rows)
{
customervehicleservicepackage = new CustomerServicePackage(servicepackage);
this._customervehicleservicepackage = customervehicleservicepackage;
}
// Reset the state to unchanged
this.SetEntityState(EntityStateType.Unchanged);
}
public CustomerServicePackage GetCustomerVehicleServicePackage(int UserID, string CustomerID, string VehicleID)
{
this._userid = UserID;
this._customerid = CustomerID;
this._vehicleid = VehicleID;
DataTable dt;
dt = DABase.Instance.ExecSP(cn_spGet,
DABase.Instance.Parameter(cn_pmUserID, _userid),
DABase.Instance.Parameter(cn_pmCustomerID, _customerid),
DABase.Instance.Parameter(cn_pmVehicleID, _vehicleid));
CustomerServicePackage customerservicepackage = new CustomerServicePackage();
foreach (DataRow dr in dt.Rows)
{
customerservicepackage = new CustomerServicePackage(dr);
}
this._servicepackageid = customerservicepackage.ServicePackageID;
dt = DABase.Instance.ExecSP(cn_spGetDetails,
DABase.Instance.Parameter(cn_pmUserID, _userid),
DABase.Instance.Parameter(cn_pmCustomerID, _customerid),
DABase.Instance.Parameter(cn_pmVehicleID, _vehicleid),
DABase.Instance.Parameter(cn_pnServicePackageID, _servicepackageid));
CustomerServicePackageDetail customerservicepackagedetail = new CustomerServicePackageDetail();
foreach (DataRow dr in dt.Rows)
{
customerservicepackagedetail = new CustomerServicePackageDetail(dr);
this._customerservicepackagedetails.Add(customerservicepackagedetail);
}
return(customerservicepackage);
}
