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 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 <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 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);
}