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> 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 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 Check_Patient(string id1)
{
DACheck_Patient dcp = new DACheck_Patient();
ListDictionary Params = new ListDictionary();
Params.Add("@id", BLCtrl.sendString(id1, ""));
int result = dcp.Check_Patient(Params);
return(result);
}
public int Check_Workers(string idWorkers)
{
DACheck_Workers dcw = new DACheck_Workers();
ListDictionary Params = new ListDictionary();
Params.Add("@id", BLCtrl.sendString(idWorkers, ""));
int result = dcw.Check_Workers(Params);
return(result);
}
public int Check_Customers(string idCustomer)
{
DACheck_Customers dcc = new DACheck_Customers();
ListDictionary Params = new ListDictionary();
Params.Add("@id", BLCtrl.sendString(idCustomer, ""));
int result = dcc.Check_Customers(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 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 CheckCustomerID(string Id)
{
DAAddCustomer dm = new DAAddCustomer();
ListDictionary Params = new ListDictionary();
Params.Add("@id", BLCtrl.sendString(Id, ""));
int result = dm.CheckCustomerID(Params);
return(result);
}
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 CheckID(string Id)
{
DA_Add_Patiants dm = new DA_Add_Patiants();
ListDictionary Params = new ListDictionary();
Params.Add("@id", BLCtrl.sendString(Id, ""));
int result = dm.CheckID(Params);
return(result);
}
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 int Add_Worker(string Id, string FirstName, string LastName)
{
DA_Add_Worker dm = new DA_Add_Worker();
ListDictionary Params = new ListDictionary();
Params.Add("@Id", BLCtrl.sendString(Id, ""));
Params.Add("@FirstName", BLCtrl.sendString(FirstName, ""));
Params.Add("@LastName", BLCtrl.sendString(LastName, ""));
int result = dm.Add_Worker(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 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 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 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 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 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 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 <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 <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 <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 <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 <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 int Add_Customers(string id, string firstName, string lastName,
string phone, string phone2, string city, string street)
{
DAAddCustomer dm = new DAAddCustomer();
ListDictionary Params = new ListDictionary();
Params.Add("@Id", BLCtrl.sendString(id, ""));
Params.Add("@FristName", BLCtrl.sendString(firstName, ""));
Params.Add("@LastName", BLCtrl.sendString(lastName, ""));
Params.Add("@Phone", BLCtrl.sendString(phone, ""));
Params.Add("@Pone2", BLCtrl.sendString(phone2, ""));
Params.Add("@City", BLCtrl.sendString(city, ""));
Params.Add("@Street", BLCtrl.sendString(street, ""));
int result = dm.Add_Customers(Params);
return(result);
}
