public async Task <bool> upateNhomChiTieu(NHOMCHITIEU nhomChiTieu) { try { await _connectionToDatabaseAsync.UpdateAsync(nhomChiTieu); return(true); } catch (Exception ex) { throw ex; } }
public async Task <NHOMCHITIEU> getNhomChiTieu(int maNhomChiTieu) { try { NHOMCHITIEU nhomCongViec = await _connectionToDatabaseAsync.Table <NHOMCHITIEU>().Where(ncv => (ncv.MaNhomChiTieu == maNhomChiTieu)).FirstOrDefaultAsync(); return(nhomCongViec); } catch (Exception ex) { throw ex; } }
public bool insertChiTieu(CHITIEU chiTieu) { try { _connectionToDatabase.RunInTransaction( () => { NHOMCHITIEU nhomChiTieu = _connectionToDatabase.Table <NHOMCHITIEU>().Where(ie => (ie.MaNhomChiTieu == chiTieu.MaNhomChiTieu)).FirstOrDefault(); if (nhomChiTieu == null) { throw new Exception("Không tìm nhóm chi tiêu này."); } THUCHITHANG thuChiThang = _connectionToDatabase.Table <THUCHITHANG>().Where(ie => (ie.MaThuChiThang == chiTieu.MaThuChiThang)).FirstOrDefault(); if (thuChiThang == null) { throw new Exception("Không tìm thấy thu-chi tháng với mã '" + chiTieu.MaThuChiThang + "'"); } CHITIEU currentChiTieu = _connectionToDatabase.Table <CHITIEU>().Where(ct => (ct.MaChiTieu == chiTieu.MaChiTieu)).FirstOrDefault(); if (currentChiTieu != null) { throw new Exception("Chi tiêu với mã tương ứng đã tồn tại."); } _connectionToDatabase.Insert(chiTieu); thuChiThang.SoDu -= (Int32)chiTieu.SoTien; _connectionToDatabase.Update(thuChiThang); }); return(true); } catch (Exception ex) { throw ex; } }
private async Task<bool> asyncDataNhomChiTieu() { try { var respone = await _serverModel.getAllNhomChiTieuAsync(); ObservableCollection<ServerDatabaseService.NhomChiTieu> listNhomChiTieu = respone.Body.getAllNhomChiTieuResult; foreach (ServerDatabaseService.NhomChiTieu nhom in listNhomChiTieu) { NHOMCHITIEU nhomChiTieu = await _localModel.getNhomChiTieu(nhom.MaNhomChiTieu); if (nhomChiTieu == null) // add new { nhomChiTieu = new NHOMCHITIEU(nhom.MaNhomChiTieu, nhom.TieuDe, nhom.MoTa); await _localModel.insertNhomChiTieu(nhomChiTieu); } else // update { nhomChiTieu.TieuDe = nhom.TieuDe; nhomChiTieu.MoTa = nhom.MoTa; await _localModel.upateNhomChiTieu(nhomChiTieu); } } return true; } catch (EndpointNotFoundException e) { throw new HttpRequestException("Không thể kết nối đến server. Vui lòng kiểm tra kết nối internet và thử lại."); } catch (HttpRequestException e) { throw new HttpRequestException("Không thể kết nối đến server. Vui lòng kiểm tra kết nối internet và thử lại."); } catch (Exception ex) { throw ex; } }
public async Task<bool> upateNhomChiTieu(NHOMCHITIEU nhomChiTieu) { try { await _connectionToDatabaseAsync.UpdateAsync(nhomChiTieu); return true; } catch (Exception ex) { throw ex; } }
private async Task<bool> asyncDataNhomChiTieu() { try { var respone = await _serverModel.getAllNhomChiTieuAsync(); ObservableCollection<ServerDatabaseService.NhomChiTieu> listNhomChiTieu = respone.Body.getAllNhomChiTieuResult; foreach (ServerDatabaseService.NhomChiTieu nhom in listNhomChiTieu) { NHOMCHITIEU nhomChiTieu = await _localModel.getNhomChiTieu(nhom.MaNhomChiTieu); if (nhomChiTieu == null) // add new { nhomChiTieu = new NHOMCHITIEU(nhom.MaNhomChiTieu, nhom.TieuDe, nhom.MoTa); await _localModel.insertNhomChiTieu(nhomChiTieu); } else // update { nhomChiTieu.TieuDe = nhom.TieuDe; nhomChiTieu.MoTa = nhom.MoTa; await _localModel.upateNhomChiTieu(nhomChiTieu); } } return true; } catch (Exception ex) { throw ex; } }