public RegionListResponse GetRegionsNewerThen(int companyId, DateTime?lastUpdateTime)
{
RegionListResponse response = new RegionListResponse();
try
{
if (lastUpdateTime != null)
{
response.Regions = unitOfWork.GetRegionRepository()
.GetRegionsNewerThen(companyId, (DateTime)lastUpdateTime)
.ConvertToRegionViewModelList();
}
else
{
response.Regions = unitOfWork.GetRegionRepository()
.GetRegions(companyId)
.ConvertToRegionViewModelList();
}
response.Success = true;
}
catch (Exception ex)
{
response.Regions = new List <RegionViewModel>();
response.Success = false;
response.Message = ex.Message;
}
return(response);
}
public RegionListResponse Sync(SyncRegionRequest request)
{
RegionListResponse response = new RegionListResponse();
try
{
response.Regions = new List <RegionViewModel>();
if (request.LastUpdatedAt != null)
{
response.Regions.AddRange(unitOfWork.GetRegionRepository()
.GetRegionsNewerThen(request.CompanyId, (DateTime)request.LastUpdatedAt)
?.ConvertToRegionViewModelList() ?? new List <RegionViewModel>());
}
else
{
response.Regions.AddRange(unitOfWork.GetRegionRepository()
.GetRegions(request.CompanyId)
?.ConvertToRegionViewModelList() ?? new List <RegionViewModel>());
}
response.Success = true;
}
catch (Exception ex)
{
response.Regions = new List <RegionViewModel>();
response.Success = false;
response.Message = ex.Message;
}
return(response);
}
public RegionListResponse GetRegionsForPopup(int companyId, Guid countryIdentifier, string filterString)
{
RegionListResponse response = new RegionListResponse();
List <RegionViewModel> Regions = new List <RegionViewModel>();
using (SqliteConnection db = new SqliteConnection("Filename=SirmiumERPGFC.db"))
{
db.Open();
try
{
SqliteCommand selectCommand = new SqliteCommand(
SqlCommandSelectPart +
"FROM Regions " +
"WHERE (@Name IS NULL OR @Name = '' OR Name LIKE @Name) " +
"OR (@RegionCode IS NULL OR @RegionCode = '' OR RegionCode LIKE @RegionCode) " +
"OR (@CountryName IS NULL OR @CountryName = '' OR CountryName LIKE @CountryName) " +
"AND CountryIdentifier = @CountryIdentifier " +
"AND CompanyId = @CompanyId " +
"ORDER BY IsSynced, Id DESC " +
"LIMIT @ItemsPerPage;", db);
selectCommand.Parameters.AddWithValue("@Name", ((object)filterString) != null ? "%" + filterString + "%" : "");
selectCommand.Parameters.AddWithValue("@RegionCode", ((object)filterString) != null ? "%" + filterString + "%" : "");
selectCommand.Parameters.AddWithValue("@CountryName", ((object)filterString) != null ? "%" + filterString + "%" : "");
selectCommand.Parameters.AddWithValue("@CountryIdentifier", countryIdentifier);
selectCommand.Parameters.AddWithValue("@CompanyId", ((object)filterString) != null ? companyId : 0);
selectCommand.Parameters.AddWithValue("@ItemsPerPage", 100);
SqliteDataReader query = selectCommand.ExecuteReader();
while (query.Read())
{
RegionViewModel dbEntry = Read(query);
Regions.Add(dbEntry);
}
}
catch (SqliteException error)
{
MainWindow.ErrorMessage = error.Message;
response.Success = false;
response.Message = error.Message;
response.Regions = new List <RegionViewModel>();
return(response);
}
db.Close();
}
response.Success = true;
response.Regions = Regions;
return(response);
}
public static RegionListResponse CreateDummyRegionListResponse(string i)
{
var data = new RegionListResponse
{
ExecutionResult = new ExecutionResult(),
LastRegionCode = "QEW",
LastRegionType = "DERP",
MoreFlag = "N",
OutOutletRegions = new OutOutletRegion[1]
};
data.OutOutletRegions[0] = new OutOutletRegion {
AdditionalInformation = "qwer", AssessorAvailFl = "wwe"
};
return(data);
}
public RegionListResponse Sync(SyncRegionRequest request)
{
RegionListResponse response = new RegionListResponse();
try
{
response = WpfApiHandler.SendToApi <SyncRegionRequest, RegionViewModel, RegionListResponse>(request, "Sync");
}
catch (Exception ex)
{
response.Regions = new List <RegionViewModel>();
response.Success = false;
response.Message = ex.Message;
}
return(response);
}
public JsonResult GetRegions(int companyId)
{
RegionListResponse response = new RegionListResponse();
try
{
response = regionService.GetRegions(companyId);
}
catch (Exception ex)
{
response.Success = false;
response.Message = ex.Message;
Console.WriteLine(ex.Message);
}
return(Json(response, new Newtonsoft.Json.JsonSerializerSettings()
{
Formatting = Newtonsoft.Json.Formatting.Indented
}));
}
public JsonResult Sync([FromBody] SyncRegionRequest request)
{
RegionListResponse response = new RegionListResponse();
try
{
response = this.regionService.Sync(request);
}
catch (Exception ex)
{
response.Success = false;
response.Message = ex.Message;
}
return(Json(response, new Newtonsoft.Json.JsonSerializerSettings()
{
Formatting = Newtonsoft.Json.Formatting.Indented
}));
}
public RegionListResponse GetRegions(int companyId)
{
RegionListResponse response = new RegionListResponse();
try
{
response.Regions = unitOfWork.GetRegionRepository().GetRegions(companyId)
.ConvertToRegionViewModelList();
response.Success = true;
}
catch (Exception ex)
{
response.Regions = new List <RegionViewModel>();
response.Success = false;
response.Message = ex.Message;
}
return(response);
}
public RegionListResponse GetRegions(int companyId)
{
RegionListResponse response = new RegionListResponse();
try
{
response = WpfApiHandler.GetFromApi <List <RegionViewModel>, RegionListResponse>("GetRegions", new Dictionary <string, string>()
{
{ "CompanyId", companyId.ToString() }
});
}
catch (Exception ex)
{
response.Regions = new List <RegionViewModel>();
response.Success = false;
response.Message = ex.Message;
}
return(response);
}
public RegionListResponse RegionList([FromBody] RegionListRequest req)
{
var rep = new RegionListResponse();
var list = RegionList();
if (req.Hierarchical)
{
rep.China = list.ToChina();
}
else
{
if (string.IsNullOrEmpty(req.ParentId))
{
rep.Data = list;
}
else
{
rep.Data = list.Where(x => x.ParentId == req.ParentId).ToList();
}
}
return(rep);
}
public RegionListResponse GetRegionsByPage(int companyId, RegionViewModel regionSearchObject, int currentPage = 1, int itemsPerPage = 50)
{
RegionListResponse response = new RegionListResponse();
List <RegionViewModel> Regions = new List <RegionViewModel>();
using (SqliteConnection db = new SqliteConnection("Filename=SirmiumERPGFC.db"))
{
db.Open();
try
{
SqliteCommand selectCommand = new SqliteCommand(
SqlCommandSelectPart +
"FROM Regions " +
"WHERE (@RegionCode IS NULL OR @RegionCode = '' OR RegionCode LIKE @RegionCode) " +
"AND (@Name IS NULL OR @Name = '' OR Name LIKE @Name) " +
"AND (@CountryName IS NULL OR @CountryName = '' OR CountryName LIKE @CountryName) " +
"AND CompanyId = @CompanyId " +
"ORDER BY IsSynced, Id DESC " +
"LIMIT @ItemsPerPage OFFSET @Offset;", db);
selectCommand.Parameters.AddWithValue("@RegionCode", ((object)regionSearchObject.Search_RegionCode) != null ? "%" + regionSearchObject.Search_RegionCode + "%" : "");
selectCommand.Parameters.AddWithValue("@Name", ((object)regionSearchObject.Search_Name) != null ? "%" + regionSearchObject.Search_Name + "%" : "");
selectCommand.Parameters.AddWithValue("@CountryName", ((object)regionSearchObject.Search_Country) != null ? "%" + regionSearchObject.Search_Country + "%" : "");
selectCommand.Parameters.AddWithValue("@CompanyId", companyId);
selectCommand.Parameters.AddWithValue("@ItemsPerPage", itemsPerPage);
selectCommand.Parameters.AddWithValue("@Offset", (currentPage - 1) * itemsPerPage);
SqliteDataReader query = selectCommand.ExecuteReader();
while (query.Read())
{
RegionViewModel dbEntry = Read(query);
Regions.Add(dbEntry);
}
selectCommand = new SqliteCommand(
"SELECT Count(*) " +
"FROM Regions " +
"WHERE (@RegionCode IS NULL OR @RegionCode = '' OR RegionCode LIKE @RegionCode) " +
"AND (@Name IS NULL OR @Name = '' OR Name LIKE @Name) " +
"AND (@CountryName IS NULL OR @CountryName = '' OR CountryName LIKE @CountryName) " +
"AND CompanyId = @CompanyId;", db);
selectCommand.Parameters.AddWithValue("@RegionCode", ((object)regionSearchObject.Search_RegionCode) != null ? "%" + regionSearchObject.Search_RegionCode + "%" : "");
selectCommand.Parameters.AddWithValue("@Name", ((object)regionSearchObject.Search_Name) != null ? "%" + regionSearchObject.Search_Name + "%" : "");
selectCommand.Parameters.AddWithValue("@CountryName", ((object)regionSearchObject.Search_Country) != null ? "%" + regionSearchObject.Search_Country + "%" : "");
selectCommand.Parameters.AddWithValue("@CompanyId", companyId);
query = selectCommand.ExecuteReader();
if (query.Read())
{
response.TotalItems = query.GetInt32(0);
}
}
catch (SqliteException error)
{
MainWindow.ErrorMessage = error.Message;
response.Success = false;
response.Message = error.Message;
response.Regions = new List <RegionViewModel>();
return(response);
}
db.Close();
}
response.Success = true;
response.Regions = Regions;
return(response);
}
public void Sync(IRegionService regionService, Action <int, int> callback = null)
{
try
{
SyncRegionRequest request = new SyncRegionRequest();
request.CompanyId = MainWindow.CurrentCompanyId;
request.LastUpdatedAt = GetLastUpdatedAt(MainWindow.CurrentCompanyId);
int toSync = 0;
int syncedItems = 0;
RegionListResponse response = regionService.Sync(request);
if (response.Success)
{
toSync = response?.Regions?.Count ?? 0;
List <RegionViewModel> regionsFromDB = response.Regions;
using (SqliteConnection db = new SqliteConnection(SQLiteHelper.SqLiteTableName))
{
db.Open();
using (var transaction = db.BeginTransaction())
{
SqliteCommand deleteCommand = db.CreateCommand();
deleteCommand.CommandText = "DELETE FROM Regions WHERE Identifier = @Identifier";
SqliteCommand insertCommand = db.CreateCommand();
insertCommand.CommandText = SqlCommandInsertPart;
foreach (var region in regionsFromDB)
{
deleteCommand.Parameters.AddWithValue("@Identifier", region.Identifier);
deleteCommand.ExecuteNonQuery();
deleteCommand.Parameters.Clear();
if (region.IsActive)
{
region.IsSynced = true;
insertCommand = AddCreateParameters(insertCommand, region);
insertCommand.ExecuteNonQuery();
insertCommand.Parameters.Clear();
syncedItems++;
callback?.Invoke(syncedItems, toSync);
}
}
transaction.Commit();
}
db.Close();
}
}
else
{
throw new Exception(response.Message);
}
}
catch (Exception ex)
{
MainWindow.ErrorMessage = ex.Message;
}
}
/// <summary>
/// List all regions.
/// </summary>
/// <param name='resourceGroupName'>
/// Required. The name of the resource group.
/// </param>
/// <param name='serviceName'>
/// Required. The name of the Api Management service.
/// </param>
/// <param name='cancellationToken'>
/// Cancellation token.
/// </param>
/// <returns>
/// List Regions operation response details.
/// </returns>
public async Task <RegionListResponse> ListAsync(string resourceGroupName, string serviceName, CancellationToken cancellationToken)
{
// Validate
if (resourceGroupName == null)
{
throw new ArgumentNullException("resourceGroupName");
}
if (serviceName == null)
{
throw new ArgumentNullException("serviceName");
}
// Tracing
bool shouldTrace = TracingAdapter.IsEnabled;
string invocationId = null;
if (shouldTrace)
{
invocationId = TracingAdapter.NextInvocationId.ToString();
Dictionary <string, object> tracingParameters = new Dictionary <string, object>();
tracingParameters.Add("resourceGroupName", resourceGroupName);
tracingParameters.Add("serviceName", serviceName);
TracingAdapter.Enter(invocationId, this, "ListAsync", tracingParameters);
}
// Construct URL
string url = "";
url = url + "/subscriptions/";
if (this.Client.Credentials.SubscriptionId != null)
{
url = url + Uri.EscapeDataString(this.Client.Credentials.SubscriptionId);
}
url = url + "/resourceGroups/";
url = url + Uri.EscapeDataString(resourceGroupName);
url = url + "/providers/";
url = url + "Microsoft.ApiManagement";
url = url + "/service/";
url = url + Uri.EscapeDataString(serviceName);
url = url + "/regions";
List <string> queryParameters = new List <string>();
queryParameters.Add("api-version=2014-02-14");
if (queryParameters.Count > 0)
{
url = url + "?" + string.Join("&", queryParameters);
}
string baseUrl = this.Client.BaseUri.AbsoluteUri;
// Trim '/' character from the end of baseUrl and beginning of url.
if (baseUrl[baseUrl.Length - 1] == '/')
{
baseUrl = baseUrl.Substring(0, baseUrl.Length - 1);
}
if (url[0] == '/')
{
url = url.Substring(1);
}
url = baseUrl + "/" + url;
url = url.Replace(" ", "%20");
// Create HTTP transport objects
HttpRequestMessage httpRequest = null;
try
{
httpRequest = new HttpRequestMessage();
httpRequest.Method = HttpMethod.Get;
httpRequest.RequestUri = new Uri(url);
// Set Headers
// Set Credentials
cancellationToken.ThrowIfCancellationRequested();
await this.Client.Credentials.ProcessHttpRequestAsync(httpRequest, cancellationToken).ConfigureAwait(false);
// Send Request
HttpResponseMessage httpResponse = null;
try
{
if (shouldTrace)
{
TracingAdapter.SendRequest(invocationId, httpRequest);
}
cancellationToken.ThrowIfCancellationRequested();
httpResponse = await this.Client.HttpClient.SendAsync(httpRequest, cancellationToken).ConfigureAwait(false);
if (shouldTrace)
{
TracingAdapter.ReceiveResponse(invocationId, httpResponse);
}
HttpStatusCode statusCode = httpResponse.StatusCode;
if (statusCode != HttpStatusCode.OK)
{
cancellationToken.ThrowIfCancellationRequested();
CloudException ex = CloudException.Create(httpRequest, null, httpResponse, await httpResponse.Content.ReadAsStringAsync().ConfigureAwait(false));
if (shouldTrace)
{
TracingAdapter.Error(invocationId, ex);
}
throw ex;
}
// Create Result
RegionListResponse result = null;
// Deserialize Response
if (statusCode == HttpStatusCode.OK)
{
cancellationToken.ThrowIfCancellationRequested();
string responseContent = await httpResponse.Content.ReadAsStringAsync().ConfigureAwait(false);
result = new RegionListResponse();
JToken responseDoc = null;
if (string.IsNullOrEmpty(responseContent) == false)
{
responseDoc = JToken.Parse(responseContent);
}
if (responseDoc != null && responseDoc.Type != JTokenType.Null)
{
JToken valueArray = responseDoc["value"];
if (valueArray != null && valueArray.Type != JTokenType.Null)
{
foreach (JToken valueValue in ((JArray)valueArray))
{
RegionContract regionContractInstance = new RegionContract();
result.Values.Add(regionContractInstance);
JToken nameValue = valueValue["name"];
if (nameValue != null && nameValue.Type != JTokenType.Null)
{
string nameInstance = ((string)nameValue);
regionContractInstance.Name = nameInstance;
}
JToken isMasterRegionValue = valueValue["isMasterRegion"];
if (isMasterRegionValue != null && isMasterRegionValue.Type != JTokenType.Null)
{
bool isMasterRegionInstance = ((bool)isMasterRegionValue);
regionContractInstance.IsMasterRegion = isMasterRegionInstance;
}
}
}
}
}
result.StatusCode = statusCode;
if (httpResponse.Headers.Contains("x-ms-request-id"))
{
result.RequestId = httpResponse.Headers.GetValues("x-ms-request-id").FirstOrDefault();
}
if (shouldTrace)
{
TracingAdapter.Exit(invocationId, result);
}
return(result);
}
finally
{
if (httpResponse != null)
{
httpResponse.Dispose();
}
}
}
finally
{
if (httpRequest != null)
{
httpRequest.Dispose();
}
}
}
