public HttpResponseMessage Post(Nombre_del_campo_en_MS varNombre_del_campo_en_MS)
{
if (ModelState.IsValid)
{
var data = "-1";
try
{
data = Convert.ToString(this.service.Insert(varNombre_del_campo_en_MS));
var bitacora = BitacoraHelper.GetBitacora(Request, object_id, Convert.ToInt32(data), BitacoraHelper.TypeSql.INSERT, "sp_InsNombre_del_campo_en_MS", new JavaScriptSerializer().Serialize(varNombre_del_campo_en_MS), true);
serviceBitacora.Insert(bitacora);
}
catch (ServiceException ex)
{
var bitacora = BitacoraHelper.GetBitacora(Request, object_id, 0, BitacoraHelper.TypeSql.INSERT, "sp_InsNombre_del_campo_en_MS", new JavaScriptSerializer().Serialize(varNombre_del_campo_en_MS), 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_InsNombre_del_campo_en_MS", new JavaScriptSerializer().Serialize(varNombre_del_campo_en_MS), false, errors.ToString());
serviceBitacora.Insert(bitacora);
return(Request.CreateResponse(HttpStatusCode.BadRequest, errors));
}
}
public HttpResponseMessage Delete(int id)
{
Nombre_del_campo_en_MS varNombre_del_campo_en_MS = this.service.GetByKey(id, false);
bool result = false;
if (varNombre_del_campo_en_MS == 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_DelNombre_del_campo_en_MS", new JavaScriptSerializer().Serialize(varNombre_del_campo_en_MS), result);
serviceBitacora.Insert(bitacora);
}
catch (ServiceException ex)
{
var bitacora = BitacoraHelper.GetBitacora(Request, object_id, id, BitacoraHelper.TypeSql.DELETE, "sp_DelNombre_del_campo_en_MS", new JavaScriptSerializer().Serialize(varNombre_del_campo_en_MS), result, ex.Message);
serviceBitacora.Insert(bitacora);
return(Request.CreateResponse(HttpStatusCode.InternalServerError, ex.Message));
}
return(Request.CreateResponse(HttpStatusCode.OK, result));
}
public HttpResponseMessage Get_Datos_Generales(int id)
{
Nombre_del_campo_en_MS entity = this.service.ListaSelAll(1, 1, "Nombre_del_campo_en_MS.Clave='" + id.ToString() + "'", "").Nombre_del_campo_en_MSs.First();
Nombre_del_campo_en_MS result = new Nombre_del_campo_en_MS();
result.Clave = entity.Clave;
result.Descripcion = entity.Descripcion;
result.Nombre_Fisico_del_Campo = entity.Nombre_Fisico_del_Campo;
result.Nombre_Fisico_de_la_Tabla = entity.Nombre_Fisico_de_la_Tabla;
return(Request.CreateResponse(HttpStatusCode.OK, result, Configuration.Formatters.JsonFormatter));
}
public HttpResponseMessage PutTunnel(Nombre_del_campo_en_MS 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.Clave), "PUT"
, dataString);
return(Request.CreateResponse(HttpStatusCode.OK, result, Configuration.Formatters.JsonFormatter));
}
public HttpResponseMessage Put_Datos_Generales(Nombre_del_campo_en_MS varNombre_del_campo_en_MS_Datos_Generales)
{
var data = "-1";
try
{
data = Convert.ToString(this.service.Update_Datos_Generales(varNombre_del_campo_en_MS_Datos_Generales));
var bitacora = BitacoraHelper.GetBitacora(Request, object_id, varNombre_del_campo_en_MS_Datos_Generales.Clave, BitacoraHelper.TypeSql.UPDATE, "sp_UpdNombre_del_campo_en_MS", new JavaScriptSerializer().Serialize(varNombre_del_campo_en_MS_Datos_Generales), true);
serviceBitacora.Insert(bitacora);
}
catch (ServiceException ex)
{
var bitacora = BitacoraHelper.GetBitacora(Request, object_id, varNombre_del_campo_en_MS_Datos_Generales.Clave, BitacoraHelper.TypeSql.UPDATE, "sp_UpdNombre_del_campo_en_MS", new JavaScriptSerializer().Serialize(varNombre_del_campo_en_MS_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 Nombre_del_campo_en_MSGenerateID()
{
Nombre_del_campo_en_MS varNombre_del_campo_en_MS = new Nombre_del_campo_en_MS();
var data = "-1";
try
{
data = Convert.ToString(this.service.Insert(varNombre_del_campo_en_MS));
var bitacora = BitacoraHelper.GetBitacora(Request, object_id, Convert.ToInt32(data), BitacoraHelper.TypeSql.INSERT, "sp_Nombre_del_campo_en_MSGenerateID", new JavaScriptSerializer().Serialize(varNombre_del_campo_en_MS), true);
serviceBitacora.Insert(bitacora);
}
catch (ServiceException ex)
{
var bitacora = BitacoraHelper.GetBitacora(Request, object_id, 0, BitacoraHelper.TypeSql.INSERT, "sp_Nombre_del_campo_en_MSGenerateID", new JavaScriptSerializer().Serialize(varNombre_del_campo_en_MS), true);
serviceBitacora.Insert(bitacora);
return(Request.CreateResponse(HttpStatusCode.InternalServerError, ex.Message));
}
return(Request.CreateResponse(HttpStatusCode.OK, data, Configuration.Formatters.JsonFormatter));
}
