public List <LifeStyle> getLifeStyleNutritionistById(string id) { DALifeStyleNutritionist dm = new DALifeStyleNutritionist(); ListDictionary Params = new ListDictionary(); Params.Add("@id", id); DataSet ds = dm.getLifeStyleNutritionist(Params); LifeStyle p = new LifeStyle(); List <LifeStyle> l = new List <LifeStyle>(); foreach (DataRow item in ds.Tables[0].Rows) { p = new LifeStyle(); p.UpdateCode = BLCtrl.getInt(item, "UpdateCode", 0); p.Height = BLCtrl.getFloat(item, "Height", 0); p.Wieght = BLCtrl.getFloat(item, "Wheight", 0); p.BMI = BLCtrl.getInt(item, "BMI", 0); p.BloodPressure = BLCtrl.getString(item, "BloodPressure", ""); p.pulse = BLCtrl.getInt(item, "Pulse", 0); p.NotEat = BLCtrl.getBool(item, "NotEat", false); p.NotEatT = BLCtrl.getString(item, "NotEatT", ""); p.Meals = BLCtrl.getInt(item, "Meals", 0); p.Fruits = BLCtrl.getInt(item, "Fruits", 0); p.Vegetables = BLCtrl.getInt(item, "Vegetables", 0); p.Dairy = BLCtrl.getBool(item, "Dairy", false); p.Water = BLCtrl.getInt(item, "Water", 0); p.Diet = BLCtrl.getBool(item, "Diet", false); p.DietT = BLCtrl.getString(item, "DietT", ""); p.SleepingHours = BLCtrl.getFloat(item, "SleepingHours", 0); p.Activity = BLCtrl.getBool(item, "Activity", false); l.Add(p); } return(l); }
public LifeStyle getLifeStyleNutritionist(string id, DateTime date) { DALifeStyleNutritionist dm = new DALifeStyleNutritionist(); ListDictionary Params = new ListDictionary(); Params.Add("@id", BLCtrl.sendString(id, "")); Params.Add("@date", BLCtrl.sendDateTime(date, DateTime.Today)); DataSet ds = dm.getLifeStyleNutritionist(Params); LifeStyle p = new LifeStyle(); //p.UpdateCode = ds.Tables[0].Rows[0].Field<int>( "UpdateCode", 0); //p.UpdateCode = BLCtrl.getFloat(ds.Tables[0].Rows[0], "UpdateCode", 0); p.UpdateCode = BLCtrl.getInt(ds.Tables[0].Rows[0], "UpdateCode", 0); p.Height = BLCtrl.getFloat(ds.Tables[0].Rows[0], "Height", 0); p.Wieght = BLCtrl.getFloat(ds.Tables[0].Rows[0], "Wheight", 0); p.BMI = BLCtrl.getInt(ds.Tables[0].Rows[0], "BMI", 0); p.BloodPressure = BLCtrl.getString(ds.Tables[0].Rows[0], "BloodPressure", ""); p.pulse = BLCtrl.getInt(ds.Tables[0].Rows[0], "Pulse", 0); p.NotEat = BLCtrl.getBool(ds.Tables[0].Rows[0], "NotEat", false); p.NotEatT = BLCtrl.getString(ds.Tables[0].Rows[0], "NotEatT", ""); p.Meals = BLCtrl.getInt(ds.Tables[0].Rows[0], "Meals", 0); p.Fruits = BLCtrl.getInt(ds.Tables[0].Rows[0], "Fruits", 0); p.Vegetables = BLCtrl.getInt(ds.Tables[0].Rows[0], "Vegetables", 0); p.Dairy = BLCtrl.getBool(ds.Tables[0].Rows[0], "Dairy", false); p.Water = BLCtrl.getInt(ds.Tables[0].Rows[0], "Water", 0); p.Diet = BLCtrl.getBool(ds.Tables[0].Rows[0], "Diet", false); p.DietT = BLCtrl.getString(ds.Tables[0].Rows[0], "DietT", ""); p.SleepingHours = BLCtrl.getFloat(ds.Tables[0].Rows[0], "SleepingHours", 0); p.Activity = BLCtrl.getBool(ds.Tables[0].Rows[0], "Activity", false); return(p); }
public List <PastGenicology> getPastGeniclogiById(string id) { DAPastGenicology da = new DAPastGenicology(); ListDictionary Params = new ListDictionary(); Params.Add("@id", id); DataSet ds = da.getPastGeniclogiById(Params); PastGenicology pg = new PastGenicology(); List <PastGenicology> pgl = new List <PastGenicology>(); foreach (DataRow item in ds.Tables[0].Rows) { pg = new PastGenicology(); pg.UpdateCode = BLCtrl.getInt(item, "UpdateCode", 0); pg.AgeOfMenarche = BLCtrl.getInt(item, "AgeOfMenarche", 18); pg.CycleRegular = BLCtrl.getBool(item, "CycleRegular", true); pg.CycleRegularT = BLCtrl.getString(item, "CycleRegularT", ""); pg.MenstrualSyptoms = BLCtrl.getBool(item, "MenstrualSyptoms", false); pg.MenstrualSyptomsT = BLCtrl.getString(item, "MenstrualSyptomsT", ""); pg.MenopauseSyptoms = BLCtrl.getBool(item, "MenopauseSyptoms", false); pg.MenopauseSyptomsT = BLCtrl.getString(item, "MenopauseSyptoms", ""); pg.Contraception = BLCtrl.getBool(item, "Contraception", false); pg.ContraceptionT = BLCtrl.getString(item, "ContraceptionT", ""); pgl.Add(pg); } return(pgl); }
public List <LifeStyle> Get_LifeStyleById(string id) { DADr_LifeStyle dm = new DADr_LifeStyle();//הקצאת המחלקה ListDictionary Params = new ListDictionary(); //Params.Add("@date", date);//מכניס את זה לרשימה ולוקח את הפרוצדורה בSQL Params.Add("@id", id); DataSet ds = dm.getLifeStyleDrById(Params); //מקבל את המאפיין מהטבלה מהסוג שלו LifeStyle ls = new LifeStyle(); //הקצאה מסוג הטבלה List <LifeStyle> pgl = new List <LifeStyle>(); //המרה של המאפיין מטיפוס שלו לטיפוס של המחלקה foreach (DataRow item in ds.Tables[0].Rows) { ls = new LifeStyle(); ls.UpdateCode = BLCtrl.getInt(item, "UpdateCode", 0);//ask ls.Acohol = BLCtrl.getBool(item, "Alcohol", false); ls.AcoholT = BLCtrl.getString(item, "AlcoholT", ""); ls.Smoking = BLCtrl.getBool(item, "Smoking", false); ls.Smoke = BLCtrl.getBool(item, "Smoke", false); ls.PassiveSmoking = BLCtrl.getBool(item, "PassiveSmoking", false); ls.PassiveSmokingT = BLCtrl.getString(item, "PassiveSmokingT", ""); ls.Drugs = BLCtrl.getBool(item, "Drugs", false); ls.DrugsT = BLCtrl.getString(item, "DrugsT", ""); ls.PastDrugs = BLCtrl.getBool(item, "PastDrugs", false); ls.PastDrugsT = BLCtrl.getString(item, "PastDrugsT", ""); ls.Trauma = BLCtrl.getBool(item, "Trauma", false); ls.TraumaT = BLCtrl.getString(item, "TraumaT", ""); ls.DisordersEating = BLCtrl.getBool(item, "DisordersEating", false); ls.DisordersEatingT = BLCtrl.getString(item, "DisordersEatingT", ""); ls.PastDisordersEating = BLCtrl.getBool(item, "PastDisordersEating", false); ls.PastDisordersEatingT = BLCtrl.getString(item, "PastDisordersEatingT", ""); ls.Anxiety = BLCtrl.getBool(item, "Anxiety", false); ls.AnxietyT = BLCtrl.getString(item, "AnxietyT", ""); ls.Bi_polar = BLCtrl.getBool(item, "DisordersEatingT", false); ls.Bi_polarT = BLCtrl.getString(item, "Bi_polarT", ""); ls.Depression = BLCtrl.getBool(item, "Depression", false); ls.DepressionT = BLCtrl.getString(item, "DepressionT", ""); ls.OtherMentallssue = BLCtrl.getBool(item, "OtherMentalIssue", false); ls.OtherMentallssueT = BLCtrl.getString(item, "OtherMentalIssueT", ""); ls.Relation = BLCtrl.getBool(item, "Relation", false); ls.RelationT = BLCtrl.getString(item, "RelationT", ""); ls.Ab = BLCtrl.getBool(item, "Ab", false); ls.AbT = BLCtrl.getString(item, "AbT", ""); ls.St = BLCtrl.getString(item, "St", ""); pgl.Add(ls); } return(pgl); }
public Summary getSummary(DateTime date1, string id1) { VisitSummary dm = new VisitSummary(); ListDictionary Params = new ListDictionary(); Summary s = new Summary(); Params.Add("@date", BLCtrl.sendDateTime(date1, new DateTime())); Params.Add("@id", BLCtrl.sendString(id1, "")); DataSet ds = dm.getSummary(Params); s.Mentioned = BLCtrl.getBool(ds.Tables[0].Rows[0], "Mentioned", false); s.FollowUp = BLCtrl.getInt(ds.Tables[0].Rows[0], "FollowUp", 0); return(s); }
public Patiants getPatiantsById(string id) { DAPatiants da = new DAPatiants(); ListDictionary Params = new ListDictionary(); Params.Add("@id", id); DataSet ds = da.getPatiantsById(Params); Patiants p = new Patiants(); p.A = BLCtrl.getInt(ds.Tables[0].Rows[0], "A", 0); p.BirthDate = BLCtrl.getDateTime(ds.Tables[0].Rows[0], "BirthDate", DateTime.Today); p.Children = BLCtrl.getInt(ds.Tables[0].Rows[0], "Children", 0); p.City = BLCtrl.getString(ds.Tables[0].Rows[0], "City", ""); p.Code = BLCtrl.getInt(ds.Tables[0].Rows[0], "Code", 0); p.ContactExam = BLCtrl.getString(ds.Tables[0].Rows[0], "ContactExam", ""); p.ContactGinformation = BLCtrl.getString(ds.Tables[0].Rows[0], "ContactGinformation", ""); p.Doctor = BLCtrl.getString(ds.Tables[0].Rows[0], "Doctor", ""); p.Email = BLCtrl.getString(ds.Tables[0].Rows[0], "Email", ""); p.FathersOrigin = BLCtrl.getString(ds.Tables[0].Rows[0], "FathersOrigin", ""); p.Fax = BLCtrl.getString(ds.Tables[0].Rows[0], "Fax", ""); p.FirstName = BLCtrl.getString(ds.Tables[0].Rows[0], "FirstName", ""); p.followedup = BLCtrl.getBool(ds.Tables[0].Rows[0], "followedup", false); p.FollowUp = BLCtrl.getBool(ds.Tables[0].Rows[0], "FollowUp", false); p.G = BLCtrl.getInt(ds.Tables[0].Rows[0], "G", 0); p.Id = BLCtrl.getString(ds.Tables[0].Rows[0], "Id", ""); p.Kupah = BLCtrl.getInt(ds.Tables[0].Rows[0], "Kupah", 0); p.L = BLCtrl.getInt(ds.Tables[0].Rows[0], "L", 0); p.Language = BLCtrl.getString(ds.Tables[0].Rows[0], "Language", ""); p.LastName = BLCtrl.getString(ds.Tables[0].Rows[0], "LastName", ""); p.MaritalStatus = BLCtrl.getInt(ds.Tables[0].Rows[0], "MaritalStatus", 0); p.MothersOrigin = BLCtrl.getString(ds.Tables[0].Rows[0], "MothersOrigin", ""); p.Occupation = BLCtrl.getString(ds.Tables[0].Rows[0], "Occupation", ""); p.P = BLCtrl.getInt(ds.Tables[0].Rows[0], "P", 0); p.Phone = BLCtrl.getString(ds.Tables[0].Rows[0], "Phone", ""); p.Phone2 = BLCtrl.getString(ds.Tables[0].Rows[0], "Phone2", ""); p.reffered = BLCtrl.getString(ds.Tables[0].Rows[0], "reffered", ""); p.Street = BLCtrl.getString(ds.Tables[0].Rows[0], "Street", ""); p.T = BLCtrl.getInt(ds.Tables[0].Rows[0], "T", 0); return(p); }
public VisitReason getVisitReason(DateTime date, string id) { DAVisitReason da = new DAVisitReason(); ListDictionary Params = new ListDictionary(); Params.Add("@date", date); Params.Add("@id", id); DataSet ds = da.getVisitReason(Params); VisitReason v = new VisitReason(); v.GeneralCheck = BLCtrl.getBool(ds.Tables[0].Rows[0], "GeneralCheck", false); v.BreastExam = BLCtrl.getBool(ds.Tables[0].Rows[0], "BreastExam", false); v.Pap = BLCtrl.getBool(ds.Tables[0].Rows[0], "Pap", false); v.Diaphragm = BLCtrl.getBool(ds.Tables[0].Rows[0], "Diaphragm", false); v.OtherConcetraption = BLCtrl.getBool(ds.Tables[0].Rows[0], "OtherConcetraption", false); v.MenstrualCycle = BLCtrl.getBool(ds.Tables[0].Rows[0], "MenstrualCycle", false); v.Kallah = BLCtrl.getBool(ds.Tables[0].Rows[0], "Kallah", false); v.OtherReason = BLCtrl.getBool(ds.Tables[0].Rows[0], "OtherReason", false); v.Text = BLCtrl.getString(ds.Tables[0].Rows[0], "Text", ""); return(v); }
public PastGenicology getPastGenicology(string id, DateTime date) { DAPastGenicology da = new DAPastGenicology(); ListDictionary Params = new ListDictionary(); Params.Add("@id", id); Params.Add("@date", date); DataSet ds = da.getPastGenicology(Params); PastGenicology pg = new PastGenicology(); pg.UpdateCode = BLCtrl.getInt(ds.Tables[0].Rows[0], "UpdateCode", 0); pg.AgeOfMenarche = BLCtrl.getInt(ds.Tables[0].Rows[0], "AgeOfMenarche", 18); pg.CycleRegular = BLCtrl.getBool(ds.Tables[0].Rows[0], "CycleRegular", true); pg.CycleRegularT = BLCtrl.getString(ds.Tables[0].Rows[0], "CycleRegularT", ""); pg.MenstrualSyptoms = BLCtrl.getBool(ds.Tables[0].Rows[0], "MenstrualSyptoms", false); pg.MenstrualSyptomsT = BLCtrl.getString(ds.Tables[0].Rows[0], "MenstrualSyptomsT", ""); pg.MenopauseSyptoms = BLCtrl.getBool(ds.Tables[0].Rows[0], "MenopauseSyptoms", false); pg.MenopauseSyptomsT = BLCtrl.getString(ds.Tables[0].Rows[0], "MenopauseSyptomsT", ""); pg.Contraception = BLCtrl.getBool(ds.Tables[0].Rows[0], "Contraception", false); pg.ContraceptionT = BLCtrl.getString(ds.Tables[0].Rows[0], "ContraceptionT", ""); return(pg); }