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);
}
