public HttpResponseMessage Post(MR_Tarjetas varMR_Tarjetas)
{
if (ModelState.IsValid)
{
var data = "-1";
try
{
data = Convert.ToString(this.service.Insert(varMR_Tarjetas));
var bitacora = BitacoraHelper.GetBitacora(Request, object_id, Convert.ToInt32(data), BitacoraHelper.TypeSql.INSERT, "sp_InsMR_Tarjetas", new JavaScriptSerializer().Serialize(varMR_Tarjetas), true);
serviceBitacora.Insert(bitacora);
}
catch (ServiceException ex)
{
var bitacora = BitacoraHelper.GetBitacora(Request, object_id, 0, BitacoraHelper.TypeSql.INSERT, "sp_InsMR_Tarjetas", new JavaScriptSerializer().Serialize(varMR_Tarjetas), true);
serviceBitacora.Insert(bitacora);
return(Request.CreateResponse(HttpStatusCode.InternalServerError, ex.Message));
}
return(Request.CreateResponse(HttpStatusCode.OK, data, Configuration.Formatters.JsonFormatter));
}
else
{
var errors = ModelState.SelectMany(m => m.Value.Errors.Select(err => err.ErrorMessage != string.Empty ? err.ErrorMessage : err.Exception.Message).ToList()).ToList();
var bitacora = BitacoraHelper.GetBitacora(Request, object_id, 0, BitacoraHelper.TypeSql.INSERT, "sp_InsMR_Tarjetas", new JavaScriptSerializer().Serialize(varMR_Tarjetas), false, errors.ToString());
serviceBitacora.Insert(bitacora);
return(Request.CreateResponse(HttpStatusCode.BadRequest, errors));
}
}
public HttpResponseMessage Delete(int id)
{
MR_Tarjetas varMR_Tarjetas = this.service.GetByKey(id, false);
bool result = false;
if (varMR_Tarjetas == null)
{
return(Request.CreateResponse(HttpStatusCode.NotFound));
}
try
{
result = this.service.Delete(id);//, globalData, dataReference);
var bitacora = BitacoraHelper.GetBitacora(Request, object_id, id, BitacoraHelper.TypeSql.DELETE, "sp_DelMR_Tarjetas", new JavaScriptSerializer().Serialize(varMR_Tarjetas), result);
serviceBitacora.Insert(bitacora);
}
catch (ServiceException ex)
{
var bitacora = BitacoraHelper.GetBitacora(Request, object_id, id, BitacoraHelper.TypeSql.DELETE, "sp_DelMR_Tarjetas", new JavaScriptSerializer().Serialize(varMR_Tarjetas), result, ex.Message);
serviceBitacora.Insert(bitacora);
return(Request.CreateResponse(HttpStatusCode.InternalServerError, ex.Message));
}
return(Request.CreateResponse(HttpStatusCode.OK, result));
}
public HttpResponseMessage PutTunnel(MR_Tarjetas emp, string user, string password)
{
var client = new System.Net.WebClient();
client.Headers = TokenManager.GetAuthenticationHeader(user, password);
client.Headers["Content-Type"] = "application/json";
var dataString = new JavaScriptSerializer().Serialize(emp);
var result = client.UploadString(new Uri(baseApi + ApiControllerUrl + "/Put?Id=" + emp.Folio), "PUT"
, dataString);
return(Request.CreateResponse(HttpStatusCode.OK, result, Configuration.Formatters.JsonFormatter));
}
public HttpResponseMessage Get_Datos_Generales(int id)
{
MR_Tarjetas entity = this.service.ListaSelAll(1, 1, "MR_Tarjetas.Folio='" + id.ToString() + "'", "").MR_Tarjetass.First();
MR_Tarjetas result = new MR_Tarjetas();
result.Folio = entity.Folio;
result.Tipo_de_Tarjeta = entity.Tipo_de_Tarjeta;
result.Tipo_de_Tarjeta_Tipo_de_Tarjeta = entity.Tipo_de_Tarjeta_Tipo_de_Tarjeta;
result.Numero_de_Tarjeta = entity.Numero_de_Tarjeta;
result.Nombre_del_Titular = entity.Nombre_del_Titular;
result.Ano_de_vigencia = entity.Ano_de_vigencia;
result.Mes_de_vigencia = entity.Mes_de_vigencia;
result.Alias_de_la_Tarjeta = entity.Alias_de_la_Tarjeta;
result.Estatus = entity.Estatus;
result.Estatus_Estatus = entity.Estatus_Estatus;
return(Request.CreateResponse(HttpStatusCode.OK, result, Configuration.Formatters.JsonFormatter));
}
public HttpResponseMessage Put_Datos_Generales(MR_Tarjetas varMR_Tarjetas_Datos_Generales)
{
var data = "-1";
try
{
data = Convert.ToString(this.service.Update_Datos_Generales(varMR_Tarjetas_Datos_Generales));
var bitacora = BitacoraHelper.GetBitacora(Request, object_id, varMR_Tarjetas_Datos_Generales.Folio, BitacoraHelper.TypeSql.UPDATE, "sp_UpdMR_Tarjetas", new JavaScriptSerializer().Serialize(varMR_Tarjetas_Datos_Generales), true);
serviceBitacora.Insert(bitacora);
}
catch (ServiceException ex)
{
var bitacora = BitacoraHelper.GetBitacora(Request, object_id, varMR_Tarjetas_Datos_Generales.Folio, BitacoraHelper.TypeSql.UPDATE, "sp_UpdMR_Tarjetas", new JavaScriptSerializer().Serialize(varMR_Tarjetas_Datos_Generales), false, ex.Message);
serviceBitacora.Insert(bitacora);
return(Request.CreateResponse(HttpStatusCode.InternalServerError, ex.Message));
}
return(Request.CreateResponse(HttpStatusCode.OK, data, Configuration.Formatters.JsonFormatter));
}
public HttpResponseMessage MR_TarjetasGenerateID()
{
MR_Tarjetas varMR_Tarjetas = new MR_Tarjetas();
var data = "-1";
try
{
data = Convert.ToString(this.service.Insert(varMR_Tarjetas));
var bitacora = BitacoraHelper.GetBitacora(Request, object_id, Convert.ToInt32(data), BitacoraHelper.TypeSql.INSERT, "sp_MR_TarjetasGenerateID", new JavaScriptSerializer().Serialize(varMR_Tarjetas), true);
serviceBitacora.Insert(bitacora);
}
catch (ServiceException ex)
{
var bitacora = BitacoraHelper.GetBitacora(Request, object_id, 0, BitacoraHelper.TypeSql.INSERT, "sp_MR_TarjetasGenerateID", new JavaScriptSerializer().Serialize(varMR_Tarjetas), true);
serviceBitacora.Insert(bitacora);
return(Request.CreateResponse(HttpStatusCode.InternalServerError, ex.Message));
}
return(Request.CreateResponse(HttpStatusCode.OK, data, Configuration.Formatters.JsonFormatter));
}
public ActionResult Post(bool IsNew, MR_TarjetasModel varMR_Tarjetas)
{
try
{
if (ModelState.IsValid)
{
if (!_tokenManager.GenerateToken())
{
return(Json(null, JsonRequestBehavior.AllowGet));
}
_IMR_TarjetasApiConsumer.SetAuthHeader(_tokenManager.Token);
var result = "";
var MR_TarjetasInfo = new MR_Tarjetas
{
Folio = varMR_Tarjetas.Folio
, Tipo_de_Tarjeta = varMR_Tarjetas.Tipo_de_Tarjeta
, Numero_de_Tarjeta = varMR_Tarjetas.Numero_de_Tarjeta
, Nombre_del_Titular = varMR_Tarjetas.Nombre_del_Titular
, Ano_de_vigencia = varMR_Tarjetas.Ano_de_vigencia
, Mes_de_vigencia = varMR_Tarjetas.Mes_de_vigencia
, Alias_de_la_Tarjeta = varMR_Tarjetas.Alias_de_la_Tarjeta
, Estatus = varMR_Tarjetas.Estatus
};
result = !IsNew?
_IMR_TarjetasApiConsumer.Update(MR_TarjetasInfo, null, null).Resource.ToString() :
_IMR_TarjetasApiConsumer.Insert(MR_TarjetasInfo, null, null).Resource.ToString();
return(Json(result, JsonRequestBehavior.AllowGet));
}
return(Json(false, JsonRequestBehavior.AllowGet));
}
catch (ServiceException ex)
{
return(Json(false, JsonRequestBehavior.AllowGet));
}
}
public ActionResult Delete(int id)
{
try
{
if (!_tokenManager.GenerateToken())
{
return(Json(null, JsonRequestBehavior.AllowGet));
}
_IMR_TarjetasApiConsumer.SetAuthHeader(_tokenManager.Token);
MR_Tarjetas varMR_Tarjetas = null;
if (id.ToString() != "0")
{
string where = "";
}
var result = _IMR_TarjetasApiConsumer.Delete(id, null, null).Resource;
return(Json(result, JsonRequestBehavior.AllowGet));
}
catch (ServiceException ex)
{
return(Json(false, JsonRequestBehavior.AllowGet));
}
}
