public static List <SubjectMedicationModel> LoadSubjectMedication(int subjectId)
{
SubjectMedicationModel data = new SubjectMedicationModel
{
MedicationId = 0,
Quantity = 0,
SubjectId = subjectId
};
string sql = @"select MedicationId, Quantity, SubjectId, SiteId
from dbo.SubjectsInventory
where SubjectId = @SubjectId;";
return(SqlDataAccess.LoadSpecificData <SubjectMedicationModel>(sql, data));
}
public static int AddSubjectMedication(int medicationId, int quantity, int subjectId, int siteId)
{
SubjectMedicationModel data = new SubjectMedicationModel
{
MedicationId = medicationId,
Quantity = quantity,
SubjectId = subjectId,
SiteId = siteId
};
string sql = @"insert into dbo.SubjectsInventory (MedicationId, Quantity, SubjectId, SiteId)
values (@MedicationId, @Quantity, @SubjectId, @SiteId);";
return(SqlDataAccess.SaveData(sql, data));
}
public static int UpdateSubjectMedicationQuantity(int medicationId, int quantity, int subjectId)
{
SubjectMedicationModel data = new SubjectMedicationModel
{
MedicationId = medicationId,
Quantity = quantity,
SubjectId = subjectId
};
string sql = @"update dbo.SubjectsInventory
set Quantity = Quantity + @Quantity
where MedicationId = @MedicationId
and SubjectId = @SubjectId;";
return(SqlDataAccess.SaveData(sql, data));
}
