///<summary>
///Date Created: 09/03/2014
///Created By: Michael Evangelista
///Description: Tag to Vehicle
///======================================
///Date Modified: 06/Jan/2014
///Modified By: Josephine Monteza
///Description: Change Int32 to Int64 for colIDBigint, colTravelReqIDInt and colSeafarerIdInt
///======================================
/// </summary>
public static DataTable TagtoVehicle(Int64 colIDBigint, Int64 colTravelReqIDInt, string colRecordLocatorVarchar,
Int64 colSeafarerIdInt, string colOnOff, int colVehicleVendorIDInt, Int32 colPortAgentVendorIDInt, string colIsCheck, string UserId,
string sDescription, string sFunction, string sFileName)
{
DataTable dt = null;
try
{
dt = VehicleDAL.TagtoVehicle(colIDBigint, colTravelReqIDInt, colRecordLocatorVarchar, colSeafarerIdInt,
colOnOff, colVehicleVendorIDInt, colPortAgentVendorIDInt, colIsCheck, UserId,
sDescription, sFunction, sFileName);
return(dt);
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (dt != null)
{
dt.Dispose();
}
}
}
public static int Save(Vehicle _vehicle)
{
try
{
Vehicle existing = VehicleDAL.FindById(_vehicle.Id);
//Duplicado
if (existing != null && _vehicle.Id != existing.Id)
{
return(-2);
}
if (_vehicle.Id <= 0)
{
return(VehicleDAL.Add(_vehicle));
}
else
{
return(VehicleDAL.Update(_vehicle));
}
}
catch (Exception ex)
{
string message = string.Format("{0}", ex.Message);
return(-1);
}
}
/// <summary>
/// Deletes Record from Database.
/// </summary>
/// <param name="objVehicle">Object containing all data values.</param>
/// <returns>boolean value True if Record is deleted successfully
/// otherwise returns False.</returns>
public static bool Delete(Vehicle objVehicle)
{
bool recDel;
recDel = VehicleDAL.Delete(objVehicle.Dbid);
return(recDel);
}
private void FillMotorizedVehicleDatagridview()
{
VehicleDAL vehicleDAL = new VehicleDAL();
// View the data from datagridview
DataTable dt = vehicleDAL.Select();
dgvMotorizedVehicle.DataSource = dt;
// Sort
DataView dv = dt.DefaultView;
dv.Sort = "vehicle_no";
DataTable sortedDT = dv.ToTable();
// Change Header Name of datagridview
dgvMotorizedVehicle.Columns[0].HeaderText = "id #";
dgvMotorizedVehicle.Columns[1].HeaderText = "Motorized Vehicle";
// Total items id to id number
txtIdMV.Text = txtTotalItemsMV.Text;
// Bring to front groupbox
groupBoxMotorizedVehicle.BringToFront();
}
public static Boolean Delete(IList <int> _ids)
{
IList <Vehicle> _exist = null;
Vehicle v = null;
try
{
foreach (Int32 id in _ids)
{
v = VehicleDAL.FindById(id);
if (v != null)
{
_exist.Add(v);
}
}
if (_exist != null)
{
VehicleDAL.Delete(_exist);
}
return(true);
}
catch (Exception ex)
{
string message = string.Format("{0}", ex.Message);
return(false);
}
}
/// <summary>
/// Author: Marco Abejar
/// Date Created: 10/10/201210
/// Descrption: Get Vehicle Manifest by Vendor
/// =============================================================
/// </summary>
public List <VehicleManifestList> GetVehicleManifestByVendor(DateTime dDate, string sUserID, int iRegionID, int iPortID, int iVehicleID,
int iStartRow, int iMaxRow, Int16 iLoadType, string sOrderBy)
{
VehicleDAL.GetVehicleManifestByVendor(dDate, sUserID, iRegionID, iPortID, iVehicleID,
iStartRow, iMaxRow, iLoadType, sOrderBy);
return((List <VehicleManifestList>)HttpContext.Current.Session["VehiclManifest_ManifestList"]);
}
public static void AddNewVehicle(int ModelID,
string RegistrationNumber,
int CurrentMileage,
int TransmissionID,
int VehicleGroupID,
int FuelID,
string UpdatedBy,
out int returnValue)
{
VehicleDAL.AddNewVehicle(ModelID, RegistrationNumber, CurrentMileage, TransmissionID, VehicleGroupID, FuelID, UpdatedBy, out returnValue);
}
/// <summary>
/// Date Created: 19/07/2011
/// Created By: Gabriel Oquialda
/// (description) Delete seafarer vehicle transaction
/// </summary>
public static void vehicleDeleteBooking(Int32 vehiclePrimaryId, int seqInt, string deletedBy)
{
try
{
VehicleDAL.vehicleDeleteBooking(vehiclePrimaryId, seqInt, deletedBy);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// Date Created: 06/09/2011
/// Created By: Josephine Gad
/// (description) Delete seafarer vehicle transaction (Non-Sabre data)
/// ----------------------------------------
/// </summary>
public static void vehicleDeleteBookingOther(Int32 VehicleBookingID, string DeletedBy)
{
try
{
VehicleDAL.vehicleDeleteBookingOther(VehicleBookingID, DeletedBy);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// Date Created: 02/11/2011
/// Created By: Josephine Gad
/// (description) Delete seafarer pending vehicle transaction
/// ----------------------------------------
/// </summary>
public static void vehicleDeleteBookingPending(string PendingID, string DeletedBy)
{
try
{
VehicleDAL.vehicleDeleteBookingPending(PendingID, DeletedBy);
}
catch (Exception ex)
{
throw ex;
}
}
public static int UpdateVehicle(int VehicleID,
int ModelID,
string RegistrationNumber,
int CurrentMileage,
int TransmissionID,
int VehicleGroupID,
int FuelID,
string UpdatedBy)
{
var result = VehicleDAL.UpdateVehicle(VehicleID, ModelID, RegistrationNumber, CurrentMileage, TransmissionID, VehicleGroupID, FuelID, UpdatedBy);
return(result);
}
/// <summary>
/// Date Created: 06/09/2011
/// Created By: Josephine Gad
/// (description) Get seafarer vehicle transaction (non-Sabre)
/// ------------------------------------------------------------
/// Date Modified: 28/11/2011
/// Modified By: Charlene Remotigue
/// (description) optimization (use datareader instead of datatable
/// </summary>
public static IDataReader vehicleGetTransactionByID(string VehicleBookingIDString)
{
IDataReader dt = null;
try
{
dt = VehicleDAL.vehicleGetTransactionByID(VehicleBookingIDString);
return(dt);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// Date Created: 04/08/2011
/// Created By: Gabriel Oquialda
/// (description) Validate vehicle pick-up date and time
/// </summary>
public static Boolean pickupdatetimeExist(String travelLocatorId, String SeqNo, String branchId, DateTime pickupDate, String pickupTime)
{
Boolean bValidation;
try
{
bValidation = VehicleDAL.pickupdatetimeExist(travelLocatorId, SeqNo, branchId, pickupDate, pickupTime);
return(bValidation);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// Date Created: 19/07/2011
/// Created By: Gabriel Oquialda
/// (description) Get seafarer vehicle transaction
/// -------------------------------------------------
/// Date Modified: 28/11/2011
/// Modified By: Charlene Remotigue
/// (description) optimization (use datareader instead of datatable
/// </summary>
public static IDataReader vehicleGetTransaction(int vehiclePrimaryId, int seqNo)
{
IDataReader dt = null;
try
{
dt = VehicleDAL.vehicleGetTransaction(vehiclePrimaryId, seqNo);
return(dt);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// Date Created: 06/09/2011
/// Created By: Josephine Gad
/// (description) Get seafarer vehicle transaction (non-Sabre)
/// -------------------------------------------------------------
/// Date Modified: 28/11/2011
/// Modified By: Charlene Remotigue
/// (description) optimization (use datareader instead of datatable
/// </summary>
public static IDataReader vehicleGetPendingByID(string PendingVehicleID)
{
IDataReader dt = null;
try
{
dt = VehicleDAL.vehicleGetPendingByID(PendingVehicleID);
return(dt);
}
catch (Exception ex)
{
throw ex;
}
}
public static VehicleViewModel GetVehicleDetails(int VehicleID)
{
var ds = VehicleDAL.GetVehicleDetails(VehicleID);
var model = new VehicleViewModel();
foreach (DataTable dt in ds.Tables)
{
if (dt.Rows.Count == 0)
{
//There was no record found at row zero so we can run on to the next table
continue;
}
var row = dt.Rows[0];
if (row["TableName"].ToString() == Constants.VehicleDataSetManager.Vehicle.ToString())
{
model.ManufacturerID = (int)row["ManufacturerID"];
model.ModelID = (int)row["ModelID"];
model.RegistrationNumber = row["RegistrationNumber"].ToString();
model.TransmissionID = (int)row["TransmissionID"];
model.VehicleGroupID = (int)row["VehicleGroupID"];
model.VehicleID = (int)row["VehicleID"];
model.FuelID = (int)row["FuelID"];
model.CurrentMileage = (int)row["CurrentMileage"];
}
else if (row["TableName"].ToString() == Constants.VehicleDataSetManager.FuelType.ToString())
{
model.VehicleFuelList = PopulateDropDownList(Constants.VehicleDataSetManager.FuelType, dt);
}
else if (row["TableName"].ToString() == Constants.VehicleDataSetManager.Manufacturer.ToString())
{
model.VehicleManufacturerList = PopulateDropDownList(Constants.VehicleDataSetManager.Manufacturer, dt);
}
else if (row["TableName"].ToString() == Constants.VehicleDataSetManager.TransmissionType.ToString())
{
model.VehicleTransmissionList = PopulateDropDownList(Constants.VehicleDataSetManager.TransmissionType, dt);
}
else if (row["TableName"].ToString() == Constants.VehicleDataSetManager.VehicleGroup.ToString())
{
model.VehicleGroupList = PopulateDropDownList(Constants.VehicleDataSetManager.VehicleGroup, dt);
}
else if (row["TableName"].ToString() == Constants.VehicleDataSetManager.VehicleModel.ToString())
{
model.VehicleModelList = PopulateDropDownList(Constants.VehicleDataSetManager.VehicleModel, dt);
}
}
return(model);
}
/// <summary>
/// This Method to use the Fill Vehical Status
/// </summary>
/// <param name="VIN"></param>
/// <returns></returns>
public List <string> VehicalStatusList()
{
try
{
VehicleDAL objVehicleDAL = new VehicleDAL();
return(objVehicleDAL.VehicalStatusList());
}
catch (Exception)
{
throw;
}
finally
{
CommonDAL.logger.LogInfo(typeof(string), string.Format(CultureInfo.InvariantCulture, "End {2} function ::{0} {1}.", DateTime.Now.ToShortDateString(), DateTime.Now.ToShortTimeString(), MethodBase.GetCurrentMethod().Name));
}
}
/// <summary>
/// This Method to Call The Vehical Information By VIN
/// </summary>
/// <param name="VIN"></param>
/// <returns></returns>
public List <VehicleProp> CallVehialDetailsbyVIN(VehicleProp objVehicleProp)
{
try
{
CommonDAL.logger.LogInfo(typeof(string), string.Format(CultureInfo.InvariantCulture, "Called {2} function ::{0} {1}.", DateTime.Now.ToShortDateString(), DateTime.Now.ToShortTimeString(), MethodBase.GetCurrentMethod().Name));
VehicleDAL objVehicleDAL = new VehicleDAL();
return(objVehicleDAL.CallVehialDetailsbyVIN(objVehicleProp));
}
catch (Exception)
{
throw;
}
finally
{
CommonDAL.logger.LogInfo(typeof(string), string.Format(CultureInfo.InvariantCulture, "End {2} function ::{0} {1}.", DateTime.Now.ToShortDateString(), DateTime.Now.ToShortTimeString(), MethodBase.GetCurrentMethod().Name));
}
}
/// <summary>
/// This method is used to delete vehicle details
/// </summary>
/// <param name="VehiclesID"></param>
/// <returns></returns>
public bool DeleteVehicalSearchDetails(int VehiclesID)
{
try
{
CommonDAL.logger.LogInfo(typeof(string), string.Format(CultureInfo.InvariantCulture, "Called {2} function ::{0} {1}.", DateTime.Now.ToShortDateString(), DateTime.Now.ToShortTimeString(), MethodBase.GetCurrentMethod().Name));
VehicleDAL objVehicleDAL = new VehicleDAL();
return(objVehicleDAL.DeleteVehicalSearchDetails(VehiclesID));
}
catch (Exception)
{
throw;
}
finally
{
CommonDAL.logger.LogInfo(typeof(string), string.Format(CultureInfo.InvariantCulture, "End {2} function ::{0} {1}.", DateTime.Now.ToShortDateString(), DateTime.Now.ToShortTimeString(), MethodBase.GetCurrentMethod().Name));
}
}
/// <summary>
/// This Method is for checking duplicate VIN number
/// </summary>
/// <param name="VIN"></param>
/// <returns></returns>
public bool CheckMultipleVIN(string vIN)
{
try
{
VehicleDAL objVehicleDAL = new VehicleDAL();
CommonDAL.logger.LogInfo(typeof(string), string.Format(CultureInfo.InvariantCulture, "Called {2} function ::{0} {1}.", DateTime.Now.ToShortDateString(), DateTime.Now.ToShortTimeString(), MethodBase.GetCurrentMethod().Name));
return(objVehicleDAL.CheckMultipleVIN(vIN));
}
catch (Exception)
{
throw;
}
finally
{
CommonDAL.logger.LogInfo(typeof(string), string.Format(CultureInfo.InvariantCulture, "End {2} function ::{0} {1}.", DateTime.Now.ToShortDateString(), DateTime.Now.ToShortTimeString(), MethodBase.GetCurrentMethod().Name));
}
}
/// <summary>
/// Date Created: 18/07/2011
/// Created By: Gabriel Oquialda
/// (description) Insert vehicle transaction
/// </summary>
public static void vehicleInsertTransaction(string travelLocatorId, Int32 vendorId, Int32 category, Int32 countryID, Int32 cityId,
Int32 branchId, Int32 vehicleBrandId, Int32 vehicleMakeId, Int32 vehicleTypeId, //string vehicleYear, string vehiclePlateNo,
DateTime PickUpDate, string PickUpTime, DateTime DropOffDate, string DropOffTime, string PickUpLocation, string DropOffLocation,
string vehicleStatus, string createdby, string seafarerStatus, string vehicleRemarks, Boolean vehicleBillToCrew, int seafarerId)
{
try
{
VehicleDAL.vehicleInsertTransaction(travelLocatorId, vendorId, category, countryID, cityId, branchId, vehicleBrandId, vehicleMakeId,
vehicleTypeId, //vehicleYear, vehiclePlateNo,
PickUpDate, PickUpTime, DropOffDate, DropOffTime, PickUpLocation, DropOffLocation,
vehicleStatus, createdby, seafarerStatus, vehicleRemarks, vehicleBillToCrew, seafarerId);
}
catch (Exception ex)
{
throw ex;
}
}
public static void vehicleUpdateTransactionOther(Int32 vehicleBookingID, Int32 vendorId, Int32 countryID, Int32 cityId,
Int32 branchId, Int32 vehicleID,
DateTime PickUpDate, string PickUpTime, DateTime DropOffDate, string DropOffTime, string PickUpLocation, string DropOffLocation,
string vehicleStatus, string createdby, string seafarerStatus, string vehicleRemarks, Boolean vehicleBillToCrew)
{
try
{
VehicleDAL.vehicleUpdateTransactionOther(vehicleBookingID, vendorId, countryID, cityId, branchId,
vehicleID,
PickUpDate, PickUpTime, DropOffDate, DropOffTime,
PickUpLocation, DropOffLocation, vehicleStatus, createdby, seafarerStatus, vehicleRemarks, vehicleBillToCrew);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// This Method is for checking duplicate VIN number
/// </summary>
/// <param name="VIN"></param>
/// <returns></returns>
public VINDecodeList GetDecodeDataFromWeb(string vin, string bodyStylep)
{
try
{
CommonDAL.logger.LogInfo(typeof(string), string.Format(CultureInfo.InvariantCulture, "Called {2} function ::{0} {1}.", DateTime.Now.ToShortDateString(), DateTime.Now.ToShortTimeString(), MethodBase.GetCurrentMethod().Name));
VehicleDAL objVehicleDAL = new VehicleDAL();
return(objVehicleDAL.GetDecodeDataFromWeb(vin, bodyStylep));
}
catch (Exception)
{
throw;
}
finally
{
CommonDAL.logger.LogInfo(typeof(string), string.Format(CultureInfo.InvariantCulture, "End {2} function ::{0} {1}.", DateTime.Now.ToShortDateString(), DateTime.Now.ToShortTimeString(), MethodBase.GetCurrentMethod().Name));
}
}
/// <summary>
/// Date Created: 02/11/2011
/// Created By: Josephine Gad
/// (description) Update Pending Vehicle Booking
///-------------------------------------------------------------------------------
/// </summary>
public static void vehicleUpdateTransactionPending(string PendingID, string TransVehicleID, string IDBigint, string SeqNo,
string TravelReqIDString, string RecordLoc, string RequestID, string VendorIDString, string CountryIDString,
string CityIDString, string BranchIDString, string VehicleIDString, string VehiclePlateNoString, string PickUpDate,
string PickUpTime, string DropOffDate, string DropOffTime, string PickUpLocationLocationCode, string DropOffLocationLocationCode,
string VehicleStatusString, string CreatedByString, string ModifiedDate, string SFStatusString, string RemarksString, bool IsBilledToBool, string Action)
{
try
{
VehicleDAL.vehicleUpdateTransactionPending(PendingID, TransVehicleID, IDBigint, SeqNo, TravelReqIDString, RecordLoc, RequestID, VendorIDString,
CountryIDString, CityIDString, BranchIDString, VehicleIDString, VehiclePlateNoString, PickUpDate, PickUpTime,
DropOffDate, DropOffTime, PickUpLocationLocationCode, DropOffLocationLocationCode, VehicleStatusString,
CreatedByString, ModifiedDate, SFStatusString, RemarksString, IsBilledToBool, Action);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// Date Created: 06/09/2011
/// Created By: Josephine Gad
/// (description) Insert vehicle transaction (non Sbare)
/// </summary>
public static void vehicleInsertTransactionOther(string TravelReqIDString, string RecordLoc, string RequestID,
string VendorIDString, string CountryIDString, string CityIDString, string BranchIDString, string VehicleIDString,
string VehiclePlateNoString, string PickUpDate, string PickUpTime, string DropOffDate, string DropOffTime,
string PickUpLocationLocationCode, string DropOffLocationLocationCode, string VehicleStatusString,
string CreatedByString, string SFStatusString, string RemarksString, bool IsBilledToBool)
{
try
{
VehicleDAL.vehicleInsertTransactionOther(TravelReqIDString, RecordLoc, RequestID, VendorIDString, CountryIDString,
CityIDString, BranchIDString, VehicleIDString, VehiclePlateNoString, PickUpDate,
PickUpTime, DropOffDate, DropOffTime, PickUpLocationLocationCode, DropOffLocationLocationCode,
VehicleStatusString, CreatedByString, SFStatusString, RemarksString, IsBilledToBool);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// This Method is for checking duplicate VIN number
/// </summary>
/// <param name="VIN"></param>
/// <returns></returns>
public PortStorageVehicleProp GetDecodedPortStorageVIN(string vin)
{
try
{
CommonDAL.logger.LogInfo(typeof(string), string.Format(CultureInfo.InvariantCulture, "Called {2} function ::{0} {1}.", DateTime.Now.ToShortDateString(), DateTime.Now.ToShortTimeString(), MethodBase.GetCurrentMethod().Name));
VehicleDAL objVehicleDAL = new VehicleDAL();
return(objVehicleDAL.GetDecodedPortStorageVIN(vin));
}
catch (Exception)
{
throw;
}
finally
{
CommonDAL.logger.LogInfo(typeof(string), string.Format(CultureInfo.InvariantCulture, "End {2} function ::{0} {1}.", DateTime.Now.ToShortDateString(), DateTime.Now.ToShortTimeString(), MethodBase.GetCurrentMethod().Name));
}
}
/// <summary>
/// This Method is used to Get Port Storage Processign Details
/// </summary>
/// <param name="objVehicleProp"></param>
/// <returns>List</returns>
/// <createdBy></createdBy>
/// <createdOn>May-7,2016</createdOn>
public List <VehicleProp> GetPortStorageProcessignDetails(string VIN)
{
VehicleDAL objVehicleDAL = new VehicleDAL();
CommonDAL.logger.LogInfo(typeof(string), string.Format(CultureInfo.InvariantCulture, "Called {2} function ::{0} {1}.", DateTime.Now.ToShortDateString(), DateTime.Now.ToShortTimeString(), MethodBase.GetCurrentMethod().Name));
try
{
//Calling and binding the existing user Role.
return(objVehicleDAL.GetPortStorageProcessignDetails(VIN));
}
catch (Exception)
{
throw;
}
finally
{
CommonDAL.logger.LogInfo(typeof(string), string.Format(CultureInfo.InvariantCulture, "End {2} function ::{0} {1}.", DateTime.Now.ToShortDateString(), DateTime.Now.ToShortTimeString(), MethodBase.GetCurrentMethod().Name));
}
}
/// <summary>
/// This method is used to get vehicle detil by VIN number
/// </summary>
/// <param name="VIN"></param>
/// <returns></returns>
public List <VehicleProp> CheckMultipleVecheleDetailByVIN(string VIN)
{
VehicleDAL objVehicleDAL = new VehicleDAL();
CommonDAL.logger.LogInfo(typeof(string), string.Format(CultureInfo.InvariantCulture, "Called {2} function ::{0} {1}.", DateTime.Now.ToShortDateString(), DateTime.Now.ToShortTimeString(), MethodBase.GetCurrentMethod().Name));
try
{
//Calling Decode VIN.
return(objVehicleDAL.CheckMultipleVecheleDetailByVIN(VIN));
}
catch (Exception)
{
throw;
}
finally
{
CommonDAL.logger.LogInfo(typeof(string), string.Format(CultureInfo.InvariantCulture, "End {2} function ::{0} {1}.", DateTime.Now.ToShortDateString(), DateTime.Now.ToShortTimeString(), MethodBase.GetCurrentMethod().Name));
}
}
/// <summary>
/// This method is used to Storage Vehicle Outgate for security.
/// </summary>
/// <param name="objStorageVehicleOutgateProp"></param>
/// <returns></returns>
/// <createdBy></createdBy>
/// <createdOn>July 7, 2016</createdOn>
public StorageVehicleOutgateProp UpdateStorageVehicleOutgateData(StorageVehicleOutgateProp objStorageVehicleOutgateProp)
{
VehicleDAL objVehicleDAL = new VehicleDAL();
CommonDAL.logger.LogInfo(typeof(string), string.Format(CultureInfo.InvariantCulture, "Called {2} function ::{0} {1}.", DateTime.Now.ToShortDateString(), DateTime.Now.ToShortTimeString(), MethodBase.GetCurrentMethod().Name));
try
{
//Calling Insert PortStorage Vehicle Outgate Details Method.
return(objVehicleDAL.UpdateStorageVehicleOutgateData(objStorageVehicleOutgateProp));
}
catch (Exception)
{
throw;
}
finally
{
CommonDAL.logger.LogInfo(typeof(string), string.Format(CultureInfo.InvariantCulture, "End {2} function ::{0} {1}.", DateTime.Now.ToShortDateString(), DateTime.Now.ToShortTimeString(), MethodBase.GetCurrentMethod().Name));
}
}
/// <summary>
/// Date Created: 18/07/2011
/// Created By: Gabriel Oquialda
/// (description) Update vehicle transaction
/// ----------------------------------------------------------------------------
/// Date Modified: 06/09/2011
/// Modified By: Josephine Gad
/// (description) Remove Brand,Make,Year and vehicle Type and change to vehicleID
/// </summary>
public static void vehicleUpdateTransaction(Int32 vehiclePrimaryId, Int32 seqNo, Int32 vendorId, Int32 countryID,
Int32 cityId, Int32 branchId,
//Int32 vehicleBrandId, Int32 vehicleMakeId, Int32 vehicleTypeId, //string vehicleYear, string vehiclePlateNo,
Int32 vehicleID,
DateTime PickUpDate, string PickUpTime, DateTime DropOffDate, string DropOffTime, string PickUpLocation, string DropOffLocation,
string vehicleStatus, string createdby, string seafarerStatus, string vehicleRemarks, Boolean vehicleBillToCrew)
{
try
{
VehicleDAL.vehicleUpdateTransaction(vehiclePrimaryId, seqNo, vendorId, countryID, cityId, branchId,
//vehicleBrandId, vehicleMakeId, vehicleTypeId, //vehicleYear, vehiclePlateNo,
vehicleID,
PickUpDate, PickUpTime, DropOffDate, DropOffTime,
PickUpLocation, DropOffLocation, vehicleStatus, createdby, seafarerStatus, vehicleRemarks, vehicleBillToCrew);
}
catch (Exception ex)
{
throw ex;
}
}
public static DataTable GetCarByID(object[] param)
{
VehicleDAL obj = new VehicleDAL();
return obj.GetCarByID(param);
}
/// <summary>
/// 车辆使用查询
/// </summary>
/// <param name="param"></param>
/// <returns></returns>
public static DataTable SearchVehicle(object[] param)
{
VehicleDAL obj = new VehicleDAL();
return obj.SearchVehicle(param);
}
public static string UpdateCar(object[] param)
{
VehicleDAL obj = new VehicleDAL();
return obj.UpdateCar(param, "exit");
}
public static DataTable GetVehicleByDate(object[] param)
{
VehicleDAL obj = new VehicleDAL();
return obj.GetVehicleByDate(param);
}
public static string InsertVehicle(object[] param)
{
VehicleDAL obj = new VehicleDAL();
return obj.InsertVehicle(param, "exit");
}
