public static sp_select_vehicleDataTable Select_vehicle_latest_record(string str_reg_no, string str_chassis_no)
{
try
{
using (Vehicle_dsTableAdapters.sp_select_vehicleTableAdapter adapter =
new Vehicle_dsTableAdapters.sp_select_vehicleTableAdapter())
{
sp_select_vehicleDataTable dttable = adapter.GetData(-1, str_reg_no, str_chassis_no);
if (dttable.Rows.Count > 0)
{
// select first row. vehicle id is in descending order so will be latest record
sp_select_vehicleRow query = (from row in dttable
orderby row.vehicle descending
select row).First();
sp_select_vehicleDataTable new_dttable = new sp_select_vehicleDataTable();
new_dttable.ImportRow(query); // insert selected row from linq
return(new_dttable); // return datatable
}
}
}
catch (System.Data.SqlClient.SqlException e)
{
Classes.Class_misc.Display_dataset_error(MethodBase.GetCurrentMethod().DeclaringType.ToString(),
MethodBase.GetCurrentMethod().Name, e.Message);
}
return(new sp_select_vehicleDataTable());
}
/// <summary>
///
/// </summary>
/// <param name="int_vehicle">-1 to select all</param>
/// <returns></returns>
public static sp_select_vehicleDataTable Select_vehicle(int int_vehicle)
{
try
{
using (Vehicle_dsTableAdapters.sp_select_vehicleTableAdapter adapter =
new Vehicle_dsTableAdapters.sp_select_vehicleTableAdapter())
{
return(adapter.GetData(int_vehicle, "", ""));
}
}
catch (System.Data.SqlClient.SqlException e)
{
Classes.Class_misc.Display_dataset_error(MethodBase.GetCurrentMethod().DeclaringType.ToString(),
MethodBase.GetCurrentMethod().Name, e.Message);
}
return(new sp_select_vehicleDataTable());
}
