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