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 int addOrUpdateLifeStyleNutritionist(float height, float weight, int bmi, string blood,
                                                    int pulse, bool noteat, string noteatt, int meals, int fruits, int vegetables, bool dairy,
                                                    int water, bool diet, string diett, float sleeping,
                                                    bool activity, DateTime dt, string id)
        {
            DALifeStyleNutritionist dm     = new DALifeStyleNutritionist();
            ListDictionary          Params = new ListDictionary();

            Params.Add("@height", BLCtrl.sendFloat(height, 0));
            Params.Add("@weight", BLCtrl.sendFloat(weight, 0));
            Params.Add("@bmi", BLCtrl.sendInt(bmi, 0));
            Params.Add("@blood", BLCtrl.sendString(blood, ""));
            Params.Add("@pulse", BLCtrl.sendInt(pulse, 0));
            Params.Add("@noteat", BLCtrl.sendBool(noteat, false));
            Params.Add("@noteatt", BLCtrl.sendString(noteatt, ""));
            Params.Add("@meals", BLCtrl.sendInt(meals, 0));
            Params.Add("@fruits", BLCtrl.sendInt(fruits, 0));
            Params.Add("@vegetables", BLCtrl.sendInt(vegetables, 0));
            Params.Add("@dairy", BLCtrl.sendBool(dairy, false));
            Params.Add("@water", BLCtrl.sendInt(water, 0));
            Params.Add("@diet", BLCtrl.sendBool(diet, false));
            Params.Add("@diett", BLCtrl.sendString(diett, ""));
            Params.Add("@sleeping", BLCtrl.sendFloat(sleeping, 0));
            Params.Add("@activity ", BLCtrl.sendBool(activity, false));
            Params.Add("@dt", BLCtrl.sendDateTime(dt, DateTime.Today));
            Params.Add("@id", BLCtrl.sendString(id, ""));
            int result = dm.addOrUpdateLifeStyleNutritionist(Params);

            return(result);
        }
        public int AddOrUpdatelifestyle(string id, DateTime date, LifeStyle s)
        // DateTime date, string id,  float height,float wheight ,
        //int bmi , string bloodpressure,
        //int pulse, bool noteat ,string noteatt ,int meals ,int fruits, int vegetables, bool dairy , int water,bool diet, string diett,
        //float sleepinghours , bool activity , bool alcohol,
        //string alcoholt , bool smoking, bool smoke, bool passivesmoking , bool drugs , string drugst, bool pastdrugs , bool trauma , string traumat, bool disorderseating ,  string disorderseatingt , bool depression, string depressiont,
        //bool pastdisorderseating , string pastdisorderseatingt, bool anxiety, string anxietyt, bool bipolar, string bipolart,
        //bool othermentalissue , string othermentalissuet , bool relation,
        //string relationt , bool ab , string abt , string st)
        {
            DADr_LifeStyle dm     = new DADr_LifeStyle();//הקצאת המחלקה
            ListDictionary Params = new ListDictionary();

            Params.Add("@id", BLCtrl.sendString(id, ""));
            Params.Add("@dt", BLCtrl.sendDateTime(date, new DateTime()));//מכניס את זה לרשימה ולוקח את הפרוצדורה בSQL


            Params.Add("@alcohol", BLCtrl.sendBool(s.Acohol, false));
            Params.Add("@alcoholt", BLCtrl.sendString(s.AcoholT, ""));
            Params.Add("@smoking", BLCtrl.sendBool(s.Smoking, false));
            Params.Add("@smoke", BLCtrl.sendBool(s.Smoke, false));
            Params.Add("@passivesmoking", BLCtrl.sendBool(s.PassiveSmoking, false));
            Params.Add("@passivesmokingt", BLCtrl.sendString(s.PassiveSmokingT, ""));//

            Params.Add("@drugs", BLCtrl.sendBool(s.Drugs, false));
            Params.Add("@drugst", BLCtrl.sendString(s.DrugsT, ""));
            Params.Add("@pastdrugs", BLCtrl.sendBool(s.PastDrugs, false));
            Params.Add("@pastdrugst", BLCtrl.sendString(s.PastDrugsT, ""));


            Params.Add("@trauma", BLCtrl.sendBool(s.Trauma, false));
            Params.Add("@traumat", BLCtrl.sendString(s.TraumaT, ""));
            Params.Add("@disorderseating", BLCtrl.sendBool(s.DisordersEating, false));
            Params.Add("@disorderseatingt", BLCtrl.sendString(s.DisordersEatingT, ""));
            Params.Add("@pastdisorderseating", BLCtrl.sendBool(s.PastDisordersEating, false));
            Params.Add("@pastdisorderseatingt", BLCtrl.sendString(s.PastDisordersEatingT, ""));


            Params.Add("@anxiety", BLCtrl.sendBool(s.Anxiety, false));
            Params.Add("@anxietyt", BLCtrl.sendString(s.AnxietyT, ""));
            Params.Add("@bipolar", BLCtrl.sendBool(s.Bi_polar, false));
            Params.Add("@bipolart", BLCtrl.sendString(s.Bi_polarT, ""));
            Params.Add("@depression", BLCtrl.sendBool(s.Depression, false));
            Params.Add("@depressiont", BLCtrl.sendString(s.DepressionT, ""));
            Params.Add("@othermentalissue", BLCtrl.sendBool(s.OtherMentallssue, false));
            Params.Add("@othermentalissuet", BLCtrl.sendString(s.OtherMentallssueT, ""));
            Params.Add("@relation", BLCtrl.sendBool(s.Relation, false));
            Params.Add("@relationt", BLCtrl.sendString(s.RelationT, ""));
            Params.Add("@ab", BLCtrl.sendBool(s.Ab, false));
            Params.Add("@abt", BLCtrl.sendString(s.AbT, ""));
            Params.Add("@st", BLCtrl.sendString(s.St, ""));


            int result = dm.AddOrUpdatelifestyle(Params);//מקבל את המאפיין מהטבלה מהסוג שלו

            return(result);
        }
        public int Check_Customers(string idCustomer)
        {
            DACheck_Customers dcc    = new DACheck_Customers();
            ListDictionary    Params = new ListDictionary();

            Params.Add("@id", BLCtrl.sendString(idCustomer, ""));
            int result = dcc.Check_Customers(Params);

            return(result);
        }
