public static int Create(CityDataModel data, RequestProfile requestProfile) { var sql = Save(data, "Create", requestProfile); var newId = DBDML.RunScalarSQL("City.Insert", sql, DataStoreKey); return(Convert.ToInt32(newId)); }
public void Delete(string value) { var dataQuery = new CityDataModel(); dataQuery.CityId = int.Parse(value); CityDataManager.Delete(dataQuery, SessionVariables.RequestProfile); }
public static string Save(CityDataModel data, string action, RequestProfile requestProfile) { var sql = "EXEC "; switch (action) { case "Create": sql += "dbo.CityInsert " + " " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId) + ", " + ToSQLParameter(BaseDataModel.BaseDataColumns.ApplicationId, requestProfile.ApplicationId); break; case "Update": sql += "dbo.CityUpdate " + " " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId); break; default: break; } sql = sql + ", " + ToSQLParameter(data, CityDataModel.DataColumns.CityId); sql = sql + ", " + ToSQLParameter(data, CityDataModel.DataColumns.CountryId); sql = sql + ", " + ToSQLParameter(data, CityDataModel.DataColumns.Name); sql = sql + ", " + ToSQLParameter(data, CityDataModel.DataColumns.Description); sql = sql + ", " + ToSQLParameter(data, CityDataModel.DataColumns.SortOrder); return(sql); }
public CityDataModel GetById(string value) { var dataQuery = new CityDataModel(); dataQuery.CityId = int.Parse(value); var result = CityDataManager.GetEntityDetails(dataQuery, SessionVariables.RequestProfile, 1); return(result[0]); }
public static bool DoesExist(CityDataModel data, RequestProfile requestProfile) { var doesExistRequest = new CityDataModel(); doesExistRequest.ApplicationId = data.ApplicationId; doesExistRequest.CountryId = data.CountryId; doesExistRequest.Name = data.Name; var list = GetEntityDetails(doesExistRequest, requestProfile, 0); return(list.Count > 0); }
private static void Logger_OnMessageLogged(CityDataModel.LogMessage Msg) { switch (Msg.Level) { case CityDataModel.LogLevel.info: Logger.LogInfo(Msg.Message); break; case CityDataModel.LogLevel.error: Logger.LogDebug(Msg.Message); break; case CityDataModel.LogLevel.warn: Logger.LogWarning(Msg.Message); break; } }
public static void Delete(CityDataModel data, RequestProfile requestProfile) { const string sql = @"dbo.CityDelete "; var parameters = new { AuditId = requestProfile.AuditId , CityId = data.CityId }; using (var dataAccess = new DataAccessBase(DataStoreKey)) { dataAccess.Connection.Execute(sql, parameters, commandType: CommandType.StoredProcedure); } }
public CityDataModel GetCityInformation(string cityName) { var citiesResponse = Webber.Get <Location[]>( "http://dataservice.accuweather.com/locations/v1/cities/search" + $"?apikey={_apiKey}" + $"&q={cityName}" + "&details=true" ); var city = citiesResponse .Result .OrderBy(x => x.Rank) .FirstOrDefault(); return(city != null ? CityDataModel.BuildSuccess(city) : CityDataModel.BuildFailed()); }
private void OnAddButtonClicked() { if (null == _autosuggestBox.Text || string.IsNullOrEmpty(_autosuggestBox.Text)) { App.Current.MainPage.DisplayAlert(AppConstants.Strings.ERROR_TITLE, AppConstants.Strings.ERROR_NULL_CITY, AppConstants.Strings.DIALOG_CLOSE); return; } CityDataModel cityModel = null; string cityName = ""; if (_autosuggestBox.Text.Contains(",")) { var tmp = _autosuggestBox.Text.Split(','); cityName = tmp[0]; } else { cityName = _autosuggestBox.Text; } foreach (var ct in _lastSuggestion) { if (ct.City.Equals(cityName)) { cityModel = ct; break; } } if (null != cityModel) { CityWeatherData dt = new CityWeatherData() { CityId = cityModel.CityId, CityName = cityModel.City, CountryName = cityModel.Country }; App.Current.MainPage.DisplayAlert(AppConstants.Strings.DIALOG_INFO, AppConstants.Strings.DIALOG_CITY_ADDED, AppConstants.Strings.DIALOG_OK); App.Database.AddUserWeatherData(dt); _navigation.PopModalAsync(); } else { App.Current.MainPage.DisplayAlert(AppConstants.Strings.ERROR_TITLE, AppConstants.Strings.ERROR_INCORRECT_CITY, AppConstants.Strings.DIALOG_CLOSE); return; } }
public static List <CityDataModel> GetEntityDetails(CityDataModel dataQuery, RequestProfile requestProfile, int returnAuditInfo = BaseDataManager.ReturnAuditInfoOnDetails) { const string sql = @"dbo.CitySearch "; var parameters = new { AuditId = requestProfile.AuditId , ApplicationId = requestProfile.ApplicationId , ReturnAuditInfo = returnAuditInfo , CityId = dataQuery.CityId , CountryId = dataQuery.CountryId , Name = dataQuery.Name }; List <CityDataModel> result; using (var dataAccess = new DataAccessBase(DataStoreKey)) { result = dataAccess.Connection.Query <CityDataModel>(sql, parameters, commandType: CommandType.StoredProcedure).ToList(); } return(result); }
public async Task AddCity(CityDataModel city) { await _demoDbContext.CityMaster.AddAsync(city); await _demoDbContext.SaveChangesAsync(); }
public static string ToSQLParameter(CityDataModel data, string dataColumnName) { var returnValue = "NULL"; switch (dataColumnName) { case CityDataModel.DataColumns.CityId: if (data.CityId != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, CityDataModel.DataColumns.CityId, data.CityId); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, CityDataModel.DataColumns.CityId); } break; case CityDataModel.DataColumns.CountryId: if (data.CountryId != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, CityDataModel.DataColumns.CountryId, data.CountryId); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, CityDataModel.DataColumns.CountryId); } break; case CityDataModel.DataColumns.Country: if (!string.IsNullOrEmpty(data.Country)) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, CityDataModel.DataColumns.Country, data.Country); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, CityDataModel.DataColumns.Country); } break; case CityDataModel.DataColumns.Name: if (!string.IsNullOrEmpty(data.Name)) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, CityDataModel.DataColumns.Name, data.Name); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, CityDataModel.DataColumns.Name); } break; case CityDataModel.DataColumns.Description: if (!string.IsNullOrEmpty(data.Description)) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, CityDataModel.DataColumns.Description, data.Description); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, CityDataModel.DataColumns.Description); } break; case CityDataModel.DataColumns.SortOrder: if (data.SortOrder != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, CityDataModel.DataColumns.SortOrder, data.SortOrder); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, CityDataModel.DataColumns.SortOrder); } break; default: returnValue = BaseDataManager.ToSQLParameter(data, dataColumnName); break; } return(returnValue); }
public static void Update(CityDataModel data, RequestProfile requestProfile) { var sql = Save(data, "Update", requestProfile); DBDML.RunSQL("City.Update", sql, DataStoreKey); }
public static DataTable Search(CityDataModel data, RequestProfile requestProfile) { var list = GetEntityDetails(data, requestProfile, 0); return(list.ToDataTable()); }
public static CityModel ToCoreModel(this CityDataModel city, IMapper mapper) { return(mapper.Map <CityDataModel, CityModel>(city)); }
public void Update([FromBody] CityDataModel data) { CityDataManager.Update(data, SessionVariables.RequestProfile); }