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);
        }
Exemplo n.º 3
0
        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);
        }
Exemplo n.º 4
0
        public Kupot Kupah(int code)
        {
            DAKupah        dcp    = new DAKupah();
            ListDictionary Params = new ListDictionary();

            Params.Add("@code", BLCtrl.sendInt(code, 0));
            DataSet ds = dcp.Kupah(Params);
            Kupot   k  = new Kupot();

            k.Kupah = BLCtrl.getString(ds.Tables[0].Rows[0], "Kupah", "");
            return(k);
        }
Exemplo n.º 5
0
        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);
        }
Exemplo n.º 6
0
        public List <Kupot> getKupot()
        {
            DAGetKupot     dak    = new DAGetKupot();
            ListDictionary Params = new ListDictionary();
            DataSet        ds     = dak.getKupot();
            List <Kupot>   lk     = new List <Kupot>();
            Kupot          k;

            foreach (DataRow item in ds.Tables[0].Rows)
            {
                k       = new Kupot();
                k.Code  = BLCtrl.getInt(item, "Code", 0);
                k.Kupah = BLCtrl.getString(item, "Kupah", "");
                lk.Add(k);
            }
            return(lk);
        }
Exemplo n.º 7
0
        public List <Banks> getAllBanks()
        {
            DAAddReceipt   dm     = new DAAddReceipt();
            ListDictionary Params = new ListDictionary();
            DataSet        ds     = dm.getAllBanks(Params);
            Banks          b;
            List <Banks>   l = new List <Banks>();

            foreach (DataRow item in ds.Tables[0].Rows)
            {
                b          = new Banks();
                b.BankNum  = BLCtrl.getInt(item, "BankNum", 0);
                b.BankName = BLCtrl.getString(item, "BankName", "");
                l.Add(b);
            }
            return(l);
        }
Exemplo n.º 8
0
        public List <MaritalStatus> getMaterialStatus()
        {
            DAMaterialStatus     dams   = new DAMaterialStatus();
            ListDictionary       Params = new ListDictionary();
            DataSet              ds     = dams.getMaterialStatus();
            List <MaritalStatus> lms    = new List <MaritalStatus>();
            MaritalStatus        ms;

            foreach (DataRow item in ds.Tables[0].Rows)
            {
                ms               = new MaritalStatus();
                ms.Code          = BLCtrl.getInt(item, "Code", 0);
                ms.Maritalstatus = BLCtrl.getString(item, "Maritalstatus", "");
                lms.Add(ms);
            }
            return(lms);
        }
Exemplo n.º 9
0
        public List <Kupot> Draw_Kupah()
        {
            DA_Add_Patiants dm     = new DA_Add_Patiants();
            ListDictionary  Params = new ListDictionary();
            DataSet         ds     = dm.Draw_Kupah(Params);
            List <Kupot>    l      = new List <Kupot>();
            Kupot           k;

            foreach (DataRow item in ds.Tables[0].Rows)
            {
                k       = new Kupot();
                k.Kupah = BLCtrl.getString(item, "Kupah", "");
                k.Code  = BLCtrl.getInt(item, "Code", 0);
                l.Add(k);
            }
            return(l);
        }
Exemplo n.º 10
0
        public List <PayBy> getPayBy()
        {
            DAAddReceipt   dm     = new DAAddReceipt();
            ListDictionary Params = new ListDictionary();
            DataSet        ds     = dm.getPayBay(Params);
            PayBy          b;
            List <PayBy>   l = new List <PayBy>();

            foreach (DataRow item in ds.Tables[0].Rows)
            {
                b       = new PayBy();
                b.Code  = BLCtrl.getInt(item, "Code", 0);
                b.payBy = BLCtrl.getString(item, "PayBy", "");
                l.Add(b);
            }
            return(l);
        }
Exemplo n.º 11
0
        public List <FollowsUp> getFollowUp()
        {
            VisitSummary     dm     = new VisitSummary();
            ListDictionary   Params = new ListDictionary();
            DataSet          ds     = dm.getFollowUp(Params);
            List <FollowsUp> l      = new List <FollowsUp>();
            FollowsUp        f;

            foreach (DataRow item in ds.Tables[0].Rows)
            {
                f          = new FollowsUp();
                f.Code     = BLCtrl.getInt(item, "Code", 0);
                f.FollowUp = BLCtrl.getString(item, "FollowUp", "");
                l.Add(f);
            }

            return(l);
        }
