public static List <DepotModel> LoadDepotMedication(int id)
{
DepotModel data = new DepotModel
{
MedicationId = id,
Quantity = 0
};
string sql = @"select MedicationId, Quantity
from dbo.Depot
where MedicationId = @MedicationId;";
return(SqlDataAccess.LoadSpecificData <DepotModel>(sql, data));
}
public static List <SiteMedicationModel> LoadSiteMedication(int siteId)
{
SiteMedicationModel data = new SiteMedicationModel
{
MedicationId = 0,
Quantity = 0,
SiteId = siteId
};
string sql = @"select MedicationId, Quantity, SiteId
from dbo.SitesInventory
where SiteId = @SiteId;";
return(SqlDataAccess.LoadSpecificData <SiteMedicationModel>(sql, data));
}