internal static void CreateCreditorStatementFromDeposit(FleetManager.Shared.Models.creditor_depositC _dep, BaseContext _db) { try { // } catch (SqlException ex) { LoggerX.LogException(ex); } catch (DbException ex) { LoggerX.LogException(ex); } catch (Exception ex) { LoggerX.LogException(ex); } }
internal static void DeleteCreditorDeposit(FleetManager.Shared.Models.creditor_depositC _dep, BaseContext _db) { if (_dep == null) { return; } try { } catch (SqlException ex) { LoggerX.LogException(ex); } catch (DbException ex) { LoggerX.LogException(ex); } catch (Exception ex) { LoggerX.LogException(ex); } }
public Task <bool> DeleteCreditorDeposit(int cr_deposit_id) { bool _record_deleted = false; FleetManager.Shared.Models.creditor_depositC _deposit = null; try { using (var _db = fnn.GetDbContext()) { _deposit = _db.CREDITOR_DEPOSITS.Where(e => e.cr_deposit_id == cr_deposit_id & e.delete_id == 0).FirstOrDefault(); if (_deposit == null) { AddErrorMessage("Error", "Error", "Unable To Find Deposit Object"); _record_deleted = false; return(Task.FromResult(_record_deleted)); } else { var _result = DbHelper.DeleteRecordWithDeleteId(new DbHelperDeleteRecordC() { pk_col_name = "cr_deposit_id", pk_id = _deposit.cr_deposit_id, table_name = DbHelper.GetTableSchemaName(FleetManager.DbBase.tableNames.creditor_deposit_tb) }, _db); if (_result == null || _result == false) { AddErrorMessage("Delete Error", "Delete Error", "Error Encountered While Trying To Delete Record"); _record_deleted = false; return(Task.FromResult(_record_deleted)); } else { _record_deleted = true; _db.SaveChanges(); } var _creditor = (from c in _db.CREDITORS_SET where c.cr_account_id == _deposit.cr_account_id & c.delete_id == 0 select c).FirstOrDefault(); if (_creditor != null) { var _last_deposit = (from k in _db.CREDITOR_DEPOSITS where k.delete_id == 0 orderby k.deposit_fs_id descending, k.cr_deposit_id select k).FirstOrDefault(); if (_last_deposit != null) { _creditor.last_cr_deposit_id = _last_deposit.cr_deposit_id; _creditor.last_pay_date = _last_deposit.deposit_date; } else { _creditor.last_cr_deposit_id = 0; _creditor.last_pay_date = null; } _creditor.fs_timestamp = fnn.GetUnixTimeStamp(); // _db.CREDITORS_SET.AddOrUpdateExtension(_creditor); _db.SaveChanges(); } } } } catch (SqlException ex) { LoggerX.LogException(ex); } catch (DbException ex) { LoggerX.LogException(ex); } catch (Exception ex) { LoggerX.LogException(ex); } if (_record_deleted) { Task.Run(() => { using (var _db = fnn.GetDbContext()) { //var _creditor = (from k in _db.CREDITORS_SET // where k.cr_account_id == _deposit.cr_account_id & k.delete_id == 0 // select k).FirstOrDefault(); //if (_creditor != null) //{ // _deposit = (from k in _db.CREDITOR_DEPOSITS // where k.cr_account_id == _creditor.cr_account_id & k.delete_id == 0 // orderby k.deposit_fs_id descending, k.cr_deposit_id // select k).FirstOrDefault(); //} fnn.DeleteCreditorDeposit(_deposit, _db); _db.SaveChanges(); } }); } return(Task.FromResult(_record_deleted)); }