public List <Medicines> GetAllMedicines(string Id)
{
DAMedicines DAM = new DAMedicines();
ListDictionary Params = new ListDictionary();
Params.Add("@MyId", Id);
DataSet ds = DAM.GetAllMedicines(Params);
Medicines M = new Medicines();
List <Medicines> MyM = new List <Medicines>();
foreach (DataRow item in ds.Tables[0].Rows)
{
M.Code = BLCtrl.getInt(item, "Code", 0);
M.Influens = BLCtrl.getInt(item, "Medicine", 0);
M.Vitamin = BLCtrl.getInt(item, "Vitamin", 0);
M.Active = BLCtrl.getBool(item, "Active", false);
M.GivenKind = BLCtrl.getString(item, "GivenKind", "");
M.Quantity = BLCtrl.getString(item, "Quantity", "");
M.Days = BLCtrl.getInt(item, "Days", 0);
M.GivenOn = BLCtrl.getString(item, "GivenOn", "");
M.Text = BLCtrl.getString(item, "Text", "");
M.By = BLCtrl.getInt(item, "By", 0);
M.PatiantCode = BLCtrl.getString(item, "PatiantCode", "");
MyM.Add(M);
}
return(MyM);
}
public int DeleteMedicines(int Code)
{
DAMedicines DAM = new DAMedicines();
ListDictionary Params = new ListDictionary();
Params.Add("@Code", Code);
int result = DAM.DeleteMedicines(Params);
return(result);
}
public List <string> GetNameMedicine(string Num)
{
DAMedicines DAM = new DAMedicines();
ListDictionary Params = new ListDictionary();
Params.Add("@Num", Num);
DataSet ds = DAM.GetNameMedicine(Params);
string S;
List <string> MyNameMedicine = new List <string>();
S = BLCtrl.getString(ds.Tables[0].Rows[0], "Medicine", "");
MyNameMedicine.Add(S);
return(MyNameMedicine);
}
public List <string> GetNameWorker(string Num)
{
DAMedicines DAM = new DAMedicines();
ListDictionary Params = new ListDictionary();
Params.Add("@Num", Num);
DataSet ds = DAM.GetNameWorker(Params);
string S;
List <string> MyNameWorker = new List <string>();
S = BLCtrl.getString(ds.Tables[0].Rows[0], "LastName" + ' ' + "FirstName", "");
MyNameWorker.Add(S);
return(MyNameWorker);
}