Beispiel #5
0
        public int Check_Workers(string idWorkers)
        {
            DACheck_Workers dcw    = new DACheck_Workers();
            ListDictionary  Params = new ListDictionary();

            Params.Add("@id", BLCtrl.sendString(idWorkers, ""));
            int result = dcw.Check_Workers(Params);

            return(result);
        }
        public int Check_Patient(string id1)
        {
            DACheck_Patient dcp    = new DACheck_Patient();
            ListDictionary  Params = new ListDictionary();

            Params.Add("@id", BLCtrl.sendString(id1, ""));
            int result = dcp.Check_Patient(Params);

            return(result);
        }
Beispiel #7
0
        public int CheckCustomerID(string Id)
        {
            DAAddCustomer dm = new DAAddCustomer();

            ListDictionary Params = new ListDictionary();

            Params.Add("@id", BLCtrl.sendString(Id, ""));


            int result = dm.CheckCustomerID(Params);

            return(result);
        }
        public int CheckID(string Id)
        {
            DA_Add_Patiants dm = new DA_Add_Patiants();

            ListDictionary Params = new ListDictionary();

            Params.Add("@id", BLCtrl.sendString(Id, ""));


            int result = dm.CheckID(Params);

            return(result);
        }
Beispiel #9
0
        public int addOrUpdateReccomendations(string id1, int code1, string rec1)
        {
            VisitSummary   dm     = new VisitSummary();
            ListDictionary Params = new ListDictionary();

            Params.Add("@id", BLCtrl.sendString(id1, ""));
            Params.Add("@code", BLCtrl.sendInt(code1, 0));
            Params.Add("@rec", BLCtrl.sendString(rec1, ""));

            int result = dm.addOrUpdateReccomendations(Params);

            return(result);
        }
Beispiel #10
0
        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);
        }
Beispiel #11
0
        public int Add_Worker(string Id, string FirstName, string LastName)
        {
            DA_Add_Worker dm = new DA_Add_Worker();

            ListDictionary Params = new ListDictionary();

            Params.Add("@Id", BLCtrl.sendString(Id, ""));
            Params.Add("@FirstName", BLCtrl.sendString(FirstName, ""));
            Params.Add("@LastName", BLCtrl.sendString(LastName, ""));

            int result = dm.Add_Worker(Params);

            return(result);
        }
