// huy dat lich
public async Task <bool> SetNoBook(string CusNo_, string ShiftNo_, string Phone)
{
try
{
foreach (BookModel2 lay in menuList2)
{
if (lay.time == datee)
{
string sql = @"update Book set CusNo_='', ShiftNo_ ='" + ShiftNo_ + "',Phone='',TrangThai='' where Book.EmpNo_='" + EmpNo_1 + "' and TimeBook='" + lay.TimeBook + "'";
int result = await ex.setDataBFO(sql);
break;
}
}
return(true);
}
catch (Exception ex)
{
await DisplayAlert("error", ex.ToString(), "OK");
return(false);
}
}
public async void sentEmail(string toEmail, string subject, string name_cs
, string day, string time, string id_cli
, string id_fal)
{
//gan thong tin vao bien cuc bo
getInfoCs(id_cli, id_fal);
try
{
string username = "******";
string password = "******";
System.Net.NetworkCredential nc = new
System.Net.NetworkCredential(username, password);
MailMessage MailMessage = new MailMessage();
MailMessage.From = new System.Net.Mail.MailAddress("*****@*****.**");
MailMessage.To.Add(toEmail);
//subject email
MailMessage.Subject = subject;
MailMessage.IsBodyHtml = true;
//read file
//var assembly = typeof(App).GetTypeInfo().Assembly;
//Stream stream = assembly.GetManifestResourceStream("CLINIC.Droid.index.txt");
//write stream
//string text = "";
//using (var reader = new System.IO.StreamReader(stream))
//{
// text = reader.ReadToEnd();
//}
//string html = text;
//MailMessage.Body = html;
MailMessage.Body = @"<html>
<body>
<p>Chào " + name_cs + @",</p>
<p>Bạn đã đặt lịch hẹn tại phong khám " + name_cli_p + @"</p>
<p>Chuyên khoa " + name_fal_p + @"</p>
<p>Vào lúc " + time + @"</p>
<p>Ngày " + day + @"</p>
<p>Trân Trọng</p>
</body>
</html>
";
SmtpClient SmtpClient = new SmtpClient("smtp.gmail.com");
SmtpClient.EnableSsl = true;
SmtpClient.Credentials = nc;
SmtpClient.Port = 587;
SmtpClient.Send(MailMessage);
}
catch (Exception ex)
{
Console.WriteLine(ex.ToString());
}
}
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");
}
}