public static int AddSiteMedication(int medicationId, int quantity, int siteId)
{
SiteMedicationModel data = new SiteMedicationModel
{
MedicationId = medicationId,
Quantity = quantity,
SiteId = siteId
};
string sql = @"insert into dbo.SitesInventory (medicationId, quantity, siteId)
values (@medicationId, @quantity, @siteId);";
return(SqlDataAccess.SaveData(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));
}
public static int DecreaseSiteMedicationQuantity(int medicationId, int quantity, int siteId)
{
SiteMedicationModel data = new SiteMedicationModel
{
MedicationId = medicationId,
Quantity = quantity,
SiteId = siteId
};
string sql = @"update dbo.SitesInventory
set Quantity = Quantity - @Quantity
where MedicationId = @MedicationId
and SiteId = @SiteId;";
return(SqlDataAccess.SaveData(sql, data));
}