Beispiel #12
0
        public int Add_Diagnoze(int Diagnoze, int Status, DateTime BeginDate, DateTime EndDate)
        {
            DAL_AddDiagnozeAndHospitalization dm = new DAL_AddDiagnozeAndHospitalization();

            ListDictionary Params = new ListDictionary();

            Params.Add("@Diagnoze", BLCtrl.sendString(Diagnoze, ""));
            Params.Add("@Status", BLCtrl.sendString(Status, ""));
            Params.Add("@BeginDate", BLCtrl.sendDateTime(BeginDate, DateTime.Today));
            Params.Add("@EndDate", BLCtrl.sendDateTime(EndDate, DateTime.Today));
            int result = dm.Add_Diagnoze(Params);

            return(result);
        }
Beispiel #13
0
        public int Add_Patiants(string Id, string FirstName, string LastName, int kupah)
        {
            DA_Add_Patiants dm = new DA_Add_Patiants();

            ListDictionary Params = new ListDictionary();

            Params.Add("@Id", BLCtrl.sendString(Id, ""));
            Params.Add("@FirstName", BLCtrl.sendString(FirstName, ""));
            Params.Add("@LastName", BLCtrl.sendString(LastName, ""));
            Params.Add("@kupah", BLCtrl.sendInt(kupah, 1));

            int result = dm.Add_Patiants(Params);

            return(result);
        }
Beispiel #14
0
        public int Update_Hospitalization(int Year, string Hospital, string Department, string Reason)
        {
            DAL_AddDiagnozeAndHospitalization dm = new DAL_AddDiagnozeAndHospitalization();

            ListDictionary Params = new ListDictionary();

            Params.Add("@Year", BLCtrl.sendInt("year", 0));
            Params.Add("@Hospital", BLCtrl.sendString(Hospital, ""));
            Params.Add("@Department", BLCtrl.sendString(Department, ""));
            Params.Add("@Reason", BLCtrl.sendString(Reason, ""));

            int result = dm.Update_Hospitalization(Params);

            return(result);
        }
        public int Add_Immunization(string pat, int immunization, DateTime SDate, int Year, string Text)
        {
            DA_AddImmunization dm     = new DA_AddImmunization();
            ListDictionary     Params = new ListDictionary();

            Params.Add("@patient", BLCtrl.sendString(pat, " "));
            Params.Add("@immunization", BLCtrl.sendInt(immunization, 0));
            Params.Add("@SDate", BLCtrl.sendDateTime(SDate, DateTime.Today));
            Params.Add("@Year", BLCtrl.sendInt(Year, 2018));
            Params.Add("@Text", BLCtrl.sendString(Text, " "));

            int result = dm.AddImmunization(Params);

            return(result);
        }
Beispiel #16
0
        public int UpdateSummary(DateTime date1, string id1, bool Mentioned1, int FollowUp1)
        {
            VisitSummary dm = new VisitSummary();

            ListDictionary Params = new ListDictionary();

            Params.Add("@date", BLCtrl.sendDateTime(date1, new DateTime()));
            Params.Add("@id", BLCtrl.sendString(id1, ""));
            Params.Add("@Mentioned", BLCtrl.sendBool(Mentioned1, true));
            Params.Add("@FollowUp", BLCtrl.sendInt(FollowUp1, 1));

            int result = dm.UpdateSummary(Params);

            return(result);
        }
        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);
        }
Beispiel #18
0
        public int Screening(string pat, int Screening, DateTime SDate, int Year, string Text)
        {
            DA_AddScreening dm = new DA_AddScreening();

            ListDictionary Params = new ListDictionary();

            Params.Add("@patient", BLCtrl.sendString(pat, " "));
            Params.Add("@Screening", BLCtrl.sendInt(Screening, 0));
            Params.Add("@SDate", BLCtrl.sendDateTime(SDate, DateTime.Today));
            Params.Add("@Year", BLCtrl.sendInt(Year, 2018));
            Params.Add("@Text", BLCtrl.sendString(Text, " "));

            int result = dm.AddScreening(Params);

            return(result);
        }
