public IActionResult Get(int id)
{
Respuesta resp = new Respuesta();
resp.status = "Error";
resp.data = null;
try
{
using (DB_A6ED12_testmototekDBContext db = new DB_A6ED12_testmototekDBContext())
{
var idSearch = new SqlParameter("Id", id);
Transferencium data = db.Transferencia.FromSqlRaw("Select * from Transferencia where IdTransferencia = @Id", idSearch)
.FirstOrDefault();
resp.status = "Ok";
resp.message = "Success";
resp.data = data;
return(Ok(resp));
}
}
catch (Exception message)
{
resp.message = message.Message;
return(BadRequest(resp));
}
}
public IActionResult Post([FromBody] Transferencium value)
{
Respuesta resp = new Respuesta();
resp.status = "Error";
resp.data = null;
try
{
using (DB_A6ED12_testmototekDBContext db = new DB_A6ED12_testmototekDBContext())
{
SqlParameter[] sqlParams = new SqlParameter[]
{
new SqlParameter("@TRANSFERENCIA", value.IdTransferencia),
new SqlParameter("@CLABE", value.Clabe),
new SqlParameter("@ACTIVO", value.Activo),
new SqlParameter("@FECHADECREACION", DateTime.Now),
new SqlParameter("@FECHADEMODIFICACION", DateTime.Now),
};
var data = db.Database.ExecuteSqlRaw("INSERT INTO [dbo].[TRANSFERENCIA] ([Clabe],[Activo],[FechaDeCreacion],[FechaDeModificacion]) VALUES (@CLABE, @ACTIVO, @FECHADECREACION, @FECHADEMODIFICACION)", sqlParams);
/*
* SqlParameter[] sqlParamsLogs = new SqlParameter[]
* {
* new SqlParameter("@IDUSER", "0"),
* new SqlParameter("@TABLE", "TRANSFERENCIA"),
* new SqlParameter("@FIELD", "AGREGO"),
* new SqlParameter("@ANTERIOR", ""),
* new SqlParameter("@NUEVO", ""),
* new SqlParameter("@DATE", ""),
* };
* db.Database.ExecuteSqlRaw("[dbo].[sp_insertIntoLogs] @IDUSER, @TABLE, @FIELD, @ANTERIOR, @NUEVO, @DATE", sqlParamsLogs);
*/
resp.status = "Ok";
resp.message = "Success";
resp.data = data;
return(Ok(resp));
}
}
catch (Exception message)
{
resp.message = message.Message;
return(BadRequest(resp));
}
}
