public IActionResult GetUnitTracker(Int32 paramIdUnitTracker)
{
DtoUnitTracker UnitTracker = new DtoUnitTracker();
UnitTracker = _unitTrackerService.GetUnitTracker(paramIdUnitTracker);
return(Json(UnitTracker));
}
public ServiceResult <Boolean> Insert(DtoUnitTracker paramUnitTracker)
{
ServiceResult <Boolean> unitTracker = new ServiceResult <Boolean>();
unitTracker = _unitTrackerRepository.Insert(paramUnitTracker);
return(unitTracker);
}
public DtoUnitTracker GetUnitTracker(Int32 paramUnitTracker)
{
DtoUnitTracker unitTracker = new DtoUnitTracker();
unitTracker = _unitTrackerRepository.GetUnitTracker(paramUnitTracker);
return(unitTracker);
}
public IActionResult Insert([FromBody] DtoUnitTracker paramUnitTracker)
{
ServiceResult <Boolean> result = new ServiceResult <Boolean>();
result = _unitTrackerService.Insert(paramUnitTracker);
if (!result.Data)
{
return(BadRequest("Este login não pode ser utilizado, pois já existe no sistema."));
}
return(Ok(result.Data));
}
public ItemDetailPage()
{
InitializeComponent();
var item = new DtoUnitTracker
{
Name = "Item 1",
Login = "******"
};
viewModel = new ItemDetailViewModel(item);
BindingContext = viewModel;
}
public ServiceResult <Boolean> Insert(DtoUnitTracker paramUnitTracker)
{
try
{
ServiceResult <Boolean> result = new ServiceResult <Boolean>();
using (SqlConnection con = new SqlConnection(GetConnectionString()))
{
SqlCommand cmd = new SqlCommand("[dbo].[pr_insertUnitTracker]", con)
{
CommandType = CommandType.StoredProcedure
};
SqlDataReader sqlDataReader = null;
cmd.Parameters.AddWithValue("@prmIdUser", paramUnitTracker.IdUser);
cmd.Parameters.AddWithValue("@prmName", paramUnitTracker.Name);
cmd.Parameters.AddWithValue("@prmLogin", paramUnitTracker.Login);
cmd.Parameters.AddWithValue("@prmCalculoDistancia", paramUnitTracker.CalculoDistancia);
cmd.Parameters.AddWithValue("@prmIntervaloPosicao", paramUnitTracker.IntervaloPosicao);
cmd.Parameters.AddWithValue("@prmIntervaloPosicaoParado", paramUnitTracker.IntervaloPosicaoParado);
cmd.Parameters.AddWithValue("@prmAvatar", paramUnitTracker.Avatar);
cmd.Parameters.AddWithValue("@prmIdAdmin", paramUnitTracker.IdAdmin);
con.Open();
sqlDataReader = cmd.ExecuteReader();
if (sqlDataReader.Read())
{
if (!sqlDataReader.IsDBNull(0))
{
result.Data = sqlDataReader.GetBoolean(0);
}
}
return(result);
}
}
catch (Exception Ex)
{
throw new Exception(Ex.Message);
}
}
async void Save_Clicked(object sender, EventArgs e)
{
//MessagingCenter.Send(this, "AddItem", Item);
if (String.IsNullOrEmpty(txtName.Text))
{
await DisplayAlert("Atenção", "Digite um nome válido!", "Entendi");
txtName.Focus();
return;
}
if (String.IsNullOrEmpty(txtLogin.Text))
{
await DisplayAlert("Atenção", "Digite um login válido!", "Entendi");
txtLogin.Focus();
return;
}
if (String.IsNullOrEmpty(txtSenha.Text))
{
await DisplayAlert("Atenção", "Digite uma senha válida!", "Entendi");
txtSenha.Focus();
return;
}
ValidaEmail validEmail = new ValidaEmail();
if (!validEmail.IsValidEmail(txtLogin.Text))
{
await DisplayAlert("Atenção", "Esse não é um e-mail válido!", "Entendi");
txtLogin.Focus();
return;
}
DtoAvatar avatar = new DtoAvatar();
avatar = (DtoAvatar)ItemsCollectionView.SelectedItem;
if (avatar == null)
{
await DisplayAlert("Atenção", "É necessário escolher um avatar", "Entendi");
ItemsCollectionView.Focus();
return;
}
try
{
using (var client = new HttpClient())
{
waitActivityIndicator.IsRunning = true;
var unitTrackerRequest = new DtoUnitTracker
{
Name = txtName.Text,
Login = txtLogin.Text,
Password = txtSenha.Text,
CalculoDistancia = Convert.ToInt32(lblCalculoDistancia.Text),
IntervaloPosicao = Convert.ToInt32(lblIntervaloPosicao.Text),
IntervaloPosicaoParado = Convert.ToInt32(lblIntervaloPosicaoParado.Text),
IdAdmin = (int)Application.Current.Properties["IdUser"],
Avatar = avatar.Name
};
var jsonRequest = JsonConvert.SerializeObject(unitTrackerRequest);
var httpContent = new StringContent(jsonRequest, Encoding.UTF8, "application/json");
string uri = "http://207.180.246.227:8095/admin/UnitTracker/Insert";
var retorno = await client.PostAsync(uri, httpContent);
var resultString = await retorno.Content.ReadAsStringAsync();
if (retorno.StatusCode == System.Net.HttpStatusCode.BadRequest)
{
await DisplayAlert("Erro", resultString, "Ok");
waitActivityIndicator.IsRunning = false;
return;
}
await DisplayAlert("Sucesso.", "Unidade rastreada criada com sucesso!", "Cadastrado");
waitActivityIndicator.IsRunning = false;
}
}
catch (Exception ex)
{
await DisplayAlert("Erro", ex.Message, "Erro ao cadastrar...");
waitActivityIndicator.IsRunning = false;
return;
}
await Navigation.PopModalAsync();
}
public DtoUnitTracker GetUnitTracker(Int32 paramIdUnitTracker)
{
try
{
DtoUnitTracker unitTracker = null;
using (SqlConnection con = new SqlConnection(GetConnectionString()))
{
SqlCommand cmd = new SqlCommand("[dbo].[pr_getUnitTracker]", con)
{
CommandType = CommandType.StoredProcedure
};
SqlDataReader sqlDataReader = null;
cmd.Parameters.AddWithValue("@prmIdUnitTracker", paramIdUnitTracker);
con.Open();
sqlDataReader = cmd.ExecuteReader();
if (sqlDataReader.Read())
{
unitTracker = new DtoUnitTracker();
if (!sqlDataReader.IsDBNull(0))
{
unitTracker.IdUser = sqlDataReader.GetInt32(0);
}
if (!sqlDataReader.IsDBNull(1))
{
unitTracker.Name = sqlDataReader.GetString(1);
}
if (!sqlDataReader.IsDBNull(2))
{
unitTracker.Login = sqlDataReader.GetString(2);
}
if (!sqlDataReader.IsDBNull(3))
{
unitTracker.CalculoDistancia = sqlDataReader.GetInt32(3);
}
if (!sqlDataReader.IsDBNull(4))
{
unitTracker.CreatedDate = sqlDataReader.GetDateTime(4);
}
if (!sqlDataReader.IsDBNull(5))
{
unitTracker.IntervaloPosicao = sqlDataReader.GetInt32(5);
}
if (!sqlDataReader.IsDBNull(6))
{
unitTracker.Avatar = sqlDataReader.GetString(6);
}
if (!sqlDataReader.IsDBNull(7))
{
unitTracker.IntervaloPosicaoParado = sqlDataReader.GetInt32(7);
}
}
return(unitTracker);
}
}
catch (Exception Ex)
{
throw new Exception(Ex.Message);
}
}
public ItemDetailViewModel(DtoUnitTracker item = null)
{
Title = item?.Name;
Item = item;
}
private async void Save_ButtonClicked(object sender, EventArgs e)
{
if (String.IsNullOrEmpty(txtName.Text))
{
await DisplayAlert("Erro", "Digite um nome válido!", "Aceitar");
txtName.Focus();
return;
}
if (String.IsNullOrEmpty(txtLogin.Text))
{
await DisplayAlert("Erro", "Digite um login válido!", "Aceitar");
txtLogin.Focus();
return;
}
try
{
using (var client = new HttpClient())
{
waitActivityIndicator.IsRunning = true;
var unitTrackerRequest = new DtoUnitTracker
{
IdUser = this.viewModel.Item.IdUser,
Name = txtName.Text,
Login = txtLogin.Text,
Password = txtSenha.Text,
CalculoDistancia = Convert.ToInt32(lblCalculoDistancia.Text),
IntervaloPosicao = Convert.ToInt32(lblIntervaloPosicao.Text),
IntervaloPosicaoParado = Convert.ToInt32(lblIntervaloPosicaoParado.Text)
};
var jsonRequest = JsonConvert.SerializeObject(unitTrackerRequest);
var httpContent = new StringContent(jsonRequest, Encoding.UTF8, "application/json");
string uri = "http://207.180.246.227:8095/admin/UnitTracker/Update";
var retorno = await client.PostAsync(uri, httpContent);
var resultString = await retorno.Content.ReadAsStringAsync();
if (retorno.StatusCode == System.Net.HttpStatusCode.BadRequest)
{
await DisplayAlert("Erro", resultString, "Ok");
waitActivityIndicator.IsRunning = false;
return;
}
await DisplayAlert("Sucesso.", "Unidade rastreada atualizada com sucesso!", "Atualizado");
waitActivityIndicator.IsRunning = false;
}
}
catch (Exception ex)
{
await DisplayAlert("Erro", ex.Message, "Erro ao atualizar...");
waitActivityIndicator.IsRunning = false;
return;
}
}
