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 UpdateWorker(string id1, string FirstName1, string LastName1
, int Job1, int WokerAuthorization1,
string City1, string Street1, string Phone1,
string Phone2, string Fax1, string Email1, DateTime BirthDate1
)
{
DA_Worker_Details dm = new DA_Worker_Details();
ListDictionary Params = new ListDictionary();
Params.Add("@id", BLCtrl.sendString(id1, ""));
Params.Add("@FirstName", BLCtrl.sendString(FirstName1, ""));
Params.Add("@LastName", BLCtrl.sendString(LastName1, ""));
Params.Add("@Job", BLCtrl.sendInt(Job1, 0));
Params.Add("@WokerAuthorization", BLCtrl.sendInt(WokerAuthorization1, 0));
Params.Add("@City", BLCtrl.sendString(City1, ""));
Params.Add("@Street", BLCtrl.sendString(Street1, ""));
Params.Add("@Phone", BLCtrl.sendString(Phone1, ""));
Params.Add("@Phone2", BLCtrl.sendString(Phone2, ""));
Params.Add("@Fax", BLCtrl.sendString(Fax1, ""));
Params.Add("@Email", BLCtrl.sendString(Email1, ""));
Params.Add("@BirthDate", BLCtrl.sendDateTime(BirthDate1, new DateTime()));
int result = dm.UpdateWorker(Params);
return(result);
}
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 int CheckUserName(string UserName1)
{
DA_Worker_Details dm = new DA_Worker_Details();
ListDictionary Params = new ListDictionary();
Params.Add("@usename", BLCtrl.sendString(UserName1, ""));
int result = dm.CheckUserName(Params);
return(result);
}
//public int CheckWorker(string Id,int myout1)
// {
// DAWorker dm = new DAWorker();
// ListDictionary Params = new ListDictionary();
// Params.Add("@id", Id);
// Params.Add("@@myOut", myout1);
// int result = dm.CheckWorker(Params);
// return result;
// }
public int Cheak_JobUser(string username, string password)
{
DAWorker dm = new DAWorker();
ListDictionary Params = new ListDictionary();
Params.Add("@username", BLCtrl.sendString(username, ""));
Params.Add("@password", BLCtrl.sendString(password, ""));
int result = dm.Cheak_JobUser(Params);
return(result);
}
public int Cheak_Username(string username1, string password1)
{
DA_Acount dm = new DA_Acount();
ListDictionary Params = new ListDictionary();
Params.Add("@username", BLCtrl.sendString(username1, ""));
Params.Add("@password", BLCtrl.sendString(password1, ""));
int result = dm.Cheak_Username(Params);
return(result);
}
public int UpdateUserNameAndPassword(string id1, string UserName1, string UserPassword1)
{
DA_Worker_Details dm = new DA_Worker_Details();
ListDictionary Params = new ListDictionary();
Params.Add("@id", BLCtrl.sendString(id1, ""));
Params.Add("@UserName", BLCtrl.sendString(UserName1, ""));
Params.Add("@UserPassword", BLCtrl.sendString(UserPassword1, ""));
int result = dm.UpdateUserNameAndPassword(Params);
return(result);
}
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 <string> GetNameHospital(string Num)
{
DAHospitalizations DAH = new DAHospitalizations();
ListDictionary Params = new ListDictionary();
Params.Add("@Num", Num);
DataSet ds = DAH.GetNameHospital(Params);
string S;
List <string> MyNameHospital = new List <string>();
S = BLCtrl.getString(ds.Tables[0].Rows[0], "Hospital", "");
MyNameHospital.Add(S);
return(MyNameHospital);
}
public List <string> GetNameWorker(int Num)
{
DADiagnoze DAD = new DADiagnoze();
ListDictionary Params = new ListDictionary();
Params.Add("@Num", Num);
DataSet ds = DAD.GetNameWorker(Params);
string S;
List <string> MyNameWorker = new List <string>();
S = BLCtrl.getString(ds.Tables[0].Rows[0], "FullName", "");
MyNameWorker.Add(S);
return(MyNameWorker);
}
public List <string> GetNameSensitivity(string Num)
{
DASensitivities DAS = new DASensitivities();
ListDictionary Params = new ListDictionary();
Params.Add("@Num", Num);
DataSet ds = DAS.GetNameSensitivity(Params);
string S;
List <string> MyNameSensitivity = new List <string>();
S = BLCtrl.getString(ds.Tables[0].Rows[0], "Medicine", "");
MyNameSensitivity.Add(S);
return(MyNameSensitivity);
}
public List <string> GetNameWorker(string Num)
{
DAMedicines DAM = new DAMedicines();
ListDictionary Params = new ListDictionary();
Params.Add("@Num", Num);
DataSet ds = DAM.GetNameWorker(Params);
string S;
List <string> MyNameWorker = new List <string>();
S = BLCtrl.getString(ds.Tables[0].Rows[0], "LastName" + ' ' + "FirstName", "");
MyNameWorker.Add(S);
return(MyNameWorker);
}
public List <string> GetNameMedicine(string Num)
{
DAMedicines DAM = new DAMedicines();
ListDictionary Params = new ListDictionary();
Params.Add("@Num", Num);
DataSet ds = DAM.GetNameMedicine(Params);
string S;
List <string> MyNameMedicine = new List <string>();
S = BLCtrl.getString(ds.Tables[0].Rows[0], "Medicine", "");
MyNameMedicine.Add(S);
return(MyNameMedicine);
}
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 <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 ActionResult updateWorker(Workers w)// עדכון שאר פרטי העובד
{
ViewBag.validation = "";
BLWorkerDetails b = new BLWorkerDetails();
int result = b.UpdateWorker(Session["WorkerDetails"].ToString(), BLCtrl.sendString(w.FirstName, ""), BLCtrl.sendString(w.LastName, "")
, BLCtrl.sendInt(w.Job, 1), BLCtrl.sendInt(w.Authorization, 1), BLCtrl.sendString(w.City, ""), BLCtrl.sendString(w.Street, ""), BLCtrl.sendString(w.Phone, "")
, BLCtrl.sendString(w.Phone2, ""), BLCtrl.sendString(w.Fax, ""), BLCtrl.sendString(w.Email, ""), BLCtrl.sendDateTime(w.BirthDate, new DateTime()));
if (result == 0)
{
ViewBag.validation = "הפרטים נקבעו בהצלחה";
return(RedirectToAction("WorkerDetails"));
}
else
{
ViewBag.validation = "שגיאה";
}
return(View("WorkerDetails"));
}
public List <Customers> getCustomers()
{
DACustomers dc = new DACustomers();
ListDictionary Params = new ListDictionary();
DataSet ds = dc.getCustomers(Params);
List <Customers> lc = new List <Customers>();
Customers c;
foreach (DataRow item in ds.Tables[0].Rows)
{
c = new Customers();
c.Id = BLCtrl.getString(item, "id", "");
c.FirstName = BLCtrl.getString(item, "FirstName", " ");
c.LastName = BLCtrl.getString(item, "LastName", " ");
c.Phone = BLCtrl.getString(item, "Phone", " ");
c.Phone2 = BLCtrl.getString(item, "Phone2", " ");
c.City = BLCtrl.getString(item, "City", " ");
c.Street = BLCtrl.getString(item, "Street", " ");
lc.Add(c);
}
return(lc);
}
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 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 <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 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 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 int AddOrUpdatePhysicalExam1(string id, bool apearsWell, string apearsWellT, bool pupilsEqual, string pupilsEqualT, bool tmNormal, string tmNormalT, bool oropharynx, string oropharynxT, bool atraumatic, string atraumaticT, bool heentMucosa, string heentMucosaT, bool supple, string suppleT, bool thyromegaly, string thyromegalyT, bool heartsoundsRegular, string heartsoundsRegularT, bool murmur, string murmurT, bool goodAir, string goodAirT, bool clearToAuscultation, string clearToAuscultationT, bool symmetricalBreast, string symmetricalBreastT, bool palpable, string palpableT, bool skinChanges, string skinChangesT, bool nipple, string nippleT, bool axillary, string axillaryT, bool soft, string softT, bool tender, string tenderT, string aBDdescription, bool bowelSounds, string bowelSoundsT, bool renalArtery, string renalArteryT, bool masses, string massesT, bool organomegaly, string organomegalyT, bool skinAbnormalities, string skinAbnormalitiesT, bool significantScoliosis, string significantScoliosisT, bool kyphosis, string kyphosisT, bool edema, string edemaT, bool eXTRash, string eXTRashT, bool varicosities, string varicositiesT, bool pppx4, string pppx4T, bool pedalEdema, string pedalEdemaT, bool toes, string toesT, bool pattelar, string pattelarT, bool gait, string gaitT, bool speech, string speechT, bool female, string femaleT, int pelvicMucosa, int kegels, string cervix, bool vaginalWalls, string vaginalWallsT, bool pap, string papT, int v)
//{
// throw new NotImplementedException();
//}
public int AddOrUpdatePhysicalExam1(DateTime date, string id,
bool ApearsWell,
string ApearsWellT,
bool PupilsEqual,
string PupilsEqualT,
bool TmNormal,
string TmNormalT,
bool Oropharynx,
string OropharynxT,
bool Atraumatic,
string AtraumaticT
, bool HeentMucosa,
string HeentMucosaT,
bool Supple,
string SuppleT,
bool thyromegaly,
string thyromegalyT,
bool HeartsoundsRegular,
string HeartsoundsRegularT,
bool Murmur,
string MurmurT,
bool GoodAir,
string GoodAirT,
bool ClearToAuscultation,
string ClearToAuscultationT,
bool SymmetricalBreast,
string SymmetricalBreastT,
bool Palpable,
string PalpableT,
bool SkinChanges
, string SkinChangesT,
bool Nipple,
string NippleT,
bool Axillary,
string AxillaryT,
bool Soft
, string SoftT
, bool Tender
, string TenderT,
string ABDdescription
, bool BowelSounds
, string BowelSoundsT
, bool RenalArtery
, string RenalArteryT,
bool Masses
, string MassesT
, bool Organomegaly,
string OrganomegalyT
, bool SkinAbnormalities
, string SkinAbnormalitiesT,
bool SignificantScoliosis
, string SignificantScoliosisT
, bool Kyphosis
, string KyphosisT
, bool Edema
, string EdemaT,
bool EXTRash
, string EXTRashT
, bool Varicosities
, string VaricositiesT
, bool Pppx4
, string Pppx4T
, bool PedalEdema
, string PedalEdemaT,
bool Toes
, string ToesT
, bool Pattelar
, string PattelarT
, bool Gait
, string GaitT
, bool Speech
, string SpeechT,
bool Female
, string FemaleT
, int PelvicMucosa
, int Kegels
, string Cervix
, bool VaginalWalls
, string VaginalWallsT
, bool Pap,
string PapT)
{
DAPhyicalExam dm = new DAPhyicalExam();
ListDictionary Params = new ListDictionary();
Params.Add("@date", BLCtrl.sendDateTime(date, new DateTime()));
Params.Add("@id", BLCtrl.sendString(id, ""));
Params.Add("@ApearsWell2", BLCtrl.sendBool(ApearsWell, false));
Params.Add("@ApearsWellT2", BLCtrl.sendString(ApearsWellT, ""));
Params.Add("@PupilsEqual2", BLCtrl.sendBool(PupilsEqual, false));
Params.Add("@PupilsEqualT2", BLCtrl.sendString(PupilsEqualT, ""));
Params.Add("@TmNormal2", BLCtrl.sendBool(TmNormal, false));
Params.Add("@TmNormalT2", BLCtrl.sendString(TmNormalT, ""));
Params.Add("@Oropharynx2", BLCtrl.sendBool(Oropharynx, false));
Params.Add("@OropharynxT2", BLCtrl.sendString(OropharynxT, ""));
Params.Add("@Atraumatic2", BLCtrl.sendBool(Atraumatic, false));
Params.Add("@AtraumaticT2", BLCtrl.sendString(AtraumaticT, ""));
Params.Add("@HeentMucosa2", BLCtrl.sendBool(HeentMucosa, false));
Params.Add("@HeentMucosaT2", BLCtrl.sendString(HeentMucosaT, ""));
Params.Add("@Supple2", BLCtrl.sendBool(Supple, false));
Params.Add("@SuppleT2", BLCtrl.sendString(SuppleT, ""));
Params.Add("@thyromegaly2", BLCtrl.sendBool(thyromegaly, false));
Params.Add("@thyromegalyT2", BLCtrl.sendString(thyromegalyT, ""));
Params.Add("@HeartsoundsRegular2", BLCtrl.sendBool(HeartsoundsRegular, false));
Params.Add("@HeartsoundsRegularT2", BLCtrl.sendString(HeartsoundsRegularT, ""));
Params.Add("@Murmur2", BLCtrl.sendBool(Murmur, false));
Params.Add("@MurmurT2", BLCtrl.sendString(MurmurT, ""));
Params.Add("@GoodAir2", BLCtrl.sendBool(GoodAir, false));
Params.Add("@GoodAirT2", BLCtrl.sendString(GoodAirT, ""));
Params.Add("@ClearToAuscultation2", BLCtrl.sendBool(ClearToAuscultation, false));
Params.Add("@ClearToAuscultationT2", BLCtrl.sendString(ClearToAuscultationT, ""));
Params.Add("@SymmetricalBreast2", BLCtrl.sendBool(SymmetricalBreast, false));
Params.Add("@SymmetricalBreastT2", BLCtrl.sendString(SymmetricalBreastT, ""));
Params.Add("@Palpable2", BLCtrl.sendBool(Palpable, false));
Params.Add("@PalpableT2", BLCtrl.sendString(PalpableT, ""));
Params.Add("@SkinChanges2", BLCtrl.sendBool(SkinChanges, false));
Params.Add("@SkinChangesT2", BLCtrl.sendString(SkinChangesT, ""));
Params.Add("@Nipple2", BLCtrl.sendBool(Nipple, false));
Params.Add("@NippleT2", BLCtrl.sendString(NippleT, ""));
Params.Add("@Axillary2", BLCtrl.sendBool(Axillary, false));
Params.Add("@AxillaryT2", BLCtrl.sendString(AxillaryT, ""));
Params.Add("@Soft2", BLCtrl.sendBool(Soft, false));
Params.Add("@SoftT2", BLCtrl.sendString(SoftT, ""));
Params.Add("@Tender2", BLCtrl.sendBool(Tender, false));
Params.Add("@TenderT2", BLCtrl.sendString(TenderT, ""));
Params.Add("@ABDdescription2", BLCtrl.sendString(ABDdescription, ""));
Params.Add("@BowelSounds2", BLCtrl.sendBool(BowelSounds, false));
Params.Add("@BowelSoundsT2", BLCtrl.sendString(BowelSoundsT, ""));
Params.Add("@RenalArtery2", BLCtrl.sendBool(RenalArtery, false));
Params.Add("@RenalArteryT2", BLCtrl.sendString(RenalArteryT, ""));
Params.Add("@Masses2", BLCtrl.sendBool(Masses, false));
Params.Add("@MassesT2", BLCtrl.sendString(MassesT, ""));
Params.Add("@Organomegaly2", BLCtrl.sendBool(Organomegaly, false));
Params.Add("@OrganomegalyT2", BLCtrl.sendString(OrganomegalyT, ""));
Params.Add("@SkinAbnormalities2", BLCtrl.sendBool(SkinAbnormalities, false));
Params.Add("@SkinAbnormalitiesT2", BLCtrl.sendString(SkinAbnormalitiesT, ""));
Params.Add("@SignificantScoliosis2", BLCtrl.sendBool(SignificantScoliosis, false));
Params.Add("@SignificantScoliosisT2", BLCtrl.sendString(SignificantScoliosisT, ""));
Params.Add("@Kyphosis2", BLCtrl.sendBool(Kyphosis, false));
Params.Add("@KyphosisT2", BLCtrl.sendString(KyphosisT, ""));
Params.Add("@Edema2", BLCtrl.sendBool(Edema, false));
Params.Add("@EdemaT2", BLCtrl.sendString(EdemaT, ""));
Params.Add("@EXTRash2", BLCtrl.sendBool(EXTRash, false));
Params.Add("@EXTRashT2", BLCtrl.sendString(EXTRashT, ""));
Params.Add("@Varicosities2", BLCtrl.sendBool(Varicosities, false));
Params.Add("@VaricositiesT2", BLCtrl.sendString(VaricositiesT, ""));
Params.Add("@Pppx42", BLCtrl.sendBool(Pppx4, false));
Params.Add("@Pppx4T2", BLCtrl.sendString(Pppx4T, ""));
Params.Add("@PedalEdema2", BLCtrl.sendBool(PedalEdema, false));
Params.Add("@PedalEdemaT2", BLCtrl.sendString(PedalEdemaT, ""));
Params.Add("@Toes2", BLCtrl.sendBool(Toes, false));
Params.Add("@ToesT2", BLCtrl.sendString(ToesT, ""));
Params.Add("@Pattelar2", BLCtrl.sendBool(Pattelar, false));
Params.Add("@PattelarT2", BLCtrl.sendString(PattelarT, ""));
Params.Add("@Gait2", BLCtrl.sendBool(Gait, false));
Params.Add("@GaitT2", BLCtrl.sendString(GaitT, ""));
Params.Add("@Speech2", BLCtrl.sendBool(Speech, false));
Params.Add("@SpeechT2", BLCtrl.sendString(SpeechT, ""));
Params.Add("@Female2", BLCtrl.sendBool(Female, false));
Params.Add("@FemaleT2", BLCtrl.sendString(FemaleT, ""));
Params.Add("@PelvicMucosa2", BLCtrl.sendInt(PelvicMucosa, 1));
Params.Add("@Kegels2", BLCtrl.sendInt(Kegels, 1));
Params.Add("@Cervix2", BLCtrl.sendString(Cervix, ""));
Params.Add("@VaginalWalls2", BLCtrl.sendBool(VaginalWalls, false));
Params.Add("@VaginalWallsT2", BLCtrl.sendString(VaginalWallsT, ""));
Params.Add("@Pap2", BLCtrl.sendBool(Pap, false));
Params.Add("@PapT2", BLCtrl.sendString(PapT, ""));
int result = dm.AddOrUpdatePhysicalExam(Params);
return(result);
}
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);
}
