public async Task <ValueDTO <HocPhi> > GetData(int thang)
{
ObjectSQL <int> NgayNghi = await new DiemDanh().GetAbsent(App.StudentSeclect.ID, thang, Convert.ToByte(1));
ValueDTO <HocPhi> val = new ValueDTO <HocPhi>();
if (NgayNghi.Error == 0)
{
NghiP = NgayNghi.Value;
val = await new HocPhi().GetData(thang, App.StudentSeclect.IDLoaiHocSinh, App.StudentSeclect.IDKhoi, NgayNghi.Value);
if (val.Error != 0)
{
await DisplayAlert("Thông báo", new HandleError().IDErrorToNotify(val.Error), "OK");
FillData();
}
}
else
{
await DisplayAlert("Thông báo", new HandleError().IDErrorToNotify(NgayNghi.Error), "OK");
FillData();
}
return(val);
}
public async void LoadListStudent()
{
val = await new ListStudentInClassViewModel().GetData(App.StudentSeclect.IDLop);
if (val.Error != 0)
{
await DisplayAlert("Thông báo", new HandleError().IDErrorToNotify(val.Error), "OK");
}
}
public async Task <string> Create([FromBody] ValueDTO data, int id)
{
var writedData = _data.AddOrUpdate(id, data.Value);
string dataFileName = "node" + _port + @"\data.db";
await WriteReadToDatabase.Write(dataFileName, _data.dataBase);
return(writedData);
}
public async void GetData()
{
ValueDTO <BangDiem> val = await new BangDiem().GetData(App.StudentSeclect.ID);
foreach (BangDiem a in val.ListT)
{
lst.Add(a);
}
}
public async void GetData(int IDStudent)
{
ValueDTO <XinPhep> val = await new XinPhep().GetData(IDStudent);
if (val.Error == 0)
{
lst = val.ListT;
}
else
{
await DisplayAlert("Thông báo", new HandleError().IDErrorToNotify(val.Error), "OK");
}
}
public async void GetData()
{
HK = App.StudentSeclect;
Error = "";
ValueDTO <DTBTong> valT = await new DTBTong().GetData(HK.ID, HK.IDLop);
if (valT.Error == 0)
{
Sum = valT.ListT[0];
}
else
{
Error = new HandleError().IDErrorToNotify(valT.Error);
return;
}
ValueDTO <DTBMon> valM = await new DTBMon().GetData(HK.ID, HK.IDLop, 1);
if (valT.Error == 0)
{
LstDTBI = valM.ListT;
}
else
{
Error = new HandleError().IDErrorToNotify(valM.Error);
return;
}
valM = await new DTBMon().GetData(HK.ID, HK.IDLop, 2);
if (valT.Error == 0)
{
LstDTBII = valM.ListT;
}
else
{
Error = new HandleError().IDErrorToNotify(valM.Error);
return;
}
valM = await new DTBMon().GetData(HK.ID, HK.IDLop, 0);
if (valT.Error == 0)
{
LstDTBCN = valM.ListT;
}
else
{
Error = new HandleError().IDErrorToNotify(valM.Error);
return;
}
}
public async void NotifySchool()
{
ValueDTO <NotifyModel> val = await new NotifyViewModel().NotifySchool();
if (val.Error != 0)
{
lblNotify.Text = "Vui lòng thử lại.";
await DisplayAlert("Thông báo", new HandleError().IDErrorToNotify(val.Error), "OK");
}
else
{
lstNS = val.ListT;
}
}
public async void GetData()
{
ValueDTO <DiemDanh> val = await new DiemDanh().GetData(App.StudentSeclect.ID);
if (val.Error == 0)
{
lst = val.ListT;
lst.Sort(new SortDiemDanh());
lst.Reverse();
}
else
{
await DisplayAlert("Thông báo", new HandleError().IDErrorToNotify(val.Error), "OK");
}
}
public async void GetValue(int month)
{
ValueDTO <HocPhi> val = await GetData(month);
if (val.Error == 0)
{
if (val.ListT.Count == 0)
{
FillData();
}
else
{
FillData(val.ListT[0], month);
}
}
}
public NSchoolPage()
{
InitializeComponent();
NotifySchool();
if (lstNS.Count != 0)
{
List <NotifyViewModel> lst = new List <NotifyViewModel>();
foreach (var i in lstNS)
{
lst.Add(new NotifyViewModel(i.ID, i.TenThongBao, i.Ngay));
}
lst = lst.OrderByDescending(p => p.ID).ToList();
lvLstNotify.ItemsSource = lst;
StackLayoutNS.Children.Remove(lblNotify);
lvLstNotify.ItemSelected += async(sender, e) =>
{
if (lvLstNotify.SelectedItem != null)
{
ValueDTO <ThongBaoTruong> val = await valThongBaoTruong.GetContent((int)((NotifyViewModel)e.SelectedItem).ID);
if (val.Error != 0)
{
await DisplayAlert("Thông báo",
new HandleError().IDErrorToNotify(val.Error), "OK");
}
else
{
if (val.ListT[0].NoiDung.Length >= 1000)
{
await Navigation.PushAsync(new ShowNewPage((string)((NotifyViewModel)e.SelectedItem).TenThongBao, val.ListT[0].Ngay.ToString("dd-MM-yyyy"), val.ListT[0].NoiDung));
}
else
{
await DisplayAlert((string)((NotifyViewModel)e.SelectedItem).TenThongBao, val.ListT[0].NoiDung, "OK");
}
}
}
lvLstNotify.SelectionMode = ListViewSelectionMode.None;
lvLstNotify.SelectionMode = ListViewSelectionMode.Single;
};
}
else
{
StackLayoutNS.Children.Remove(lvLstNotify);
}
}
public async Task <bool> LoadSpeciesPoint()
{
ValueDTO <LoaiDiem> val = await new LoaiDiem().GetData();
if (val.Error != 0)
{
await DisplayAlert("Thông báo", error.IDErrorToNotify(val.Error), "OK");
btn_Login.IsEnabled = true;
App.ResetSource();
return(false);
}
else
{
App.lstLoaiDiems = val.ListT;
return(true);
}
}
public async Task <bool> LoadLink()
{
ValueDTO <LienKetPHvsHS> val = await new LienKetPHvsHS().GetData(App.IDAccount);
if (val.Error != 0)
{
await DisplayAlert("Thông báo", error.IDErrorToNotify(val.Error), "OK");
btn_Login.IsEnabled = true;
App.ResetSource();
return(false);
}
else
{
App.lstPHvsHs = val.ListT;
return(true);
}
}
public string Put(int id, string value)
{
using (var client = new HttpClient())
{
client.BaseAddress = new Uri("http://localhost:10000/");
ValueDTO data = new ValueDTO {
Value = value
};
string postBody = JsonConvert.SerializeObject(data);
client.DefaultRequestHeaders.Accept.Add(new MediaTypeWithQualityHeaderValue("application/json"));
var response = client.PutAsync("proxy/" + id.ToString(), new StringContent(postBody, Encoding.UTF8, "application/json")).Result;
if (response.StatusCode == HttpStatusCode.OK)
{
return("Success");
}
return("Error");
}
}
public async Task <bool> LoadSubject()
{
ValueDTO <MonHoc> val = await new MonHoc().GetData();
if (val.Error != 0)
{
await DisplayAlert("Thông báo", error.IDErrorToNotify(val.Error), "OK");
btn_Login.IsEnabled = true;
App.ResetSource();
return(false);
}
else
{
App.lstMonHocs = val.ListT;
return(true);
}
}
public async Task <ValueDTO <NotifyModel> > GetDataSchool()
{
ValueDTO <NotifyModel> val = new ValueDTO <NotifyModel>();
DataTableSQL dtSql = await ExecuteQuery("SelectListThongBaoTruong");
if (dtSql.Error == 0)
{
foreach (DataRow dr in dtSql.Data.Rows)
{
val.ListT.Add(new NotifyModel(dr));
}
}
else
{
val.Error = dtSql.Error;
}
return(val);
}
public async Task <bool> LoadDataInDatabase()
{
if (!(await LoadLink()))
{
return(false);
}
if (!(await LoadConduct()))
{
return(false);
}
if (!(await LoadSpeciesPoint()))
{
return(false);
}
if (!(await LoadSubject()))
{
return(false);
}
foreach (LienKetPHvsHS i in App.lstPHvsHs)
{
#region Load Strudent
ValueDTO <ThongTinHS> val = await valHS.GetDaTa(i.IDHocSinh);
if (val.Error != 0)
{
btn_Login.IsEnabled = true;
App.ResetSource();
return(false);
}
else
{
App.lstStudents.Add(val.ListT[0]);
}
#endregion
}
App.StudentSeclect = App.lstStudents.FirstOrDefault();
return(true);
}
public async Task <ValueDTO <NotifyModel> > GetDataStudent(int IDHocSinh)
{
ValueDTO <NotifyModel> val = new ValueDTO <NotifyModel>();
DataTableSQL dtSql = await ExecuteQuery("SelectListThongBaoHS",
new SqlParameter("@IDHocSinh", SqlDbType.Int) { Value = IDHocSinh });
if (dtSql.Error == 0)
{
foreach (DataRow dr in dtSql.Data.Rows)
{
val.ListT.Add(new NotifyModel(dr));
}
}
else
{
val.Error = dtSql.Error;
}
return(val);
}
public async Task <ValueDTO <ModelListTeacher> > GetData(int IDLop)
{
ValueDTO <ModelListTeacher> val = new ValueDTO <ModelListTeacher>();
DataTableSQL dtSQL = await ExecuteQuery("SelectThongTinGV",
new SqlParameter("@IDLop", SqlDbType.Int) { Value = IDLop });
if (dtSQL.Error == 0)
{
foreach (DataRow dr in dtSQL.Data.Rows)
{
val.ListT.Add(new ModelListTeacher(dr));
}
}
else
{
val.Error = dtSQL.Error;
}
return(val);
}
public async Task <ValueDTO <ModelListStudent> > GetData(int IDClass)
{
ValueDTO <ModelListStudent> val = new ValueDTO <ModelListStudent>();
DataTableSQL dtSQL = await ExecuteQuery("SelectHocSinhTrongLop",
new SqlParameter("@IDLop", SqlDbType.Int) { Value = IDClass });
if (dtSQL.Error == 0)
{
foreach (DataRow dr in dtSQL.Data.Rows)
{
val.ListT.Add(new ModelListStudent(dr));
}
}
else
{
val.Error = dtSQL.Error;
}
return(val);
}
public async void GetList()
{
ValueDTO <ThoiKhoaBieu> val = await new ThoiKhoaBieu().GetData(App.StudentSeclect.IDLop);
if (val.Error == 0)
{
for (int i = 0; i < 7; i++)
{
lst.Add(new List <ThoiKhoaBieu>());
}
foreach (ThoiKhoaBieu Item in val.ListT)
{
if (!Item.TenMon.Equals("Trống"))
{
lst[Item.Thu - 1].Add(Item);
}
}
}
}
public async Task <ValueDTO <TaiKhoan> > PostUserToDatabase(string NameUser, string PasswordUser)
{
ValueDTO <TaiKhoan> val = new ValueDTO <TaiKhoan>();
DataTableSQL dtSql = await ExecuteQuery("DangNhapPH",
new SqlParameter("@TaiKhoan", SqlDbType.VarChar) { Value = NameUser },
new SqlParameter("@MatKhau", SqlDbType.VarChar) { Value = PasswordUser });
if (dtSql.Error == 0)
{
foreach (DataRow dr in dtSql.Data.Rows)
{
val.ListT.Add(new TaiKhoan(dr));
}
}
else
{
val.Error = dtSql.Error;
}
return(val);
}
public async Task <string> Put(int id, [FromBody] ValueDTO data)
{
return(await ProxyModel.PutValue(id, data.Value));
}
private async void btn_Login_Clicked(object sender, EventArgs e)
{
btn_Login.IsEnabled = false;
int val = new ModelLogin().CheckEntryNull(Entry_Username.Text, Entry_Password.Text);
if (val == 0)
{
ValueDTO <TaiKhoan> tk = await new LoginViewModel().CheckLogin(Entry_Username.Text, Entry_Password.Text);
if (tk.Error == 0)
{
if (tk.ListT.Count == 1)
{
App.IDAccount = tk.ListT[0].ID;
App.UserName = tk.ListT[0].UserName;
if (await LoadDataInDatabase())
{
await DisplayAlert("Thông báo", "Đăng nhập thành công", "Ok");
App.lstLoaiDiems.Sort(new SortLoaiDiem());
Application.Current.MainPage = new MainPage();
}
else
{
await DisplayAlert("Thông báo", "Đăng nhập thất bại. Không thể load được vì mạng yếu. hoặc chưa bật mạng vui lòng kiểm tra lại.", "OK");
LoginFaild();
btn_Login.IsEnabled = true;
}
}
else
{
await DisplayAlert("Thông báo", "Đăng nhập thất bại.\nTài khoản hoặc mật khẩu không chính xác", "OK");
LoginFaild();
btn_Login.IsEnabled = true;
}
}
else
{
await DisplayAlert("Thông báo", error.IDErrorToNotify(tk.Error), "OK");
btn_Login.IsEnabled = true;
}
}
else
{
switch (val)
{
case 1:
{
await DisplayAlert("Thông báo", "Vui Lòng nhập TÀI KHOẢN", "OK");
Entry_Username.Focus();
break;
}
case 2:
{
await DisplayAlert("Thông báo", "Vui Lòng nhập MẬT KHẨU", "OK");
Entry_Password.Focus();
break;
}
default:
{
break;
}
}
btn_Login.IsEnabled = true;
}
}
