/// <summary>Cria um novo usuário</sumary>
public ObjResult Post(User user)
{
connection = db.GetCon();
connection.Open();
NpgsqlTransaction transaction = connection.BeginTransaction();
UserDao dao = new UserDao(connection, transaction);
ObjResult result = new ObjResult();
try
{
user.SetId(dao.Post(user));
transaction.Commit();
result.Success();
result.SetData(user.GetId());
}
catch (Exception e)
{
transaction.Rollback();
throw new Exception(e.ToString());
}
finally
{
connection.Close();
}
return(result);
}
private async Task <IActionResult> GetRequestResponseAsync <T>(long id, RequestType.RequestTypeCode requestType) where T : class
{
IActionResult result;
try
{
ObjResult <RequestResponseDto <T> > requestStatusResult =
await _requestService.GetRequestResponseAsync <T>(id, requestType);
if (requestStatusResult.IsOk)
{
_logger.LogDebug("{0} Ok for Id: '{1}' type: '{2}' -> {3}",
LogDescription(), id, requestType, requestStatusResult.Object.Status);
result = Ok(requestStatusResult.Object);
}
else
{
_logger.LogError($"{LogDescription()} Request with Id: '{id}' and type '{requestType}' not found");
result = BadRequest($"Request with Id: '{id}' not found...");
}
}
catch (Exception ex)
{
_logger.LogError("[{0}] Ex for Id: '{1}' type: '{2}': {3}", nameof(GetRequestResponseAsync), id, requestType, ex);
result = InternalServerError(ex.Message);
}
return(result);
}
public ObjResult EditaEmpleado(int Id, String Nombre, int Edad, String Direccion, int Telefono, int SueldoHora, int IdPuesto, int HorasTrabajadas, int IdTienda, Boolean Check)
{
Lo_Resultado = new ObjResult();
Lo_MdlEmpleados = new MdlEmpleados();
Lo_AEmpleados = new AEmpleados();
try
{
Lo_MdlEmpleados.Id = Id;
Lo_MdlEmpleados.NombreE = Nombre;
Lo_MdlEmpleados.Edad = Edad;
Lo_MdlEmpleados.Direccion = Direccion;
Lo_MdlEmpleados.Telefono = Telefono;
Lo_MdlEmpleados.SueldoHora = SueldoHora;
Lo_MdlEmpleados.IdPuesto = IdPuesto;
Lo_MdlEmpleados.HorasTrabajadas = HorasTrabajadas;
Lo_MdlEmpleados.IdTienda = IdTienda;
Lo_MdlEmpleados.Activo = Check;
Lo_Resultado = Lo_AEmpleados.EditaEmpleado(Lo_MdlEmpleados);
}
catch (Exception ex)
{
Lo_Resultado.Mensaje = ex.Message;
Lo_Resultado.BooleanValue = false;
}
return(Lo_Resultado);
}
/// <summary>Define o status de um determinado item</sumary>
public ObjResult SetStatus(int item_id, string status_name)
{
connection = db.GetCon();
connection.Open();
NpgsqlTransaction transaction = connection.BeginTransaction();
RequestItemDao dao = new RequestItemDao(connection, transaction);
ObjResult result = new ObjResult();
try
{
item_id = dao.SetStatus(item_id, status_name);
transaction.Commit();
result.Success();
result.SetData(item_id);
}
catch (Exception e)
{
transaction.Rollback();
throw new Exception(e.ToString());
}
finally
{
connection.Close();
db.Close();
}
return(result);
}
public void EditaEmpleado(int Id, String Nombre, int Edad, String Direccion, int Telefono, int SueldoHora, int IdPuesto, int HorasTrabajadas, int IdTienda, Boolean Check)
{
Lo_Resultado = new ObjResult();
Lo_MEmpleados = new MEmpleados();
Lo_Resultado = Lo_MEmpleados.EditaEmpleado(Id, Nombre, Edad, Direccion, Telefono, SueldoHora, IdPuesto, HorasTrabajadas, IdTienda, Check);
}
/// <summary>Atualiza uma requisição</sumary>
public ObjResult Update(int request_id, Request request)
{
connection = db.GetCon();
connection.Open();
NpgsqlTransaction transaction = connection.BeginTransaction();
RequestDao dao = new RequestDao(connection, transaction);
ObjResult result = new ObjResult();
try
{
request_id = dao.Update(request_id, request);
transaction.Commit();
result.Success();
result.SetData(request_id);
}
catch (Exception e)
{
transaction.Rollback();
throw new Exception(e.ToString());
}
finally
{
connection.Close();
db.Close();
}
return(result);
}
private ObjResult getObjResult(DataType dt, int arrayLength)
{
WebClient webClient = new WebClient();
ObjResult obj = null;
string text;
switch (dt)
{
case DataType.uint8:
text = webClient.DownloadString("https://qrng.anu.edu.au/API/jsonI.php?length=" + arrayLength + "&type=uint8");
obj = JsonConvert.DeserializeObject <ObjResult8>(text);
break;
case DataType.uint16:
text = webClient.DownloadString("https://qrng.anu.edu.au/API/jsonI.php?length=" + arrayLength + "&type=uint16");
obj = JsonConvert.DeserializeObject <ObjResult16>(text);
break;
case DataType.hex16:
text = webClient.DownloadString("https://qrng.anu.edu.au/API/jsonI.php?length=" + arrayLength + "&type=hex16&size=4");
obj = JsonConvert.DeserializeObject <ObjResultEx>(text);
break;
}
return(obj);
}
/// <summary>Cria um novo item e atribui à uma requisição</sumary>
public ObjResult Post(ItemProgress progress, int user_id, int item_id, int item_status_id)
{
connection = db.GetCon();
connection.Open();
NpgsqlTransaction transaction = connection.BeginTransaction();
ItemProgressDao dao = new ItemProgressDao(connection, transaction);
ObjResult result = new ObjResult();
try
{
progress.SetId(dao.Post(progress, user_id, item_id, item_status_id));
transaction.Commit();
result.Success();
result.SetData(progress.GetId());
}
catch (Exception e)
{
transaction.Rollback();
throw new Exception(e.ToString());
}
finally
{
connection.Close();
db.Close();
}
return(result);
}
/// <summary>Atualiza um item</sumary>
public ObjResult Update(int item_progress_id, ItemProgress progress)
{
connection = db.GetCon();
connection.Open();
NpgsqlTransaction transaction = connection.BeginTransaction();
ItemProgressDao dao = new ItemProgressDao(connection, transaction);
ObjResult result = new ObjResult();
try
{
item_progress_id = dao.Update(item_progress_id, progress);
transaction.Commit();
result.Success();
result.SetData(item_progress_id);
}
catch (Exception e)
{
transaction.Rollback();
throw new Exception(e.ToString());
}
finally
{
connection.Close();
db.Close();
}
return(result);
}
/// <summary>Exclui uma determinada mensagem</sumary>
public ObjResult DeleteMessage(int msg_id)
{
connection = db.GetCon();
connection.Open();
NpgsqlTransaction transaction = connection.BeginTransaction();
MessageDao dao = new MessageDao(connection, transaction);
ObjResult result = new ObjResult();
try
{
msg_id = dao.Delete(msg_id);
result.SetData(msg_id);
result.Success();
transaction.Commit();
}
catch (Exception e)
{
transaction.Rollback();
throw new Exception(e.ToString());
}
finally
{
connection.Close();
}
return(result);
}
public ObjResult Save(UserPermission obj, int user_id, string action)
{
connection = db.GetCon();
connection.Open();
int id;
ObjResult objResult = new ObjResult();
UserPermissionBusiness bus = new UserPermissionBusiness(connection);
List <string> messages_list = new List <string>();
//validações
try
{
messages_list = bus.Validate(obj, user_id, action);
if (messages_list.Count > 0)
{
objResult.resultStatus = "error";
objResult.resultMessages = messages_list;
connection.Close();
return(objResult);
}
}
finally
{
connection.Close();
}
NpgsqlTransaction transaction = null;
try
{
connection.Open();
transaction = connection.BeginTransaction();
UserPermissionDao dao = new UserPermissionDao(connection, transaction);
id = dao.Post(obj);
LogDao logDao = new LogDao(connection, transaction);
logDao.Post(new Log(user_id, "UserPermission", action, id.ToString(), JsonConvert.SerializeObject(obj)));
objResult.resultStatus = "success";
objResult.data = id;
transaction.Commit();
}
catch (Exception ex)
{
if (transaction != null)
{
transaction.Rollback();
}
throw new Exception(ex.ToString());
}
finally
{
connection.Close();
}
return(objResult);
}
/// <summary>Faz a autenticação do usuário</sumary>
public ObjResult Authenticate(string username, string password, string system_flag)
{
connection = db.GetCon();
ObjResult objResult = new ObjResult();
List <string> listMessages = new List <String>();
try
{
connection.Open();
LogDao logDao = new LogDao(connection, null);
UserLogged user = new UserDao(connection, null).Authenticate(username, password, system_flag);
// Se a autenticação for bem sucedida, gerar o token JWT
if (user.id != 0)
{
var tokenHandler = new JwtSecurityTokenHandler();
var configuration = Builder.GetConfiguration();
var key = Encoding.ASCII.GetBytes(configuration.GetSection("Permissions:SecretKey").Value);
var tokenDescriptor = new SecurityTokenDescriptor
{
Subject = new ClaimsIdentity(new Claim[]
{
new Claim("use_id", user.id.ToString())
}),
Expires = DateTime.UtcNow.AddDays(1),
SigningCredentials = new SigningCredentials(new SymmetricSecurityKey(key), SecurityAlgorithms.HmacSha256Signature)
};
var token = tokenHandler.CreateToken(tokenDescriptor);
user.token = tokenHandler.WriteToken(token);
logDao.Post(new Log(user.id, "User", "Login", username, ""));
objResult.resultStatus = "success";
objResult.data = user;
}
else
{
logDao.Post(new Log(0, "User", "ErroLogin", username, username + " : " + password));
listMessages.Add("Usuário ou senha inválidos.");
objResult.resultStatus = "error";
objResult.resultMessages = listMessages;
}
}
catch (Exception e)
{
listMessages.Add(e.Message);
objResult.resultStatus = "error";
objResult.resultMessages = listMessages;
}
finally
{
connection.Close();
}
return(objResult);
}
public void CargaTiendaEmpleados()
{
Lo_Resultado = new ObjResult();
Lo_MEmpleados = new MEmpleados();
Lo_Resultado = Lo_MEmpleados.CargaTiendaEmpleados();
gvTiendasEmpleados.DataSource = Lo_Resultado.Tabla;
gvTiendasEmpleados.DataBind();
}
public void CargaArticulos()
{
Lo_Resultado = new ObjResult();
Lo_MVentas = new MVentas();
Lo_Resultado = Lo_MVentas.ConsultaArticulos();
gvArticulos.DataSource = Lo_Resultado.Tabla;
gvArticulos.DataBind();
}
public void CargarEmpleados()
{
Lo_Resultado = new ObjResult();
Lo_MEmpleados = new MEmpleados();
Lo_Resultado = Lo_MEmpleados.ConsultaUsuario(txtNombre.Text.Trim(), Convert.ToInt16(ddlTienda.SelectedValue.ToString()));
gvTrabajadores.DataSource = Lo_Resultado.Tabla;
gvTrabajadores.DataBind();
}
/// <summary>Exclui uma determinada requisição</sumary>
public ObjResult Delete(int request_id)
{
connection = db.GetCon();
connection.Open();
ObjResult result = new ObjResult();
List <RequestItem> items = new List <RequestItem>();
List <Message> messages = new List <Message>();
// Excluir a requisição
NpgsqlTransaction transaction = connection.BeginTransaction();
RequestDao dao = new RequestDao(connection, transaction);
RequestItemDao itemDao = new RequestItemDao(connection, transaction);
MessageDao messageDao = new MessageDao(connection, transaction);
try
{
// Verifica se a requisição possui itens
items = itemDao.GetItemsByRequest(request_id);
if (items.Count > 0)
{
// Exclui todos os itens que pertencem à requisição
foreach (RequestItem item in items)
{
itemDao.Delete(item.itm_id);
}
}
// Verifica se a requisição possui mensagens
messages = messageDao.GetMessagesBySourceKey(request_id);
if (messages.Count > 0)
{
// Exclui todas as mensagens associadas à requisição
foreach (Message msg in messages)
{
messageDao.Delete(msg.msg_id);
}
}
request_id = dao.Delete(request_id);
result.SetData(request_id);
result.Success();
transaction.Commit();
}
catch (Exception e)
{
transaction.Rollback();
throw new Exception(e.ToString());
}
finally
{
connection.Close();
}
return(result);
}
public void CargaDDLTiendaE()
{
Lo_Resultado = new ObjResult();
Lo_MEmpleados = new MEmpleados();
Lo_Resultado = Lo_MEmpleados.CargaDDLTiendaE();
ddlTiendaE.DataSource = Lo_Resultado.Tabla;
ddlTiendaE.DataTextField = "Nombre";
ddlTiendaE.DataValueField = "Id";
ddlTiendaE.DataBind();
}
/// <summary>Atualiza um item</sumary>
public ObjResult Update(int item_id, RequestItem item, int user_id, string action)
{
connection = db.GetCon();
connection.Open();
RequestItemBusiness business = new RequestItemBusiness(connection, null);
List <string> messages_list = new List <string>();
ObjResult result = new ObjResult();
try
{
item.SetId(item_id); // <-- Assegura que o item possua um id para atualização
messages_list = business.Validate(item, user_id, action);
if (messages_list.Count > 0)
{
result.resultStatus = "error";
result.resultMessages = messages_list;
connection.Close();
return(result);
}
}
finally
{
connection.Close();
}
connection.Open();
NpgsqlTransaction transaction = connection.BeginTransaction();
RequestItemDao dao = new RequestItemDao(connection, transaction);
try
{
item_id = dao.Update(item_id, item);
transaction.Commit();
result.Success();
result.SetData(item_id);
}
catch (Exception e)
{
transaction.Rollback();
throw new Exception(e.ToString());
}
finally
{
connection.Close();
db.Close();
}
return(result);
}
public ObjResult CargaTiendaEmpleados()
{
Lo_Resultado = new ObjResult();
Lo_AEmpleados = new AEmpleados();
try
{
Lo_Resultado = Lo_AEmpleados.CargaTiendaEmpleados();
}
catch (Exception ex)
{
Lo_Resultado.Mensaje = ex.Message;
Lo_Resultado.BooleanValue = false;
}
return(Lo_Resultado);
}
public ObjResult ConsultaArticulos()
{
Lo_Resultado = new ObjResult();
Lo_AVentas = new AVentas();
try
{
Lo_Resultado = Lo_AVentas.ConsultaArticulos();
}
catch (Exception ex)
{
Lo_Resultado.Mensaje = ex.Message;
Lo_Resultado.BooleanValue = false;
}
return(Lo_Resultado);
}
public IActionResult valida_token()
{
//int use_id = token.GetIdUserToken(Request.Headers["Authorization"]);
try
{
ObjResult objResult = new ObjResult();
objResult.resultStatus = "success";
objResult.data = "token validado com suecesso.";
return(Ok(objResult));
}
catch (Exception e)
{
return(BadRequest(errorHandler.DealError(e)));
}
}
public async void GetPostStatusOk()
{
// Arrange
long postId = _fixture.Create <long>();
var requestType = RequestType.RequestTypeCode.ADDPOST;
string expectedRequestStatus = _fixture.Create <string>();
var expectedResponse = new ObjResult <RequestResponseDto <GoogleInfo> >()
{
IsOk = true, Object = new RequestResponseDto <GoogleInfo> {
Id = postId, Status = expectedRequestStatus
}
};
_postServiceMock
.Setup(x => x.GetRequestResponseAsync <GoogleInfo>(postId, requestType))
.ReturnsAsync(expectedResponse);
// Act
IActionResult actionResult = await _controller.GetPostStatus(postId);
// Assert
_postServiceMock.Verify(
x => x.GetRequestResponseAsync <GoogleInfo>(postId, requestType),
Times.Once);
_loggerMock.Verify(m => m.Log(
LogLevel.Debug,
0,
It.Is <FormattedLogValues>(v => v.ToString()
.Contains($"Ok for Id: '{postId}' type: '{requestType}' -> {expectedRequestStatus}")),
null,
It.IsAny <Func <object, Exception, string> >()
));
actionResult.Should().NotBeNull().And.BeOfType <OkObjectResult>();
var objectResult = actionResult as OkObjectResult;
objectResult.StatusCode.Should().Be(StatusCodes.Status200OK);
objectResult.Value.Should().NotBeNull().And.BeOfType <RequestResponseDto <GoogleInfo> >();
var requestResponse = objectResult.Value as RequestResponseDto <GoogleInfo>;
requestResponse.Error.Should().BeNull();
requestResponse.Id.Should().Be(postId);
requestResponse.Status.Should().Be(expectedRequestStatus);
}
public async Task <ObjResult <RequestResponseDto <T> > > GetRequestResponseAsync <T>(long id, RequestType.RequestTypeCode requestType) where T : class
{
ObjResult <RequestResponseDto <T> > res = new ObjResult <RequestResponseDto <T> >();
Request request = await _requestRepository.GetRequestWithQueueAsync(id, requestType.ToString());
if (request != null)
{
res.IsOk = true;
res.Object = PrepareRequestResponse <T>(request);
}
else
{
res.Message = $"Request with Id: '{id}' not found...";
}
return(res);
}
protected void Entrar_Click(object sender, EventArgs e)
{
if (IsPostBack)
{
Lo_Resultado = new ObjResult();
Lo_MUsuario = new MLogin();
Lo_Resultado = Lo_MUsuario.ConsultaUsuario(txtUsuario.Text.Trim(), txtClave.Text.Trim());
if (Lo_Resultado.BooleanValue)
{
Response.Redirect("././Presentacion/Bienvenida.aspx");
}
else
{
Mensaje("Usuario no Encontrado");
}
}
}
public ObjResult ConsultaUsuario(string Usuario, string Clave)
{
Lo_Resultado = new ObjResult();
Lo_MdlUsuario = new MdlUsuario();
Lo_ALogin = new ALogin();
try
{
Lo_MdlUsuario.Usuario = Usuario;
Lo_MdlUsuario.Clave = Clave;
Lo_Resultado = Lo_ALogin.ConsultaUsuario(Lo_MdlUsuario);
}
catch (Exception ex)
{
Lo_Resultado.Mensaje = ex.Message;
Lo_Resultado.BooleanValue = false;
}
return(Lo_Resultado);
}
public ObjResult ConsultaUsuario(string Nombre, int IdTienda)
{
Lo_Resultado = new ObjResult();
Lo_MdlEmpleados = new MdlEmpleados();
Lo_AEmpleados = new AEmpleados();
try
{
Lo_MdlEmpleados.Nombre = Nombre;
Lo_MdlEmpleados.IdTienda = IdTienda;
Lo_Resultado = Lo_AEmpleados.ConsultaEmpleados(Lo_MdlEmpleados);
}
catch (Exception ex)
{
Lo_Resultado.Mensaje = ex.Message;
Lo_Resultado.BooleanValue = false;
}
return(Lo_Resultado);
}
public ObjResult Get(int per_id, int user_id, string action)
{
connection = db.GetCon();
connection.Open();
ObjResult objResult = new ObjResult();
UserPermissionBusiness bus = new UserPermissionBusiness(connection);
UserPermission obj = new UserPermission();
List <string> messages_list = new List <string>();
UserPermissionDao dao = new UserPermissionDao(connection, null);
//validações
try
{
messages_list = bus.Validate(null, user_id, action);
if (messages_list.Count > 0)
{
objResult.resultStatus = "error";
objResult.resultMessages = messages_list;
connection.Close();
return(objResult);
}
obj = dao.GetById(per_id);
if (obj.per_id != 0)
{
objResult.resultStatus = "success";
objResult.data = obj;
}
else
{
messages_list.Add("Registro não encontrado.");
objResult.resultStatus = "error";
objResult.resultMessages = messages_list;
}
}
finally
{
connection.Close();
}
return(objResult);
}
/// <summary>Marca como importante uma determinada mensagem</sumary>
public ObjResult MarkAsImportant(int msg_id)
{
connection = db.GetCon();
connection.Open();
MessageDao dao = new MessageDao(connection, null);
ObjResult result = new ObjResult();
try
{
msg_id = dao.IsImportant(msg_id);
result.SetData(msg_id);
result.Success();
}
finally
{
connection.Close();
}
return(result);
}
/// <summary>Exclui um determinado progresso de item</sumary>
public ObjResult Delete(int item_progress_id)
{
connection = db.GetCon();
connection.Open();
ItemProgressDao dao = new ItemProgressDao(connection, null);
ObjResult result = new ObjResult();
try
{
item_progress_id = dao.Delete(item_progress_id);
result.SetData(item_progress_id);
result.Success();
}
finally
{
connection.Close();
db.Close();
}
return(result);
}
/// <summary>Cancela um determinado item</sumary>
public ObjResult Cancel(int item_id)
{
connection = db.GetCon();
connection.Open();
RequestItemDao dao = new RequestItemDao(connection, null);
ObjResult result = new ObjResult();
try
{
item_id = dao.Cancel(item_id);
result.SetData(item_id);
result.Success();
}
finally
{
connection.Close();
db.Close();
}
return(result);
}
