async Task Lodate()
{
var json = await ex.getDataBFO(@"select [AccountName],[Password],[No_] ,[E-Mail]as Mail,[Name],Customer.Role as Roles from [Customer] where [AccountName]='" + Username.Text + "' and [Password]='" + Password.Text + "' and [Customer].[Role]='0' ");//where [EmpNo_]='" + mabs.ToString() + "'and [DateBook] ='" + today + "'
foreach (var item in json)
{
loginabc.AccountName = item["AccountName"].ToString();
loginabc.Password = item["Password"].ToString();
loginabc.Mail = item["Mail"].ToString();
loginabc.CusNo_ = item["No_"].ToString();
loginabc.Name = item["Name"].ToString();
loginabc.Role = item["Roles"].ToString();
menuList2.Add(loginabc);
}
var json2 = await ex.getDataBFO(@" select Employee.AccountName as AccountName ,Employee.Password as Password,Employee.EmpNo_ as EmpNO, Employee.[E-Mail] as MaiEmp, Employee.Name as EmPName,Employee.Role as Roles from [Employee] where [AccountName]='" + Username.Text + "' and [Password]='" + Password.Text + "'and Employee.[Role]='1'");
foreach (var item in json2)
{
loginabc.AccountName = item["AccountName"].ToString();
loginabc.Password = item["Password"].ToString();
loginabc.Name = item["EmPName"].ToString();
loginabc.Role = item["Roles"].ToString();
loginabc.EmpNo_ = item["EmpNO"].ToString();
menuList2.Add(loginabc);
}
foreach (LoginModels dc in menuList2)
{
try
{
if (dc.AccountName == Username.Text && dc.Password == Password.Text && dc.Role == "0")
{
await App.PersonRepo.AddNewPersonAsync(dc.AccountName, dc.Password, dc.CusNo_, dc.EmpNo_, dc.Role);
CCode = dc.CusNo_.ToString();
Mailc = dc.Mail.ToString();
Name_cus = dc.Name.ToString();
navigationService.setLogin();
}
else if (dc.AccountName == Username.Text && dc.Password == Password.Text && dc.Role == "1")
{
await App.PersonRepo.AddNewPersonAsync(dc.AccountName, dc.Password, dc.CusNo_, dc.EmpNo_, dc.Role);
EmPNo = dc.EmpNo_.ToString();
navigationService.setLoginbs();
}
else
{
await DisplayAlert("thong bao", "Tài khoản hoặc mật khẩu không đúng ?", "ok");
}
}
catch (Exception ex)
{
await DisplayAlert("Thông báo", ex.Message, "ok");
}
}
}
async Task LoadData(string mabs, string today)// hom nay
{
var id_dtor = Views.Login.EmPNo;
var id_dtor2 = App.Empo;
if (id_dtor != null)
{
sql = @"SELECT[BookNo_] ,[CusNo_] ,[NameCus] ,[Name] ,[Phone] as Phone_Cus ,[Adr] ,[DateBook],[TimeBook],[EmpNo_] ,[NameEmp] ,[Phone No_] as Phone_Emp ,[CliNo_],[NameCli],[SubCliNo_],[TimeShift],[TimeShift2],[NameTime],[TrangThai] FROM[BFOCLINIC].[dbo].[Book] where EmpNo_ = '" + id_dtor + "' and DateBook = '" + today + "'";
}
else
{
sql = @"SELECT[BookNo_] ,[CusNo_] ,[NameCus] ,[Name] ,[Phone] as Phone_Cus ,[Adr] ,[DateBook],[TimeBook],[EmpNo_] ,[NameEmp] ,[Phone No_] as Phone_Emp ,[CliNo_],[NameCli],[SubCliNo_],[TimeShift],[TimeShift2],[NameTime],[TrangThai] FROM[BFOCLINIC].[dbo].[Book] where EmpNo_ = '" + id_dtor2 + "' and DateBook = '" + today + "'";
}
var json = await ex.getDataBFO(sql);
foreach (var item in json)
{
_cldh = new BookModel2();
_cldh.TimeBook = DateTime.Parse(item["TimeBook"].ToString());
_cldh.DateBook = DateTime.Parse(item["DateBook"].ToString());
_cldh.date = _cldh.DateBook.ToString("yyyy/MM/dd");
_cldh.time = _cldh.TimeBook.ToString("hh:mm:ss");
_cldh.EmpNo_ = item["EmpNo_"].ToString();
_cldh.TrangThai = item["TrangThai"].ToString();
menuList2.Add(_cldh);
}
}
public async Task Loadata()
{
string sql = @"SELECT [CliNo_]
,[Name]
,[Adr]
,[Phone]
,[Mail]
,[Descrip]
FROM [Clinic]";
try
{
var json = await ex.getDataBFO(sql);
foreach (var item in json)
{
varClinic = new ClinicModel();
varClinic.Name = item["Name"].ToString();
varClinic.CliNo_ = item["CliNo_"].ToString();
varClinic.Address = item["Adr"].ToString();
varClinic.Phone = item["Phone"].ToString();
varClinic.Email = item["Mail"].ToString();
varClinic.Description = item["Descrip"].ToString();
listClinic.Add(varClinic);
}
mylist.ItemsSource = listClinic;
}
catch (Exception ex)
{
await DisplayAlert("thong bao", ex.ToString(), "ÖK");
}
}
// get du lieu
async Task LoadData(string prono_, string cusNo_)
{
var abc = prono_;
var json = await ex.getDataBFO(@"SELECT [ProLineNo_]
,[DisProLine].[DisNo_] as DisNo_
,[DisProLine].[Diagnose] as Diagnose
,[DisProLine].[StaringDate] as StaringDate
,[Duration]
,[DisProLine].[Descrip] as Descrip
,DisPro.CusNo_ as CusNo_
FROM[DisProLine],DisPro where DisPro.ProNo_ = '" + prono_ + "' and DisProLine.ProLineNo_='" + abc + "' ");
foreach (var item in json)
{
DisProModelss _cldh = new DisProModelss();
_cldh = new DisProModelss();
_cldh.ProLineNo_ = item["ProLineNo_"].ToString();
_cldh.DisNo_ = item["DisNo_"].ToString();
_cldh.Diagnose = item["Diagnose"].ToString();
_cldh.StaringDate = DateTime.Parse(item["StaringDate"].ToString());
_cldh.staringdate = _cldh.StaringDate.ToString("dd/MM/yyyy");
_cldh.Duration = DateTime.Parse(item["Duration"].ToString());
_cldh.duration = _cldh.Duration.ToString("dd/MM/yyyy");
_cldh.Descrip = item["Descrip"].ToString();
_cldh.CusNo_ = item["CusNo_"].ToString();
menuList2.Add(_cldh);
}
}
async Task LoadData()
{
/*** docNo_ mã chuẩn đoán
* symptoms chịu chứng
* DisNo_ mã bệnh
* nameofDis tên bệnh
* kết luận của bác sĩ summary
* treatments phuong phap dieu chỉ
***/
var json = await ex.getDataBFO(@"Select DisPro.ProNo_ as ProNo_
,Employee.[EmpNo_] as ID_Emp
,Employee.Name as Name_Emp
, CusNo_ ,Customer.Name as Name_Cus
, Customer.[Date of Birth] as DateBirth_Cus
,Customer.[Address] as Address
,Customer.[Phone No_] as Phone
, [StaringDate]
,[EndingDate]
,Employee.[CliNo_] as CLiNo_
,Clinic.Name as CliName
,Clinic.Adr as CliAdr
,Clinic.Phone as CliPhone
FROM [DisPro], Employee, Customer, Clinic where DisPro.EmpNo_=Employee.EmpNo_ and DisPro.CusNo_= '" + cusno + "' and DisPro.CliNo_= Clinic.CliNo_ and Customer.No_='" + cusno + "'or DisPro.EmpNo_=Employee.EmpNo_ and DisPro.CusNo_= '" + cusno2 + "' and DisPro.CliNo_= Clinic.CliNo_ and Customer.No_='" + cusno2 + "'");
foreach (var item in json)
{
DisProfileModels _cldh = new DisProfileModels();
_cldh = new DisProfileModels();
_cldh.ID_Emp = item["ID_Emp"].ToString();
_cldh.Name_Emp = item["Name_Emp"].ToString();
_cldh.CusNo_ = item["CusNo_"].ToString();
_cldh.Name_Cus = item["Name_Cus"].ToString();
_cldh.DateBirth_Cus = DateTime.Parse(item["DateBirth_Cus"].ToString());
_cldh.dateofbirth = _cldh.DateBirth_Cus.ToString("yyyy/MM/dd");
_cldh.StaringDate = DateTime.Parse(item["StaringDate"].ToString());
_cldh.straidate = _cldh.StaringDate.ToString("yyyy/MM/dd");
_cldh.EndingDate = DateTime.Parse(item["EndingDate"].ToString());
_cldh.endingdate = _cldh.EndingDate.ToString("yyyy/MM/dd");
_cldh.CliNo_ = item["CLiNo_"].ToString();
_cldh.CliName = item["CliName"].ToString();
_cldh.CliAdr = item["CliAdr"].ToString();
_cldh.CliPhone = item["CliPhone"].ToString();
_cldh.ProNo_ = item["ProNo_"].ToString();
_cldh.Address = item["Address"].ToString();
_cldh.Phone = item["Phone"].ToString();
menuList2.Add(_cldh);
}
}
async Task LoadData(string prono_)
{
var abc = prono_;
var json = await ex.getDataBFO(@"SELECT PresLine.[PrecLineNo_] as PrecLineNo_ , PresLine.[MedicineNo_] as MedicineNo_ , Item.[Name] as Name, Item.[Base Unit of Measure] as [Base_Unit_of_Measure], PresLine.[Dosage] as Dosage, PresLine.[Amount] as Amount , Item.Origination as Origination , Item.Pharmacodynamic as Pharmacodynamic
FROM [PresLine], [Pres], Item where Pres.ProNo_ = '" + prono_ + "' and PresLine.PrecLineNo_= '" + abc + "' and PresLine.[MedicineNo_]= Item.No_");
foreach (var item in json)
{
ItemModel _cldh = new ItemModel();
_cldh = new ItemModel();
_cldh.PrecLineNo_ = item["PrecLineNo_"].ToString();
_cldh.MedicineNo_ = item["MedicineNo_"].ToString();
_cldh.Name = item["Name"].ToString();
_cldh.Base_Unit_of_Measure = item["Base_Unit_of_Measure"].ToString();
_cldh.Dosage = item["Dosage"].ToString();
_cldh.Amount = item["Amount"].ToString();
_cldh.Origination = item["Origination"].ToString();
_cldh.Pharmacodynamic = item["Pharmacodynamic"].ToString();
menuList2.Add(_cldh);
}
}
//lay thong tin book
public async void getInfoCs(string id_cli, string id_fal)
{
string sql = @"SELECT Faculty.Name, Clinic.Name, Clinic.Adr
FROM Faculty,Clinic
WHERE Faculty.FalNo_='" + id_fal + @"' and Clinic.CliNo_='" + id_cli + @"'";
try
{
var json = await ex.getDataBFO(sql);
foreach (var item in json)
{
name_fal_p = item["Name"].ToString();
name_cli_p = item["Name1"].ToString();
address_cli_p = item["Adr"].ToString();
}
}
catch (Exception ex)
{
Console.WriteLine("eamilservice error" + ex.ToString());
}
}