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 Kupot Kupah(int code)
{
DAKupah dcp = new DAKupah();
ListDictionary Params = new ListDictionary();
Params.Add("@code", BLCtrl.sendInt(code, 0));
DataSet ds = dcp.Kupah(Params);
Kupot k = new Kupot();
k.Kupah = BLCtrl.getString(ds.Tables[0].Rows[0], "Kupah", "");
return(k);
}
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);
}
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);
}
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 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_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 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 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);
}