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);
}
