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 PhysicalExam GetPhyicalExam(DateTime dt, string id) { DAPhyicalExam dap = new DAPhyicalExam(); ListDictionary Params = new ListDictionary(); Params.Add("@date", dt); Params.Add("@id", id); DataSet ds = dap.GetPhyicalExam(Params); PhysicalExam p = new PhysicalExam(); p.PupilsEqualT = BLCtrl.getString(ds.Tables[0].Rows[0], "PupilsEqualT", ""); p.UpdateCode = BLCtrl.getInt(ds.Tables[0].Rows[0], "UpdateCode", 0); p.ApearsWell = BLCtrl.getBool(ds.Tables[0].Rows[0], "ApearsWell", false); p.ApearsWellT = BLCtrl.getString(ds.Tables[0].Rows[0], "ApearsWellT", ""); p.PupilsEqual = BLCtrl.getBool(ds.Tables[0].Rows[0], "PupilsEqual", false); p.TmNormal = BLCtrl.getBool(ds.Tables[0].Rows[0], "TmNormal", false); p.TmNormalT = BLCtrl.getString(ds.Tables[0].Rows[0], "TmNormalT", ""); p.Oropharynx = BLCtrl.getBool(ds.Tables[0].Rows[0], "Oropharynx", false); p.OropharynxT = BLCtrl.getString(ds.Tables[0].Rows[0], "OropharynxT", ""); p.Atraumatic = BLCtrl.getBool(ds.Tables[0].Rows[0], "Atraumatic", false); p.AtraumaticT = BLCtrl.getString(ds.Tables[0].Rows[0], "AtraumaticT", ""); p.HeentMucosa = BLCtrl.getBool(ds.Tables[0].Rows[0], "HeentMucosa", false); p.HeentMucosaT = BLCtrl.getString(ds.Tables[0].Rows[0], "HeentMucosaT", ""); p.Supple = BLCtrl.getBool(ds.Tables[0].Rows[0], "Supple", false); p.SuppleT = BLCtrl.getString(ds.Tables[0].Rows[0], "SuppleT", ""); p.thyromegaly = BLCtrl.getBool(ds.Tables[0].Rows[0], "thyromegaly", false); p.thyromegalyT = BLCtrl.getString(ds.Tables[0].Rows[0], "thyromegalyT", ""); p.HeartsoundsRegular = BLCtrl.getBool(ds.Tables[0].Rows[0], "HeartsoundsRegular", false); p.HeartsoundsRegularT = BLCtrl.getString(ds.Tables[0].Rows[0], "HeartsoundsRegularT", ""); p.Murmur = BLCtrl.getBool(ds.Tables[0].Rows[0], "Murmur", false); p.MurmurT = BLCtrl.getString(ds.Tables[0].Rows[0], "MurmurT", ""); p.GoodAir = BLCtrl.getBool(ds.Tables[0].Rows[0], "GoodAir", false); p.GoodAirT = BLCtrl.getString(ds.Tables[0].Rows[0], "GoodAirT", ""); p.ClearToAuscultation = BLCtrl.getBool(ds.Tables[0].Rows[0], "ClearToAuscultation", false); p.ClearToAuscultationT = BLCtrl.getString(ds.Tables[0].Rows[0], "ClearToAuscultationT", ""); p.SymmetricalBreast = BLCtrl.getBool(ds.Tables[0].Rows[0], "SymmetricalBreast", false); p.SymmetricalBreastT = BLCtrl.getString(ds.Tables[0].Rows[0], "SymmetricalBreastT", ""); p.Palpable = BLCtrl.getBool(ds.Tables[0].Rows[0], "Palpable", false); p.PalpableT = BLCtrl.getString(ds.Tables[0].Rows[0], "PalpableT", ""); p.SkinChanges = BLCtrl.getBool(ds.Tables[0].Rows[0], "SkinChanges", false); p.SkinChangesT = BLCtrl.getString(ds.Tables[0].Rows[0], "SkinChangesT", ""); p.Nipple = BLCtrl.getBool(ds.Tables[0].Rows[0], "Nipple", false); p.NippleT = BLCtrl.getString(ds.Tables[0].Rows[0], "NippleT", ""); p.Axillary = BLCtrl.getBool(ds.Tables[0].Rows[0], "Axillary", false); p.AxillaryT = BLCtrl.getString(ds.Tables[0].Rows[0], "AxillaryT", ""); p.Soft = BLCtrl.getBool(ds.Tables[0].Rows[0], "Soft", false); p.SoftT = BLCtrl.getString(ds.Tables[0].Rows[0], "SoftT", ""); p.Tender = BLCtrl.getBool(ds.Tables[0].Rows[0], "Tender", false); p.TenderT = BLCtrl.getString(ds.Tables[0].Rows[0], "TenderT", ""); p.ABDdescription = BLCtrl.getString(ds.Tables[0].Rows[0], "ABDdescription", ""); p.BowelSounds = BLCtrl.getBool(ds.Tables[0].Rows[0], "BowelSounds", false); p.BowelSoundsT = BLCtrl.getString(ds.Tables[0].Rows[0], "BowelSoundsT", ""); p.RenalArtery = BLCtrl.getBool(ds.Tables[0].Rows[0], "RenalArtery", false); p.RenalArteryT = BLCtrl.getString(ds.Tables[0].Rows[0], "RenalArteryT", ""); p.Masses = BLCtrl.getBool(ds.Tables[0].Rows[0], "Masses", false); p.MassesT = BLCtrl.getString(ds.Tables[0].Rows[0], "MassesT", ""); p.Organomegaly = BLCtrl.getBool(ds.Tables[0].Rows[0], "Organomegaly", false); p.OrganomegalyT = BLCtrl.getString(ds.Tables[0].Rows[0], "OrganomegalyT", ""); p.SkinAbnormalities = BLCtrl.getBool(ds.Tables[0].Rows[0], "SkinAbnormalities", false); p.SkinAbnormalitiesT = BLCtrl.getString(ds.Tables[0].Rows[0], "SkinAbnormalitiesT", ""); p.SignificantScoliosis = BLCtrl.getBool(ds.Tables[0].Rows[0], "SignificantScoliosis", false); p.SignificantScoliosisT = BLCtrl.getString(ds.Tables[0].Rows[0], "SignificantScoliosisT", ""); p.Kyphosis = BLCtrl.getBool(ds.Tables[0].Rows[0], "Kyphosis", false); p.KyphosisT = BLCtrl.getString(ds.Tables[0].Rows[0], "KyphosisT", ""); p.Edema = BLCtrl.getBool(ds.Tables[0].Rows[0], "Edema", false); p.EdemaT = BLCtrl.getString(ds.Tables[0].Rows[0], "EdemaT", ""); p.EXTRash = BLCtrl.getBool(ds.Tables[0].Rows[0], "EXTRash", false); p.EXTRashT = BLCtrl.getString(ds.Tables[0].Rows[0], "EXTRashT", ""); p.Varicosities = BLCtrl.getBool(ds.Tables[0].Rows[0], "Varicosities", false); p.VaricositiesT = BLCtrl.getString(ds.Tables[0].Rows[0], "VaricositiesT", ""); p.Pppx4 = BLCtrl.getBool(ds.Tables[0].Rows[0], "Pppx4", false); p.Pppx4T = BLCtrl.getString(ds.Tables[0].Rows[0], "Pppx4T", ""); p.PedalEdema = BLCtrl.getBool(ds.Tables[0].Rows[0], "PedalEdema", false); p.PedalEdemaT = BLCtrl.getString(ds.Tables[0].Rows[0], "PedalEdemaT", ""); p.Toes = BLCtrl.getBool(ds.Tables[0].Rows[0], "Toes", false); p.ToesT = BLCtrl.getString(ds.Tables[0].Rows[0], "ToesT", ""); p.Pattelar = BLCtrl.getBool(ds.Tables[0].Rows[0], "Pattelar", false); p.PattelarT = BLCtrl.getString(ds.Tables[0].Rows[0], "PattelarT", ""); p.Gait = BLCtrl.getBool(ds.Tables[0].Rows[0], "Gait", false); p.GaitT = BLCtrl.getString(ds.Tables[0].Rows[0], "GaitT", ""); p.Speech = BLCtrl.getBool(ds.Tables[0].Rows[0], "Speech", false); p.SpeechT = BLCtrl.getString(ds.Tables[0].Rows[0], "SpeechT", ""); p.Female = BLCtrl.getBool(ds.Tables[0].Rows[0], "Female", false); p.FemaleT = BLCtrl.getString(ds.Tables[0].Rows[0], "FemaleT", ""); p.PelvicMucosa = BLCtrl.getInt(ds.Tables[0].Rows[0], "PelvicMucosa", 1); p.Kegels = BLCtrl.getInt(ds.Tables[0].Rows[0], "Kegels", 1); p.Cervix = BLCtrl.getString(ds.Tables[0].Rows[0], "Cervix", ""); p.VaginalWalls = BLCtrl.getBool(ds.Tables[0].Rows[0], "VaginalWalls", false); p.VaginalWallsT = BLCtrl.getString(ds.Tables[0].Rows[0], "VaginalWallsT", ""); p.Pap = BLCtrl.getBool(ds.Tables[0].Rows[0], "Pap", false); p.PapT = BLCtrl.getString(ds.Tables[0].Rows[0], "PapT", ""); return(p); }