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 <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 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 int getTopReceiptNum()//שליפת מספר הקבלה האחרון בבסיס הנתונים
{
DAAddReceipt dm = new DAAddReceipt();
ListDictionary Params = new ListDictionary();
DataSet ds = dm.getReceiptNum(Params);
int ReceiptNum = 0;
foreach (DataRow item in ds.Tables[0].Rows)
{
ReceiptNum = BLCtrl.getInt(item, "LastreceiptNum", 0);
}
return(ReceiptNum);
}
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 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);
}
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);
}
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);
}
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);
}
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);
}
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);
}
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);
}
public List <Updatings> getUpdateDateAndcode(string id)
{
DAgetUpdateDateAndCode da = new DAgetUpdateDateAndCode();
ListDictionary Params = new ListDictionary();
Params.Add("@id", id);
DataSet ds = da.getUpdateDateAndCode(Params);
List <Updatings> l = new List <Updatings>();
Updatings f;
foreach (DataRow item in ds.Tables[0].Rows)
{
f = new Updatings();
f.UpdateDate = BLCtrl.getDateTime(item, "UpdateDate", new DateTime());
f.Code = BLCtrl.getInt(item, "Code", 0);
l.Add(f);
}
return(l);
}
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 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);
}
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);
}
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);
}