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