Exemplo n.º 12
0
        public Customers getCustomersById(string id)
        {
            DAGetCustomersById da     = new DAGetCustomersById();
            ListDictionary     Params = new ListDictionary();

            Params.Add("@id", id);
            DataSet   ds = da.getCustomersById(Params);
            Customers c  = new Customers();

            c.City      = BLCtrl.getString(ds.Tables[0].Rows[0], "City", "");
            c.Code      = BLCtrl.getInt(ds.Tables[0].Rows[0], "Code", 0);
            c.FirstName = BLCtrl.getString(ds.Tables[0].Rows[0], "FirstName", "");
            c.Id        = BLCtrl.getString(ds.Tables[0].Rows[0], "Id", "");
            c.LastName  = BLCtrl.getString(ds.Tables[0].Rows[0], "LastName", "");
            c.Phone     = BLCtrl.getString(ds.Tables[0].Rows[0], "Phone", "");
            c.Phone2    = BLCtrl.getString(ds.Tables[0].Rows[0], "Phone2", "");
            c.Street    = BLCtrl.getString(ds.Tables[0].Rows[0], "Street", "");
            return(c);
        }
Exemplo n.º 13
0
        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);
        }
Exemplo n.º 14
0
        public List <Reccomendations> getReccomendations(DateTime date1, string id1)
        {
            VisitSummary    dm     = new VisitSummary();
            ListDictionary  Params = new ListDictionary();
            Reccomendations s;

            Params.Add("@date", BLCtrl.sendDateTime(date1, new DateTime()));
            Params.Add("@id", BLCtrl.sendString(id1, ""));
            DataSet ds = dm.getReccomendations(Params);
            List <Reccomendations> l = new List <Reccomendations>();

            foreach (DataRow item in ds.Tables[0].Rows)
            {
                s                = new Reccomendations();
                s.UpdateCode     = BLCtrl.getInt(item, "UpdateCode", 0);
                s.Code           = BLCtrl.getInt(item, "Code", 0);
                s.Reccomendation = BLCtrl.getString(item, "Reccomendation", "");
                l.Add(s);
            }
            return(l);
        }
Exemplo n.º 15
0
        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);
        }
Exemplo n.º 16
0
        public List <Workers> getWorkers()
        {
            WorkersList dm = new WorkersList();

            ListDictionary Params = new ListDictionary();

            DataSet        ds = dm.getWorkers(Params);
            List <Workers> l  = new List <Workers>();
            Workers        w;

            foreach (DataRow item in ds.Tables[0].Rows)
            {
                w           = new Workers();
                w.Id        = BLCtrl.getString(item, "Id", " ");
                w.FirstName = BLCtrl.getString(item, "FirstName", " ");
                w.LastName  = BLCtrl.getString(item, "LastName", " ");
                w.Job       = BLCtrl.getInt(item, "Job", 0);
                l.Add(w);
            }
            return(l);
        }
Exemplo n.º 17
0
        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);
        }
Exemplo n.º 18
0
        public List <Patiants> getPatiants()
        {
            PatientsList dm = new PatientsList();

            ListDictionary Params = new ListDictionary();
            // Params.Add("@dt", dt);

            DataSet         ds = dm.getPatiants(Params);
            List <Patiants> l  = new List <Patiants>();
            Patiants        p;

            foreach (DataRow item in ds.Tables[0].Rows)
            {
                // f.FollowUp = BLCtrl.getString(item, "FollowUp", "");
                p           = new Patiants();
                p.Id        = BLCtrl.getString(item, "Id", " ");
                p.FirstName = BLCtrl.getString(item, "FirstName", " ");
                p.LastName  = BLCtrl.getString(item, "LastName", " ");
                p.Doctor    = BLCtrl.getString(item, "Doctor", " ");
                l.Add(p);
            }
            return(l);
        }