Beispiel #19
0
        public int Add_Customers(string id, string firstName, string lastName,
                                 string phone, string phone2, string city, string street)
        {
            DAAddCustomer  dm     = new DAAddCustomer();
            ListDictionary Params = new ListDictionary();

            Params.Add("@Id", BLCtrl.sendString(id, ""));
            Params.Add("@FristName", BLCtrl.sendString(firstName, ""));
            Params.Add("@LastName", BLCtrl.sendString(lastName, ""));
            Params.Add("@Phone", BLCtrl.sendString(phone, ""));
            Params.Add("@Pone2", BLCtrl.sendString(phone2, ""));
            Params.Add("@City", BLCtrl.sendString(city, ""));
            Params.Add("@Street", BLCtrl.sendString(street, ""));

            int result = dm.Add_Customers(Params);

            return(result);
        }
        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);
        }
Beispiel #21
0
        public int AddOrUpdateVisitReason(string id1, DateTime date1, bool GeneralCheck, bool BreastExam, bool Pap, bool Diaphragm, bool OtherConcetraption, bool MenstrualCycle, bool Kallah, bool OtherReason, string Text)
        {
            DAVisitReason  dm     = new DAVisitReason();
            ListDictionary Params = new ListDictionary();

            Params.Add("@id1", BLCtrl.sendString(id1, ""));
            Params.Add("@date1", BLCtrl.sendDateTime(date1, DateTime.Today));
            Params.Add("@GeneralCheck", BLCtrl.sendBool(GeneralCheck, false));
            Params.Add("@BreastExam", BLCtrl.sendBool(BreastExam, false));
            Params.Add("@Pap", BLCtrl.sendBool(Pap, false));
            Params.Add("@Diaphragm", BLCtrl.sendBool(Diaphragm, false));
            Params.Add("@OtherConcetraption", BLCtrl.sendBool(OtherConcetraption, false));
            Params.Add("@MenstrualCycle", BLCtrl.sendBool(MenstrualCycle, false));
            Params.Add("@Kallah", BLCtrl.sendBool(Kallah, false));
            Params.Add("@OtherReason", BLCtrl.sendBool(OtherReason, false));
            Params.Add("@Text", BLCtrl.sendString(Text, ""));
            int result = dm.addOrUpdateVisitReason(Params);

            return(result);
        }
Beispiel #22
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);
        }
Beispiel #23
0
        public int AddCustomerReceipt(DateTime receiptDate, double sum, int payBy,
                                      string chequaNum, int bank, int paymentNum, string runch, string bankAccount,
                                      string cardsKind, string CreditCard, string validity, string Name, int ReceiptNum, string Id)
        {
            DAAddReceipt   dm     = new DAAddReceipt();
            ListDictionary Params = new ListDictionary();

            Params.Add("@ReceiptDate", BLCtrl.sendDateTime(receiptDate, new DateTime()));
            Params.Add("@Sum", BLCtrl.sendDouble(sum, 0));
            if (payBy != 0)
            {
                Params.Add("@PayBy", payBy);
            }
            else
            {
                Params.Add("@PayBy", DBNull.Value);
            }

            Params.Add("@chequaNum", BLCtrl.sendString(chequaNum, ""));
            if (bank != 0)
            {
                Params.Add("@Bank", bank);
            }
            else
            {
                Params.Add("@Bank", DBNull.Value);
            }
            Params.Add("@Brunch", BLCtrl.sendString(runch, ""));
            Params.Add("@BankAccount", BLCtrl.sendString(bankAccount, ""));
            Params.Add("@CardsKind", BLCtrl.sendString(cardsKind, ""));
            Params.Add("@CreditCard", BLCtrl.sendString(CreditCard, ""));
            Params.Add("@Validity", BLCtrl.sendString(validity, ""));
            Params.Add("@Name", BLCtrl.sendString(Name, ""));
            Params.Add("@paymentNum", BLCtrl.sendInt(paymentNum, 0));
            Params.Add("@ReceiptNum", BLCtrl.sendInt(ReceiptNum, 0));
            Params.Add("@Id", BLCtrl.sendString(Id, ""));
            int result = dm.addReceipt(Params, "addCustomerReceipt");

            return(result);
        }
