public async Task SaveOrUpdateRouteAsync(Route route)
{
try
{
DataTable dt = new DataTable();
dt.Columns.Add("CheckPointID", typeof(int));
dt.Columns.Add("EstimatedKM", typeof(decimal));
dt.Columns.Add("EstimatedArrivalMinutes", typeof(int));
foreach (var checkPoint in route.CheckPoints)
{
var dr = dt.NewRow();
dr["CheckPointID"] = checkPoint.CheckPointID;
dr["EstimatedKM"] = checkPoint.EstimatedKM;
dr["EstimatedArrivalMinutes"] = checkPoint.EstimatedArrivalMinutes;
dt.Rows.Add(dr);
}
await _dao.ExecuteNonQueryAsync("[usp_SaveOrUpdateRoute]", CommandType.StoredProcedure, args =>
{
args.Add("@RouteID", route.RouteID);
args.Add("@RouteName", route.RouteName);
args.Add("@TotalKM", route.TotalKM);
args.Add("@CreatedBy", route.CreatedBy);
args.Add("@CheckPoints", dt);
});
}
catch (Exception)
{
throw;
}
}
public async Task SaveOrUpdateVehicle(Vehicle vehicle)
{
try
{
await _dao.ExecuteNonQueryAsync("usp_SaveOrUpdateVehicle", CommandType.StoredProcedure, args =>
{
args.Add("@VehicleID", vehicle.VehicleID);
args.Add("@VehicleNo", vehicle.VehicleNo);
args.Add("@ModelNo", vehicle.ModelNo);
args.Add("@Color", vehicle.Color);
args.Add("@PassengerCapacity", vehicle.PassengerCapacity);
args.Add("@CubicCapacity", vehicle.CubicCapacity);
args.Add("@PurchasedDate", vehicle.PurchasedDate);
args.Add("@OwnerName", vehicle.OwnerName);
args.Add("@OwnerContact", vehicle.OwnerContact);
args.Add("@OwnerAddress", vehicle.OwnerAddress);
args.Add("@DriverName", vehicle.DriverName);
args.Add("@DriverContact", vehicle.DriverContact);
args.Add("@DriverAdddress", vehicle.DriverAdddress);
args.Add("@CreatedBy", vehicle.CreatedBy);
});
}
catch (Exception)
{
throw;
}
}
public async Task SaveOrUpdateCheckPoint(CheckPoint checkPoint)
{
try
{
await _dao.ExecuteNonQueryAsync("[usp_SaveOrUpdateCheckPoints]", CommandType.StoredProcedure, args =>
{
args.Add("@CheckPointID", checkPoint.CheckPointID);
args.Add("@CheckPointName", checkPoint.CheckPointName);
args.Add("@CreatedBy", checkPoint.CreatedBy);
});
}
catch (Exception)
{
throw;
}
}
public async Task SaveOrUpdateUserAsync(User user)
{
try
{
await _dao.ExecuteNonQueryAsync("[usp_SaveOrUpdateUser]", CommandType.StoredProcedure, args =>
{
args.Add("@UserID", user.UserID);
args.Add("@UserName", user.UserName);
args.Add("@Password", user.Password);
args.Add("@FullName", user.FullName);
args.Add("@UserRoleID", user.UserRoleID);
args.Add("@Contact", user.Contact);
args.Add("@Email", user.Email);
args.Add("@Address", user.Address);
args.Add("@VehicleID", user.VehicleID);
args.Add("@CreatedBy", user.CreatedBy);
});
}
catch (Exception)
{
throw;
}
}
public async Task DeleteTripAsync(Transaction transaction)
{
try
{
await _dao.ExecuteNonQueryAsync("[usp_DeleteTransactions]", CommandType.StoredProcedure, args =>
{
args.Add("@TrasactionID", transaction.TrasactionID);
args.Add("@DeletedBy", transaction.CreatedBy);
});
}
catch (Exception)
{
throw;
}
}
