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