Beispiel #24
0
        public int UpdatePatiant(string id, string fname, string lname, string doctor, string reffered, string language, string city, string street, string phon, string phon2, string fax, string email, DateTime birthdate, string contactexam, string contactginformation, string father, string mother, int kupa, int maritalstatus, int children, int g, int t, int p, int a, int l, bool followup, string occapation, bool followedup)
        {
            DAPatiants     dm     = new DAPatiants();
            ListDictionary Params = new ListDictionary();

            Params.Add("@id", BLCtrl.sendString(id, ""));
            Params.Add("@fname", BLCtrl.sendString(fname, ""));
            Params.Add("@lname", BLCtrl.sendString(lname, ""));
            Params.Add("@doctor", BLCtrl.sendString(doctor, ""));
            Params.Add("@reffered", BLCtrl.sendString(reffered, ""));
            Params.Add("@language", BLCtrl.sendString(language, ""));
            Params.Add("@city", BLCtrl.sendString(city, ""));
            Params.Add("@street", BLCtrl.sendString(street, ""));
            Params.Add("@phon", BLCtrl.sendString(phon, ""));
            Params.Add("@phon2", BLCtrl.sendString(phon2, ""));
            Params.Add("@fax", BLCtrl.sendString(fax, ""));
            Params.Add("@email", BLCtrl.sendString(email, ""));
            Params.Add("@birthdate", BLCtrl.sendDateTime(birthdate, DateTime.Today));
            Params.Add("@contactexam", BLCtrl.sendString(contactexam, ""));
            Params.Add("@contactginformation", BLCtrl.sendString(contactginformation, ""));
            Params.Add("@father", BLCtrl.sendString(father, ""));
            Params.Add("@mother", BLCtrl.sendString(mother, ""));
            Params.Add("@kupa", BLCtrl.sendInt(kupa, 0));
            Params.Add("@maritalstatus", BLCtrl.sendInt(maritalstatus, 0));
            Params.Add("@children", BLCtrl.sendInt(children, 0));
            Params.Add("@g", BLCtrl.sendInt(g, 0));
            Params.Add("@t", BLCtrl.sendInt(t, 0));
            Params.Add("@p", BLCtrl.sendInt(p, 0));
            Params.Add("@a", BLCtrl.sendInt(a, 0));
            Params.Add("@l", BLCtrl.sendInt(l, 0));
            Params.Add("@followup", BLCtrl.sendBool(followup, false));
            Params.Add("@occapation", BLCtrl.sendString(occapation, ""));
            Params.Add("@followedup", BLCtrl.sendBool(followedup, false));


            int result = dm.UpdatePatiant(Params);

            return(result);
        }
Beispiel #25
0
        public int addOrUpdatePastGenicology(string id1, DateTime date1, int
                                             AgeOfMenarche1, bool CycleRegular1, string CycleRegularT1, bool MenstrualSyptoms1,
                                             string MenstrualSyptomsT1, bool MenopauseSyptoms1, string MenopauseSyptomsT1, bool
                                             Contraception1, string ContraceptionT1)
        {
            DAPastGenicology da     = new DAPastGenicology();
            ListDictionary   Params = new ListDictionary();

            Params.Add("@id1", BLCtrl.sendString(id1, ""));
            Params.Add("@date1", BLCtrl.sendDateTime(date1, DateTime.Today));
            Params.Add("@AgeOfMenarche1", BLCtrl.sendInt(AgeOfMenarche1, 0));
            Params.Add("@CycleRegular1", BLCtrl.sendBool(CycleRegular1, true));
            Params.Add("@CycleRegularT1", BLCtrl.sendString(CycleRegularT1, ""));
            Params.Add("@MenstrualSyptoms1", BLCtrl.sendBool(MenstrualSyptoms1, false));
            Params.Add("@MenstrualSyptomsT1", BLCtrl.sendString(MenstrualSyptomsT1, ""));
            Params.Add("@MenopauseSyptoms1", BLCtrl.sendBool(MenopauseSyptoms1, false));
            Params.Add("@MenopauseSyptomsT1", BLCtrl.sendString(MenopauseSyptomsT1, ""));
            Params.Add("@Contraception1", BLCtrl.sendBool(Contraception1, false));
            Params.Add("@ContraceptionT1", BLCtrl.sendString(ContraceptionT1, ""));
            int result = da.addOrUpdatePastGenicology(Params);

            return(result);
        }