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 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);
}
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 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 UpdateReccomendations(DateTime date1, string id1, int code1, string rec1)
{
VisitSummary dm = new VisitSummary();
ListDictionary Params = new ListDictionary();
Params.Add("@date", BLCtrl.sendDateTime(date1, new DateTime()));
Params.Add("@id", BLCtrl.sendString(id1, ""));
Params.Add("@code", BLCtrl.sendInt(code1, 0));
Params.Add("@rec", BLCtrl.sendString(rec1, ""));
int result = dm.UpdateReccomendations(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);
}
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);
}
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);
}
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 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 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);
}
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);
}