public async Task <DataTable> AuthenticateUserAsync(User user) { try { return(await _dao.GetDataTableAsync("[usp_AuthenticateUser]", CommandType.StoredProcedure, args => { args.Add("UserName", user.UserName); args.Add("Password", user.Password); })); } catch (Exception) { throw; } }
public async Task <DataTable> SaveTripInfoAsync(Transaction transaction) { try { return(await _dao.GetDataTableAsync("[usp_SaveTransactions]", CommandType.StoredProcedure, args => { args.Add("@TrasactionID", transaction.TrasactionID); args.Add("@VehicleID", transaction.VehicleID); args.Add("@RouteID", transaction.RouteID); args.Add("@CreatedBy", transaction.CreatedBy); })); } catch (Exception) { throw; } }
public async Task <DataTable> GetRoutesAsync(int?routeId = null) { try { return(await _dao.GetDataTableAsync("[usp_GetRoutes]", CommandType.StoredProcedure, args => { args.Add("@RouteID", routeId); })); } catch (Exception) { throw; } }
public async Task <DataTable> GetCheckPoint(int?checkPointId = null) { try { return(await _dao.GetDataTableAsync("[usp_GetCheckPoints]", CommandType.StoredProcedure, args => { args.Add("@CheckPointID", checkPointId); })); } catch (Exception) { throw; } }
public async Task <DataTable> GetVehiclesAsync(int?vehicleId = null) { try { return(await _dao.GetDataTableAsync("usp_GetVehicles", CommandType.StoredProcedure, args => { args.Add("@VehicleID", vehicleId); })); } catch (Exception) { throw; } }
public async Task <DataTable> GetSelectOptions(SelectOption selectOption) { try { var query = string.Format(@"SELECT {0},{1} FROM {2}", selectOption.TextField, selectOption.ValueField, selectOption.TableName); if (!string.IsNullOrWhiteSpace(selectOption.Condition)) { query += $" WHERE { selectOption.Condition }"; } if (!string.IsNullOrWhiteSpace(selectOption.OrderBy)) { query += $" ORDER BY { selectOption.OrderBy }"; } return(await _dao.GetDataTableAsync(query, CommandType.Text, args => { })); } catch (Exception) { throw; } }