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()); }