public Task <bool> RemoveFuelStationFromProject(dto_project_remove_fuelstationC _dto) { bool _is_removed = false; if (_dto == null) { AddErrorMessage("Update Error", "Save Error", "DTO Is Null!"); _is_removed = false; return(Task.FromResult(_is_removed)); } if (_dto.project_id == 0) { AddErrorMessage("Error", "Error", "Project Id Is Missing"); _is_removed = false; return(Task.FromResult(_is_removed)); } if (_dto.fuel_station_id == 0) { AddErrorMessage("Error", "Error", "Fuel Station Id Is Missing"); _is_removed = false; return(Task.FromResult(_is_removed)); } assign_project_fuel_stationC _existing = null; try { using (var _db = fnn.GetDbContext()) { _existing = (from k in _db.ASSIGN_PROJECT_FUEL_STATIONS where k.fuel_station_id == _dto.fuel_station_id & k.project_id == _dto.project_id & k.delete_id == 0 select k).FirstOrDefault(); if (_existing == null) { AddErrorMessage("Error", "Error", "No Associated Assigned Object Found"); _is_removed = false; return(Task.FromResult(_is_removed)); } var _result = DbHelper.DeleteRecordWithDeleteId(new DbHelperDeleteRecordC() { pk_col_name = "un_id", pk_id = _existing.un_id, table_name = FleetManager.DbBase.tableNames.assign_fuelstation_project_tb.ToDbSchemaTable() }, _db); if (_result == null || _result == false) { AddErrorMessage("Delete Error", "Delete Error", "Error Encountered While Trying To Delete Record"); _is_removed = false; return(Task.FromResult(_is_removed)); } else { var _sql = string.Format("update {0} set no_of_fuel_stations=(no_of_fuel_stations - 1),fs_timestamp={1} where project_id={2} and delete_id=0", _table_name.ToDbSchemaTable(), fnn.GetUnixTimeStamp(), _existing.project_id); _db.Database.Connection.Execute(_sql); _is_removed = true; _db.SaveChanges(); return(Task.FromResult(_is_removed)); } } } catch (SqlException ex) { _is_removed = false; LoggerX.LogException(ex); } catch (DbException ex) { _is_removed = false; LoggerX.LogException(ex); } catch (Exception ex) { _is_removed = false; LoggerX.LogException(ex); } return(Task.FromResult(_is_removed)); }
public Task <assign_project_fuel_stationC> AssignFuelStationToProject(dto_project_assign_fuelstationC _dto) { projectC _project = null; fuel_stationC _fuel_station = null; assign_project_fuel_stationC _obj = null; if (_dto == null) { AddErrorMessage("Update Error", "Save Error", "DTO Is Null!"); _project = null; return(Task.FromResult(_obj)); } if (_dto.project_id == 0) { AddErrorMessage("Error", "Error", "Project Id Is Missing"); return(Task.FromResult(_obj)); } if (_dto.fuel_station_id == 0) { AddErrorMessage("Error", "Error", "Fuel Station Id Is Missing"); return(Task.FromResult(_obj)); } try { using (var _db = fnn.GetDbContext()) { _fuel_station = (from k in _db.FUEL_STATIONS where k.fuel_station_id == _dto.fuel_station_id & k.delete_id == 0 select k).FirstOrDefault(); if (_fuel_station == null) { AddErrorMessage("Error", "Error", "No Associated Fuel Station Found"); _obj = null; return(Task.FromResult(_obj)); } _project = (from k in _db.PROJECTS where k.project_id == _dto.project_id & k.delete_id == 0 select k).FirstOrDefault(); if (_project == null) { AddErrorMessage("Error", "Error", "No Associated Project Found"); _obj = null; return(Task.FromResult(_obj)); } _obj = new assign_project_fuel_stationC() { project_id = _project.project_id, fuel_station_id = _fuel_station.fuel_station_id, created_by_user_id = m_logged_user.user_id, fs_timestamp = fnn.GetUnixTimeStamp(), server_edate = fnn.GetServerDate() }; _db.ASSIGN_PROJECT_FUEL_STATIONS.Add(_obj); var _retVal = _db.SaveChangesWithDuplicateKeyDetected(); if (_retVal == null || _retVal.Value == true) { AddErrorMessage("Duplicate Key Error", "Duplicate Key Error", "You Have Entered A Duplicate Fuel Station Assignment"); _obj = null; return(Task.FromResult(_obj)); } var _sql = string.Format("update {0} set no_of_fuel_stations=(no_of_fuel_stations + 1),fs_timestamp={1} where project_id={2} and delete_id=0", _table_name.ToDbSchemaTable(), fnn.GetUnixTimeStamp(), _project.project_id); _db.Database.Connection.Execute(_sql); _db.SaveChanges(); // } } catch (SqlException ex) { _obj = null; LoggerX.LogException(ex); } catch (DbException ex) { _obj = null; LoggerX.LogException(ex); } catch (Exception ex) { _obj = null; LoggerX.LogException(ex); } return(Task.FromResult(_obj)); }