public List <Medicines> GetAllMedicines(string Id)
{
DAMedicines DAM = new DAMedicines();
ListDictionary Params = new ListDictionary();
Params.Add("@MyId", Id);
DataSet ds = DAM.GetAllMedicines(Params);
Medicines M = new Medicines();
List <Medicines> MyM = new List <Medicines>();
foreach (DataRow item in ds.Tables[0].Rows)
{
M.Code = BLCtrl.getInt(item, "Code", 0);
M.Influens = BLCtrl.getInt(item, "Medicine", 0);
M.Vitamin = BLCtrl.getInt(item, "Vitamin", 0);
M.Active = BLCtrl.getBool(item, "Active", false);
M.GivenKind = BLCtrl.getString(item, "GivenKind", "");
M.Quantity = BLCtrl.getString(item, "Quantity", "");
M.Days = BLCtrl.getInt(item, "Days", 0);
M.GivenOn = BLCtrl.getString(item, "GivenOn", "");
M.Text = BLCtrl.getString(item, "Text", "");
M.By = BLCtrl.getInt(item, "By", 0);
M.PatiantCode = BLCtrl.getString(item, "PatiantCode", "");
MyM.Add(M);
}
return(MyM);
}
public List <receipt> getReceipt(string code, string target)
{
DAReceipt da = new DAReceipt();
ListDictionary Params = new ListDictionary();
Params.Add("@code", code);
Params.Add("@target", target);
DataSet ds = da.getReceipt(Params);
List <receipt> lr = new List <receipt>();
receipt r;
foreach (DataRow item in ds.Tables[0].Rows)
{
r = new receipt();
r.PayBy = BLCtrl.getInt(item, "PayBy", 0);
r.Bank = BLCtrl.getInt(item, "Bank", 0);
r.BankAccount = BLCtrl.getString(item, "BankAccount", "");
r.Branch = BLCtrl.getString(item, "Branch", "");
r.CardsKind = BLCtrl.getString(item, "CardsKind", "");
r.chequaNum = BLCtrl.getString(item, "chequaNum", "");
r.Code = BLCtrl.getInt(item, "Code", 0);
r.CreditCard = BLCtrl.getString(item, "CreditCard", "");
r.name = BLCtrl.getString(item, "name", "");
r.PaymentNum = BLCtrl.getInt(item, "PaymentNum", 0);
r.receiptDate = BLCtrl.getDateTime(item, "receiptDate", DateTime.Today);
r.receiptNum = BLCtrl.getInt(item, "receiptNum", 0);
r.Sum = (double)BLCtrl.getDecimal(item, "Sum", 0M);
r.Validity = BLCtrl.getString(item, "Validity", "");
lr.Add(r);
}
return(lr);
}
public List <Sensitivities> GetAllSensitivities(string Id)
{
DASensitivities DAS = new DASensitivities();
ListDictionary Params = new ListDictionary();
Params.Add("@MyId", Id);
DataSet ds = DAS.GetAllSensitivities(Params);
Sensitivities S = new Sensitivities();
List <Sensitivities> MyS = new List <Sensitivities>();
foreach (DataRow item in ds.Tables[0].Rows)
{
S.Code = BLCtrl.getInt(item, "Code", 0);
S.Sensitivity = BLCtrl.getInt(item, "Sensitivity", 0);
S.Medicine = BLCtrl.getInt(item, "Medicine", 0);
S.Kind = BLCtrl.getString(item, "Kind", "");
S.DesicionDate = BLCtrl.getDateTime(item, "DesicionDate", new DateTime(2018 - 1 - 1));
S.Desided = BLCtrl.getString(item, "Desided", "");
S.Influenss = BLCtrl.getString(item, "Influenss", "");
S.By = BLCtrl.getInt(item, "By", 0);
S.PatiantCode = BLCtrl.getString(item, "PatiantCode", "");
MyS.Add(S);
}
return(MyS);
}
public int Get_Authorization()
{
DA_Acount dm = new DA_Acount();
ListDictionary Params = new ListDictionary();
DataSet ds = dm.Get_Authorization(Params);
int returnn = 0;
foreach (DataRow item in ds.Tables[0].Rows)
{
returnn = BLCtrl.getInt(item, "WokerAuthorization", 0);
}
return(returnn);
}
public List <Authorizations> GetAuthorizations()
{
DA_Worker_Details dm = new DA_Worker_Details();
ListDictionary Params = new ListDictionary();
DataSet ds = dm.GetAuthorizations(Params);
List <Authorizations> l = new List <Authorizations>();
Authorizations f;
foreach (DataRow item in ds.Tables[0].Rows)
{
f = new Authorizations();
f.Code = BLCtrl.getInt(item, "Code", 0);
f.Authorization = BLCtrl.getString(item, "Authorization", "");
l.Add(f);
}
return(l);
}
public List <Jobs> GetJob()
{
DA_Worker_Details dm = new DA_Worker_Details();
ListDictionary Params = new ListDictionary();
DataSet ds = dm.GetJob(Params);
List <Jobs> l = new List <Jobs>();
Jobs f;
foreach (DataRow item in ds.Tables[0].Rows)
{
f = new Jobs();
f.Code = BLCtrl.getInt(item, "Code", 0);
f.Job = BLCtrl.getString(item, "Job", "");
l.Add(f);
}
return(l);
}
public List <FinalReceipt> getAllReceipt(int PageNumber, int PageSize)
{
DAReceipt da = new DAReceipt();
ListDictionary Params = new ListDictionary();
Params.Add("@PageNumber", PageNumber);
Params.Add("@PageSize", PageSize);
DataSet ds = da.getAllReceipt(Params);
List <FinalReceipt> lr = new List <FinalReceipt>();
FinalReceipt r;
foreach (DataRow item in ds.Tables[0].Rows)
{
r = new FinalReceipt();
r.receiptDate = BLCtrl.getDateTime(item, "receiptDate", new DateTime(1000, 1, 1)).ToShortDateString();
r.receiptNum = BLCtrl.getInt(item, "receiptNum", 0);
r.FinalSum = (double)BLCtrl.getDecimal(item, "FinalSum", 0M);
r.RowNumber = BLCtrl.getInt(item, "RowNumber", 1);
lr.Add(r);
}
return(lr);
}
public List <Patiants> getFolloaed_patient()
{
DAFolloaed_patient dfp = new DAFolloaed_patient();
ListDictionary Params = new ListDictionary();
DataSet ds = dfp.getFolloaed_patient(Params);
List <Patiants> lp = new List <Patiants>();
Patiants p;
foreach (DataRow item in ds.Tables[0].Rows)
{
p = new Patiants();
p.Id = BLCtrl.getString(item, "id", " ");
p.FirstName = BLCtrl.getString(item, "FirstName", " ");
p.LastName = BLCtrl.getString(item, "LastName", " ");
p.Phone = BLCtrl.getString(item, "Phone", " ");
p.Phone2 = BLCtrl.getString(item, "Phone2", " ");
p.City = BLCtrl.getString(item, "City", " ");
p.Kupah = BLCtrl.getInt(item, "Kupah", 1);
//p.FollowUp = BLCtrl.getBool(item, "FollowUp", false);
lp.Add(p);
}
return(lp);
}
public Workers GetWorker(string id1)
{
DA_Worker_Details dm = new DA_Worker_Details();
ListDictionary Params = new ListDictionary();
Params.Add("@id", BLCtrl.sendString(id1, ""));
DataSet ds = dm.GetWorker(Params);
Workers s = new Workers();
s.Id = BLCtrl.getString(ds.Tables[0].Rows[0], "Id", "");
s.FirstName = BLCtrl.getString(ds.Tables[0].Rows[0], "FirstName", "");
s.LastName = BLCtrl.getString(ds.Tables[0].Rows[0], "LastName", "");
s.Authorization = BLCtrl.getInt(ds.Tables[0].Rows[0], "WokerAuthorization", 0);
s.BirthDate = BLCtrl.getDateTime(ds.Tables[0].Rows[0], "BirthDate", new DateTime());
s.City = BLCtrl.getString(ds.Tables[0].Rows[0], "City", "");
s.Code = BLCtrl.getInt(ds.Tables[0].Rows[0], "Code", 0);
s.Email = BLCtrl.getString(ds.Tables[0].Rows[0], "Email", "");
s.Fax = BLCtrl.getString(ds.Tables[0].Rows[0], "Fax", "");
s.Phone = BLCtrl.getString(ds.Tables[0].Rows[0], "Phone", "");
s.Job = BLCtrl.getInt(ds.Tables[0].Rows[0], "Job", 0);
s.Phone2 = BLCtrl.getString(ds.Tables[0].Rows[0], "Phone2", "");
s.Street = BLCtrl.getString(ds.Tables[0].Rows[0], "Street", "");
return(s);
}
public List <Diagnozes> GetAllDiagnoze(string Id)
{
DADiagnoze DAD = new DADiagnoze();
ListDictionary Params = new ListDictionary();
Params.Add("@MyId", Id);
DataSet ds = DAD.GetAllDiagnoze(Params);
Diagnozes D = new Diagnozes();
List <Diagnozes> MyD = new List <Diagnozes>();
foreach (DataRow item in ds.Tables[0].Rows)
{
D.Code = BLCtrl.getInt(item, "Code", 0);
D.Diagnoze = BLCtrl.getInt(item, "Diagnoze", 1);
D.Status = BLCtrl.getInt(item, "Status", 1);
D.BeginDate = BLCtrl.getDateTime(item, "BeginDate", new DateTime(2018 - 1 - 1));
D.EndDate = BLCtrl.getDateTime(item, "EndDate", new DateTime(2018 - 1 - 1));
D.By = BLCtrl.getInt(item, "By", 0);
D.PatiantCode = BLCtrl.getInt(item, "PatiantCode", 0);
MyD.Add(D);
}
return(MyD);
}
public List <Hospitalizations> GetAllHspitalization(string Id)
{
DAHospitalizations DAH = new DAHospitalizations();
ListDictionary Params = new ListDictionary();
Params.Add("@MyId", Id);
DataSet ds = DAH.GetAllHspitalization(Params);
Hospitalizations H = new Hospitalizations();
List <Hospitalizations> MyH = new List <Hospitalizations>();
foreach (DataRow item in ds.Tables[0].Rows)
{
H.Code = BLCtrl.getInt(item, "Code", 0);
H.Year = BLCtrl.getInt(item, "Year", 0);
H.Hospital = BLCtrl.getString(item, "Hospital", "");
H.MyProperty = BLCtrl.getInt(item, "MyProperty", 0);
H.Department = BLCtrl.getString(item, "Department", "");
H.Reason = BLCtrl.getString(item, "Reason", "");
H.By = BLCtrl.getInt(item, "By", 0);
H.PatiantCode = BLCtrl.getString(item, "PatiantCode", "");
MyH.Add(H);
}
return(MyH);
}
public PhysicalExam GetPhyicalExam(DateTime dt, string id)
{
DAPhyicalExam dap = new DAPhyicalExam();
ListDictionary Params = new ListDictionary();
Params.Add("@date", dt);
Params.Add("@id", id);
DataSet ds = dap.GetPhyicalExam(Params);
PhysicalExam p = new PhysicalExam();
p.PupilsEqualT = BLCtrl.getString(ds.Tables[0].Rows[0], "PupilsEqualT", "");
p.UpdateCode = BLCtrl.getInt(ds.Tables[0].Rows[0], "UpdateCode", 0);
p.ApearsWell = BLCtrl.getBool(ds.Tables[0].Rows[0], "ApearsWell", false);
p.ApearsWellT = BLCtrl.getString(ds.Tables[0].Rows[0], "ApearsWellT", "");
p.PupilsEqual = BLCtrl.getBool(ds.Tables[0].Rows[0], "PupilsEqual", false);
p.TmNormal = BLCtrl.getBool(ds.Tables[0].Rows[0], "TmNormal", false);
p.TmNormalT = BLCtrl.getString(ds.Tables[0].Rows[0], "TmNormalT", "");
p.Oropharynx = BLCtrl.getBool(ds.Tables[0].Rows[0], "Oropharynx", false);
p.OropharynxT = BLCtrl.getString(ds.Tables[0].Rows[0], "OropharynxT", "");
p.Atraumatic = BLCtrl.getBool(ds.Tables[0].Rows[0], "Atraumatic", false);
p.AtraumaticT = BLCtrl.getString(ds.Tables[0].Rows[0], "AtraumaticT", "");
p.HeentMucosa = BLCtrl.getBool(ds.Tables[0].Rows[0], "HeentMucosa", false);
p.HeentMucosaT = BLCtrl.getString(ds.Tables[0].Rows[0], "HeentMucosaT", "");
p.Supple = BLCtrl.getBool(ds.Tables[0].Rows[0], "Supple", false);
p.SuppleT = BLCtrl.getString(ds.Tables[0].Rows[0], "SuppleT", "");
p.thyromegaly = BLCtrl.getBool(ds.Tables[0].Rows[0], "thyromegaly", false);
p.thyromegalyT = BLCtrl.getString(ds.Tables[0].Rows[0], "thyromegalyT", "");
p.HeartsoundsRegular = BLCtrl.getBool(ds.Tables[0].Rows[0], "HeartsoundsRegular", false);
p.HeartsoundsRegularT = BLCtrl.getString(ds.Tables[0].Rows[0], "HeartsoundsRegularT", "");
p.Murmur = BLCtrl.getBool(ds.Tables[0].Rows[0], "Murmur", false);
p.MurmurT = BLCtrl.getString(ds.Tables[0].Rows[0], "MurmurT", "");
p.GoodAir = BLCtrl.getBool(ds.Tables[0].Rows[0], "GoodAir", false);
p.GoodAirT = BLCtrl.getString(ds.Tables[0].Rows[0], "GoodAirT", "");
p.ClearToAuscultation = BLCtrl.getBool(ds.Tables[0].Rows[0], "ClearToAuscultation", false);
p.ClearToAuscultationT = BLCtrl.getString(ds.Tables[0].Rows[0], "ClearToAuscultationT", "");
p.SymmetricalBreast = BLCtrl.getBool(ds.Tables[0].Rows[0], "SymmetricalBreast", false);
p.SymmetricalBreastT = BLCtrl.getString(ds.Tables[0].Rows[0], "SymmetricalBreastT", "");
p.Palpable = BLCtrl.getBool(ds.Tables[0].Rows[0], "Palpable", false);
p.PalpableT = BLCtrl.getString(ds.Tables[0].Rows[0], "PalpableT", "");
p.SkinChanges = BLCtrl.getBool(ds.Tables[0].Rows[0], "SkinChanges", false);
p.SkinChangesT = BLCtrl.getString(ds.Tables[0].Rows[0], "SkinChangesT", "");
p.Nipple = BLCtrl.getBool(ds.Tables[0].Rows[0], "Nipple", false);
p.NippleT = BLCtrl.getString(ds.Tables[0].Rows[0], "NippleT", "");
p.Axillary = BLCtrl.getBool(ds.Tables[0].Rows[0], "Axillary", false);
p.AxillaryT = BLCtrl.getString(ds.Tables[0].Rows[0], "AxillaryT", "");
p.Soft = BLCtrl.getBool(ds.Tables[0].Rows[0], "Soft", false);
p.SoftT = BLCtrl.getString(ds.Tables[0].Rows[0], "SoftT", "");
p.Tender = BLCtrl.getBool(ds.Tables[0].Rows[0], "Tender", false);
p.TenderT = BLCtrl.getString(ds.Tables[0].Rows[0], "TenderT", "");
p.ABDdescription = BLCtrl.getString(ds.Tables[0].Rows[0], "ABDdescription", "");
p.BowelSounds = BLCtrl.getBool(ds.Tables[0].Rows[0], "BowelSounds", false);
p.BowelSoundsT = BLCtrl.getString(ds.Tables[0].Rows[0], "BowelSoundsT", "");
p.RenalArtery = BLCtrl.getBool(ds.Tables[0].Rows[0], "RenalArtery", false);
p.RenalArteryT = BLCtrl.getString(ds.Tables[0].Rows[0], "RenalArteryT", "");
p.Masses = BLCtrl.getBool(ds.Tables[0].Rows[0], "Masses", false);
p.MassesT = BLCtrl.getString(ds.Tables[0].Rows[0], "MassesT", "");
p.Organomegaly = BLCtrl.getBool(ds.Tables[0].Rows[0], "Organomegaly", false);
p.OrganomegalyT = BLCtrl.getString(ds.Tables[0].Rows[0], "OrganomegalyT", "");
p.SkinAbnormalities = BLCtrl.getBool(ds.Tables[0].Rows[0], "SkinAbnormalities", false);
p.SkinAbnormalitiesT = BLCtrl.getString(ds.Tables[0].Rows[0], "SkinAbnormalitiesT", "");
p.SignificantScoliosis = BLCtrl.getBool(ds.Tables[0].Rows[0], "SignificantScoliosis", false);
p.SignificantScoliosisT = BLCtrl.getString(ds.Tables[0].Rows[0], "SignificantScoliosisT", "");
p.Kyphosis = BLCtrl.getBool(ds.Tables[0].Rows[0], "Kyphosis", false);
p.KyphosisT = BLCtrl.getString(ds.Tables[0].Rows[0], "KyphosisT", "");
p.Edema = BLCtrl.getBool(ds.Tables[0].Rows[0], "Edema", false);
p.EdemaT = BLCtrl.getString(ds.Tables[0].Rows[0], "EdemaT", "");
p.EXTRash = BLCtrl.getBool(ds.Tables[0].Rows[0], "EXTRash", false);
p.EXTRashT = BLCtrl.getString(ds.Tables[0].Rows[0], "EXTRashT", "");
p.Varicosities = BLCtrl.getBool(ds.Tables[0].Rows[0], "Varicosities", false);
p.VaricositiesT = BLCtrl.getString(ds.Tables[0].Rows[0], "VaricositiesT", "");
p.Pppx4 = BLCtrl.getBool(ds.Tables[0].Rows[0], "Pppx4", false);
p.Pppx4T = BLCtrl.getString(ds.Tables[0].Rows[0], "Pppx4T", "");
p.PedalEdema = BLCtrl.getBool(ds.Tables[0].Rows[0], "PedalEdema", false);
p.PedalEdemaT = BLCtrl.getString(ds.Tables[0].Rows[0], "PedalEdemaT", "");
p.Toes = BLCtrl.getBool(ds.Tables[0].Rows[0], "Toes", false);
p.ToesT = BLCtrl.getString(ds.Tables[0].Rows[0], "ToesT", "");
p.Pattelar = BLCtrl.getBool(ds.Tables[0].Rows[0], "Pattelar", false);
p.PattelarT = BLCtrl.getString(ds.Tables[0].Rows[0], "PattelarT", "");
p.Gait = BLCtrl.getBool(ds.Tables[0].Rows[0], "Gait", false);
p.GaitT = BLCtrl.getString(ds.Tables[0].Rows[0], "GaitT", "");
p.Speech = BLCtrl.getBool(ds.Tables[0].Rows[0], "Speech", false);
p.SpeechT = BLCtrl.getString(ds.Tables[0].Rows[0], "SpeechT", "");
p.Female = BLCtrl.getBool(ds.Tables[0].Rows[0], "Female", false);
p.FemaleT = BLCtrl.getString(ds.Tables[0].Rows[0], "FemaleT", "");
p.PelvicMucosa = BLCtrl.getInt(ds.Tables[0].Rows[0], "PelvicMucosa", 1);
p.Kegels = BLCtrl.getInt(ds.Tables[0].Rows[0], "Kegels", 1);
p.Cervix = BLCtrl.getString(ds.Tables[0].Rows[0], "Cervix", "");
p.VaginalWalls = BLCtrl.getBool(ds.Tables[0].Rows[0], "VaginalWalls", false);
p.VaginalWallsT = BLCtrl.getString(ds.Tables[0].Rows[0], "VaginalWallsT", "");
p.Pap = BLCtrl.getBool(ds.Tables[0].Rows[0], "Pap", false);
p.PapT = BLCtrl.getString(ds.Tables[0].Rows[0], "PapT", "");
return(p);
}