public Task <List <vh_expense_transC> > GetExpensesByExpenseType(dto_fs_rangeC _dto) { List <vh_expense_transC> _list = null; if (_dto == null) { AddErrorMessage("Error", "Error", "Expense Object Can Not Be Null"); return(Task.FromResult(_list)); } if (_dto.filter_id == 0) { AddErrorMessage("Error", "Error", "Filter Id Can Not Be Null"); return(Task.FromResult(_list)); } string _sql = null; try { using (var _db = fnn.GetDbConnection()) { if (_dto.fs_time_stamp == 0) { _sql = string.Format("select * from {0} where delete_id = 0", _table_name.ToDbSchemaTable()); _list = _db.Query <vh_expense_transC>(_sql).ToList(); } else { _sql = string.Format("select * from {0} where exp_type_id = {1} and fs_timestamp > {2} and fs_timestamp < {3} and delete_id = 0", _table_name.ToDbSchemaTable(), _dto.filter_id, _dto.start_fs_id, _dto.end_fs_id); _list = _db.Query <vh_expense_transC>(_sql).ToList(); } } } catch (SqlException ex) { LoggerX.LogException(ex); } catch (DbException ex) { LoggerX.LogException(ex); } catch (Exception ex) { LoggerX.LogException(ex); } return(Task.FromResult(_list)); }
public Task <List <creditor_depositC> > GetAllCreditorDepositsByRange(dto_fs_rangeC _dto) { List <creditor_depositC> _list = null; if (_dto == null) { AddErrorMessage("Error", "Error", "DTO Can Not Be Null"); return(Task.FromResult(_list)); } string _sql = null; try { using (var _db = fnn.GetDbConnection()) { if (_dto.fs_time_stamp == 0) { _sql = string.Format("select * from {0} where (deposit_fs_id>={1} and deposit_fs_id <= {2}) and delete_id = 0", FleetManager.DbBase.tableNames.creditor_deposit_tb.ToDbSchemaTable(), _dto.start_fs_id, _dto.end_fs_id); _list = _db.Query <creditor_depositC>(_sql).ToList(); } else { _sql = string.Format("select * from {0} where (deposit_fs_id >={1} and deposit_fs_id <= {2}) and fs_timestamp >{3}", FleetManager.DbBase.tableNames.creditor_deposit_tb.ToDbSchemaTable(), _dto.start_fs_id, _dto.end_fs_id, _dto.fs_time_stamp); _list = _db.Query <creditor_depositC>(_sql).ToList(); } } } catch (SqlException ex) { LoggerX.LogException(ex); } catch (DbException ex) { LoggerX.LogException(ex); } catch (Exception ex) { LoggerX.LogException(ex); } return(Task.FromResult(_list)); }