public bool deleteChiTieu(int maChiTieu) { try { _connectionToDatabase.RunInTransaction( () => { CHITIEU currentChiTieu = _connectionToDatabase.Table <CHITIEU>().Where(ic => (ic.MaChiTieu == maChiTieu)).FirstOrDefault(); if (currentChiTieu == null) { throw new Exception("Không tìm thấy chi tiêu có mã '" + maChiTieu + "'"); } THUCHITHANG thuChiThang = _connectionToDatabase.Table <THUCHITHANG>().Where(ie => (ie.MaThuChiThang == currentChiTieu.MaThuChiThang)).FirstOrDefault(); if (thuChiThang == null) { throw new Exception("Không tìm thấy thu-chi tháng với mã '" + currentChiTieu.MaThuChiThang + "'"); } _connectionToDatabase.Delete(currentChiTieu); thuChiThang.SoDu += (Int32)(currentChiTieu.SoTien); _connectionToDatabase.Update(thuChiThang); }); return(true); } catch (Exception ex) { throw ex; } }
public async Task <CHITIEU> getChiTieu(int maChiTieu) { try { CHITIEU chiTieu = await _connectionToDatabaseAsync.Table <CHITIEU>().Where(ic => (ic.MaChiTieu == maChiTieu)).FirstOrDefaultAsync(); return(chiTieu); } 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> asyncDataChiTieu(int maNguoiDung) { try { List<THUCHITHANG> localListThuChiThang = await _localModel.getAllThuChiThang(maNguoiDung); foreach (THUCHITHANG thuChi in localListThuChiThang) { List<CHITIEU> localListChiTieu = await _localModel.getAllChiTieu(thuChi.MaThuChiThang); ObservableCollection<ServerDatabaseService.ChiTieu> serverListChiTieu = new ObservableCollection<ServerDatabaseService.ChiTieu>(); foreach (CHITIEU cv in localListChiTieu) { ServerDatabaseService.ChiTieu thuNhap = new ServerDatabaseService.ChiTieu(); thuNhap.MaChiTieu = cv.MaChiTieu; thuNhap.MaNhomChiTieu = cv.MaNhomChiTieu; thuNhap.MaThuChiThang = cv.MaThuChiThang; thuNhap.MoTa = cv.MoTa; thuNhap.SoTien = cv.SoTien; thuNhap.ThoiGian = (Int32)(cv.ThoiGian); serverListChiTieu.Add(thuNhap); } var respone = await _serverModel.dataSyncChiTieuAsync(serverListChiTieu, thuChi.MaThuChiThang); serverListChiTieu = respone.Body.dataSyncChiTieuResult; var thamSo = await _serverModel.getThamSoAsync("ChiTieu"); int maChiTieu = thamSo.Body.getThamSoResult.GiaTri; foreach (ServerDatabaseService.ChiTieu cv in serverListChiTieu) { CHITIEU chiTieu = await _localModel.getChiTieu(cv.MaChiTieu); if (chiTieu == null) // add new { chiTieu = new CHITIEU(cv.MaChiTieu, cv.MaThuChiThang, cv.MaNhomChiTieu, (UInt32)cv.SoTien, cv.ThoiGian, cv.MoTa); _localModel.insertChiTieu(chiTieu); await _localModel.updateThamSo("ChiTieu", (++maChiTieu)); } else // update { chiTieu.MoTa = cv.MoTa; chiTieu.SoTien = (UInt32)cv.SoTien; _localModel.updateChiTieu(chiTieu); } } } 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 bool updateChiTieu(CHITIEU chiTieu) { try { _connectionToDatabase.RunInTransaction( () => { 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(ic => (ic.MaChiTieu == chiTieu.MaChiTieu)).FirstOrDefault(); if (currentChiTieu == null) throw new Exception("Không tìm thấy chi tiêu có mã '" + chiTieu.MaChiTieu + "'"); thuChiThang.SoDu -= (Int32)(chiTieu.SoTien - currentChiTieu.SoTien); currentChiTieu.MaNhomChiTieu = chiTieu.MaNhomChiTieu; currentChiTieu.SoTien = chiTieu.SoTien; currentChiTieu.MoTa = chiTieu.MoTa; _connectionToDatabase.Update(currentChiTieu); _connectionToDatabase.Update(thuChiThang); }); return true; } 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; } }