public List <Medicines> Draw_GivenKind() { DAL_AddMedicineVitaminAndSensitivities dm = new DAL_AddMedicineVitaminAndSensitivities(); ListDictionary Params = new ListDictionary(); DataSet ds = dm.Draw_GivenKind(Params); List <Medicines> lg = new List <Medicines>(); Medicines g; foreach (DataRow item in ds.Tables[0].Rows) { g = new Medicines(); g.Influens = item.Field <int>("Medicine"); lg.Add(g); } return(lg); }
public List <Vitamins> Draw_Vitamin() { DAL_AddMedicineVitaminAndSensitivities dm = new DAL_AddMedicineVitaminAndSensitivities(); ListDictionary Params = new ListDictionary(); DataSet ds = dm.Draw_Medicine(Params); List <Vitamins> lv = new List <Vitamins>(); Vitamins v; foreach (DataRow item in ds.Tables[0].Rows) { v = new Vitamins(); v.Vitamin = item.Field <string>("Vitamin"); lv.Add(v); } return(lv); }
public int Update_Sensitivities(int Sensitivity, int Medicine, string Influensse, DateTime DesicionDate, string Desided) { DAL_AddMedicineVitaminAndSensitivities dm = new DAL_AddMedicineVitaminAndSensitivities(); ListDictionary Params = new ListDictionary(); Params.Add("@Sensitivity", BLCtrl.sendInt("Sensitivity", 0)); Params.Add("@Medicine", BLCtrl.sendInt("Medicine", 0)); Params.Add("@Influensse", BLCtrl.sendString("Influensse", "")); Params.Add("@DesicionDate", BLCtrl.sendDateTime("DesicionDate", new DateTime(01 / 01 / 2018))); Params.Add("@Desided", BLCtrl.sendString("Desided", "")); int result = dm.Update_Sensitivities(Params); return(result); }
public List <Medicines> Draw_Influenss() { DAL_AddMedicineVitaminAndSensitivities dm = new DAL_AddMedicineVitaminAndSensitivities(); ListDictionary Params = new ListDictionary(); DataSet ds = dm.Draw_Influenss(Params); List <Medicines> li = new List <Medicines>(); Medicines i; foreach (DataRow item in ds.Tables[0].Rows) { i = new Medicines(); i.Influens = item.Field <int>("Influens"); li.Add(i); } return(li); }
public List <MedicinesKind> Draw_MedicineSS() { DAL_AddMedicineVitaminAndSensitivities dm = new DAL_AddMedicineVitaminAndSensitivities(); ListDictionary Params = new ListDictionary(); DataSet ds = dm.Draw_MedicineSS(Params); List <MedicinesKind> lm = new List <MedicinesKind>(); MedicinesKind m; foreach (DataRow item in ds.Tables[0].Rows) { m = new MedicinesKind(); m.Medicine = item.Field <string>("Medicine"); lm.Add(m); } return(lm); }
//public int Update_MedicineVitamin(int Medicine, int Vitamin, bool Active, string GivenKind, string Quantity, int Days, string GivenOn, string Text) //{ // DAL_AddMedicineVitaminAndSensitivities dm = new DAL_AddMedicineVitaminAndSensitivities(); // ListDictionary Params = new ListDictionary(); // Params.Add("@Medicine", BLCtrl.sendInt("Medicine", 0)); // Params.Add("@Vitamin", BLCtrl.sendInt("Vitamin", 0)); // Params.Add("@Active", BLCtrl.sendBool("Active", false)); // Params.Add("@GivenKind", BLCtrl.sendString("GivenKind", "")); // Params.Add("@Quantity", BLCtrl.sendString("Quantity", "")); // Params.Add("@Days", BLCtrl.sendInt("Days", 0)); // Params.Add("@GivenOn", BLCtrl.sendString("GivenOn", "")); // Params.Add("@Text", BLCtrl.sendString("Text", "")); // int result = dm.Update_MedicineVitamin(Params); // return result; //} //public List<GivenKind> Print_ReceiptMV() //{ // DAL_AddMedicineVitaminAndSensitivities dm = new DAL_AddMedicineVitaminAndSensitivities(); // ListDictionary Params = new ListDictionary(); // DataSet ds = dm.Print_ReceiptMV(Params); // List<GivenKind> lg = new List<GivenKind>(); // GivenKind g; // foreach (DataRow item in ds.Tables[0].Rows) // { // g = new GivenKind(); // g.GivenKind = item.Field<int>("GivenKind"); // lg.Add(g); // } // return lg; //} public List <Sensitivitieskinds> Draw_KindSS() { DAL_AddMedicineVitaminAndSensitivities dm = new DAL_AddMedicineVitaminAndSensitivities(); ListDictionary Params = new ListDictionary(); DataSet ds = dm.Draw_KindSS(Params); List <Sensitivitieskinds> ls = new List <Sensitivitieskinds>(); Sensitivitieskinds s; foreach (DataRow item in ds.Tables[0].Rows) { s = new Sensitivitieskinds(); s.Sensitivity = item.Field <string>("Sensitivity"); ls.Add(s); } return(ls); }
public int Add_MedicineVitamin(int Medicine, int Vitamin, bool Active, string GivenKind, string Quantity, int Days, string GivenOn, string Text) { DAL_AddMedicineVitaminAndSensitivities dm = new DAL_AddMedicineVitaminAndSensitivities(); ListDictionary Params = new ListDictionary(); Params.Add("@Medicine", BLCtrl.sendInt("Medicine", 0)); Params.Add("@Vitamin", BLCtrl.sendInt("Vitamin", 0)); Params.Add("@Active", BLCtrl.sendBool("Active", false)); Params.Add("@GivenKind", BLCtrl.sendString("GivenKind", "")); Params.Add("@Quantity", BLCtrl.sendString("Quantity", "")); Params.Add("@Days", BLCtrl.sendInt("Days", 0)); Params.Add("@GivenOn", BLCtrl.sendString("GivenOn", "")); Params.Add("@Text", BLCtrl.sendString("Text", "")); int result = dm.Add_MedicineVitamin(Params); return(result); }