public RegionResponse Create(RegionViewModel region)
{
RegionResponse response = new RegionResponse();
using (SqliteConnection db = new SqliteConnection(SQLiteHelper.SqLiteTableName))
{
db.Open();
SqliteCommand insertCommand = db.CreateCommand();
insertCommand.CommandText = SqlCommandInsertPart;
try
{
insertCommand = AddCreateParameters(insertCommand, region);
insertCommand.ExecuteNonQuery();
}
catch (SqliteException error)
{
MainWindow.ErrorMessage = error.Message;
response.Success = false;
response.Message = error.Message;
return(response);
}
db.Close();
response.Success = true;
return(response);
}
}
public RegionResponse Delete(Guid identifier)
{
RegionResponse response = new RegionResponse();
using (SqliteConnection db = new SqliteConnection(SQLiteHelper.SqLiteTableName))
{
db.Open();
SqliteCommand insertCommand = new SqliteCommand();
insertCommand.Connection = db;
//Use parameterized query to prevent SQL injection attacks
insertCommand.CommandText = "DELETE FROM Regions WHERE Identifier = @Identifier";
insertCommand.Parameters.AddWithValue("@Identifier", identifier);
try
{
insertCommand.ExecuteNonQuery();
}
catch (SqliteException error)
{
MainWindow.ErrorMessage = error.Message;
response.Success = false;
response.Message = error.Message;
return(response);
}
db.Close();
response.Success = true;
return(response);
}
}
private void cbRegionWineList_SelectedIndexChanged(object sender, System.EventArgs e)
{
RegionResponse selectedRegion = (RegionResponse)cbRegionWineList.SelectedItem;
SelectedRegionId = selectedRegion.RegionId;
ShowUsersWinelist();
}
public RegionResponse GetWeatherByRegion(string region)
{
RegionResponse response;
var result = _httpClient.GetAsync($"{_host}/forecast/region/{region}?{_token}").GetAwaiter().GetResult();
if (result == null)
{
return(null);
}
if (!result.IsSuccessStatusCode)
{
if (result.StatusCode == HttpStatusCode.BadRequest)
{
response = result.Content.ReadAsAsync <RegionResponse>().Result;
response.StatusCode = result.StatusCode;
response.Data = null;
return(response);
}
response = new RegionResponse {
StatusCode = result.StatusCode
};
return(response);
}
response = result.Content.ReadAsAsync <RegionResponse>().Result;
response.StatusCode = result.StatusCode;
return(response);
}
private void cbRegionAllWineList_SelectedIndexChanged(object sender, System.EventArgs e)
{
RegionResponse selectedRegion = (RegionResponse)cbRegionAllWineList.SelectedItem;
if (selectedRegion != null)
{
SelectedRegionIdAllwinelist = selectedRegion.RegionId;
}
ShowAllWinelist();
}
public void GetWeatherByRegionTests_When_IsNotSuccess_Returns_StatusCode(HttpStatusCode statusCode)
{
var region = "sul";
var httpResponseMessage = new HttpResponseMessage(statusCode);
_client.GetAsync($"{_host}/forecast/region/{region }?{_token}")
.Returns(httpResponseMessage);
var response = new RegionResponse {
StatusCode = statusCode
};
var result = _service.GetWeatherByRegion(region);
result.Should().BeEquivalentTo(response);
}
public void GetWeatherByRegion_When_CustomerService_Returns_Null_Returns_BadRequest()
{
var region = "regiaoinvalida";
RegionResponse response = null;
var controller = new WeatherController(_service);
var errorResponse = new ErrorResponse()
{
Message = "Região Inválida"
};
_service.GetWeatherByRegion(region).Returns(response);
var result = controller.GetWeatherByRegion(region);
result.Should().BeEquivalentTo(new StatusCodeResult(StatusCodes.Status400BadRequest));
}
public RegionResponse Create(RegionViewModel re)
{
RegionResponse response = new RegionResponse();
try
{
response = WpfApiHandler.SendToApi <RegionViewModel, RegionResponse>(re, "Create");
}
catch (Exception ex)
{
response.Region = new RegionViewModel();
response.Success = false;
response.Message = ex.Message;
}
return(response);
}
private void ShowRegionsAllWinelist()
{
CountryResponse selectedCountry = Metadata.Countries.FirstOrDefault(r => r.CountryId == SelectedCountryIdAllwinelist);
cbRegionAllWineList.Items.Clear();
RegionResponse firstObject = new RegionResponse {
RegionId = -1, CountryId = -1, RegionName = "alla regioner"
};
cbRegionAllWineList.Items.Add(firstObject);
if (selectedCountry != null)
{
cbRegionAllWineList.Items.AddRange(selectedCountry.Regions.ToArray());
}
cbRegionAllWineList.SelectedIndex = 0;
}
public void GetWeatherByRegion_When_Has_OK_Returns_Success()
{
var controller = new WeatherController(_service);
var response = new RegionResponse();
var request = new Region();
var region = "sudeste";
request.Date = new DateTime(2019, 10, 13);
request.Text = "Hoje o dia está nublado";
response.Data.Add(request);
_service.GetWeatherByRegion(region).Returns(response);
var result = controller.GetWeatherByRegion(region);
result.Should().BeEquivalentTo(new OkObjectResult(response));
}
public RegionResponse Delete(Guid identifier)
{
RegionResponse response = new RegionResponse();
try
{
RegionViewModel re = new RegionViewModel();
re.Identifier = identifier;
response = WpfApiHandler.SendToApi <RegionViewModel, RegionResponse>(re, "Delete");
}
catch (Exception ex)
{
response.Region = new RegionViewModel();
response.Success = false;
response.Message = ex.Message;
}
return(response);
}
private void reader_ResponseReceived(Reader sender, ResponseReceivedEventArgs e)
{
string MethodeName = MethodBase.GetCurrentMethod().ToString();
if (e.Message is VersionResponse)
{
VersionResponse r = (VersionResponse)e.Message;
Console.WriteLine("Hardware version = " + r.HardwareVersion);
Console.WriteLine("Firmware version = " + r.FirmwareVersion);
}
else if (e.Message is RegionResponse)
{
RegionResponse r = (RegionResponse)e.Message;
Console.WriteLine("Region " + r.Region.ToString() + " set. Regions supported by this reader:");
foreach (Region region in r.SupportedRegions)
{
Console.WriteLine("- " + region.ToString());
}
}
}
public RegionResponse Create(RegionViewModel re)
{
RegionResponse response = new RegionResponse();
try
{
Region addedRegion = unitOfWork.GetRegionRepository().Create(re.ConvertToRegion());
unitOfWork.Save();
response.Region = addedRegion.ConvertToRegionViewModel();
response.Success = true;
}
catch (Exception ex)
{
response.Region = new RegionViewModel();
response.Success = false;
response.Message = ex.Message;
}
return(response);
}
public JsonResult Delete([FromBody] RegionViewModel region)
{
RegionResponse response = new RegionResponse();
try
{
response = this.regionService.Delete(region.Identifier);
}
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 RegionResponse DeleteAll()
{
RegionResponse response = new RegionResponse();
try
{
using (SqliteConnection db = new SqliteConnection("Filename=SirmiumERPGFC.db"))
{
db.Open();
db.EnableExtensions(true);
SqliteCommand insertCommand = new SqliteCommand();
insertCommand.Connection = db;
//Use parameterized query to prevent SQL injection attacks
insertCommand.CommandText = "DELETE FROM Regions";
try
{
insertCommand.ExecuteNonQuery();
}
catch (SqliteException error)
{
response.Success = false;
response.Message = error.Message;
MainWindow.ErrorMessage = error.Message;
return(response);
}
db.Close();
}
}
catch (SqliteException error)
{
response.Success = false;
response.Message = error.Message;
return(response);
}
response.Success = true;
return(response);
}
public RegionResponse Delete(Guid identifier)
{
RegionResponse response = new RegionResponse();
try
{
Region deletedRegion = unitOfWork.GetRegionRepository().Delete(identifier);
unitOfWork.Save();
response.Region = deletedRegion.ConvertToRegionViewModel();
response.Success = true;
}
catch (Exception ex)
{
response.Region = new RegionViewModel();
response.Success = false;
response.Message = ex.Message;
}
return(response);
}
public RegionResponse GetRegion(Guid identifier)
{
RegionResponse response = new RegionResponse();
RegionViewModel Region = new RegionViewModel();
using (SqliteConnection db = new SqliteConnection("Filename=SirmiumERPGFC.db"))
{
db.Open();
try
{
SqliteCommand selectCommand = new SqliteCommand(
SqlCommandSelectPart +
"FROM Regions " +
"WHERE Identifier = @Identifier;", db);
selectCommand.Parameters.AddWithValue("@Identifier", identifier);
SqliteDataReader query = selectCommand.ExecuteReader();
if (query.Read())
{
RegionViewModel dbEntry = Read(query);
Region = dbEntry;
}
}
catch (SqliteException error)
{
MainWindow.ErrorMessage = error.Message;
response.Success = false;
response.Message = error.Message;
response.Region = new RegionViewModel();
return(response);
}
db.Close();
}
response.Success = true;
response.Region = Region;
return(response);
}
private void ShowDistrictAddNewWine(long selectedCountryId, long selectedRegionId)
{
cbOriginDistrict.Items.Clear();
CountryResponse selectedCountry = Metadata.Countries.FirstOrDefault(r => r.CountryId == selectedCountryId);
if (selectedCountry == null)
{
return;
}
RegionResponse selectedRegion = selectedCountry.Regions.First(r => r.RegionId == selectedRegionId);
if (selectedRegion == null)
{
return;
}
if (selectedRegion != null && selectedRegion.Districts.Count() > 0)
{
cbOriginDistrict.Items.AddRange(selectedRegion.Districts.ToArray());
cbOriginDistrict.SelectedIndex = 0;
}
}
public static async Task <RegionResponse> UpdateRegion(Region dr, HttpRequestMethods method)
{
// Initialization.
// RegInfoResponseObj responseObj = new RegInfoResponseObj();
RegionResponse resp = null;
var result = "";
//HttpRequestMethods method = HttpRequestMethods.Put;
try
{
var jsonString = JsonConvert.SerializeObject(dr);
result = await edr.ExecuteRequest("api/Region/", method, jsonString);
var sresp = JsonConvert.DeserializeObject <ObservableCollection <Region> >(result);
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
//resp = ex.Message.ToString();
}
return(resp);
}
private void btnSave_Click(object sender, RoutedEventArgs e)
{
#region Validation
if (String.IsNullOrEmpty(CurrentRegion.Name))
{
MainWindow.WarningMessage = ((string)Application.Current.FindResource("Obavezno_poljeDvotačka_Naziv_regiona"));
return;
}
#endregion
Thread th = new Thread(() =>
{
SaveButtonContent = ((string)Application.Current.FindResource("Čuvanje_u_tokuTriTacke"));
SaveButtonEnabled = false;
CurrentRegion.IsSynced = false;
CurrentRegion.Company = new CompanyViewModel()
{
Id = MainWindow.CurrentCompanyId
};
CurrentRegion.CreatedBy = new UserViewModel()
{
Id = MainWindow.CurrentUserId
};
RegionResponse response = regionService.Create(CurrentRegion);
if (!response.Success)
{
MainWindow.ErrorMessage = ((string)Application.Current.FindResource("Greška_kod_čuvanja_na_serveruUzvičnik"));
SaveButtonContent = ((string)Application.Current.FindResource("Sačuvaj"));
SaveButtonEnabled = true;
}
if (response.Success)
{
MainWindow.SuccessMessage = ((string)Application.Current.FindResource("Podaci_su_uspešno_sačuvaniUzvičnik"));
SaveButtonContent = ((string)Application.Current.FindResource("Sačuvaj"));
SaveButtonEnabled = true;
RegionCreatedUpdated();
if (IsCreateProcess)
{
CurrentRegion = new RegionViewModel();
CurrentRegion.Identifier = Guid.NewGuid();
Application.Current.Dispatcher.BeginInvoke(
System.Windows.Threading.DispatcherPriority.Normal,
new Action(() =>
{
txtRegionCode.Focus();
})
);
}
else
{
Application.Current.Dispatcher.BeginInvoke(
System.Windows.Threading.DispatcherPriority.Normal,
new Action(() =>
{
if (IsPopup)
{
FlyoutHelper.CloseFlyoutPopup(this);
}
else
{
FlyoutHelper.CloseFlyout(this);
}
})
);
}
}
});
th.IsBackground = true;
th.Start();
txtName.Focus();
}
private void cbOriginRegion_SelectedIndexChanged(object sender, System.EventArgs e)
{
RegionResponse selectedRegion = (RegionResponse)cbOriginRegion.SelectedItem;
ShowDistrictAddNewWine(selectedRegion.CountryId, selectedRegion.RegionId);
}
