public HttpResponseMessage PutTunnel(Spartan_Bitacora_SQL 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 static Spartan_Bitacora_SQL GetBitacora(HttpRequestMessage request, int objectId, string Folio, TypeSql tipo, string commandText, string json, bool result, string error = null)
{
try
{
var bitacora = new Spartan_Bitacora_SQL();
var cnnString = ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString;
bitacora.Result = result;
bitacora.Error = error;
bitacora.Json = json;
System.Data.SqlClient.SqlConnectionStringBuilder builder = new System.Data.SqlClient.SqlConnectionStringBuilder(cnnString);
bitacora.Command_SQL = commandText;
bitacora.Computer_Name = Dns.GetHostName();
bitacora.Database_Name = builder.InitialCatalog;
bitacora.Folio_SQL = Folio.ToString();
IEnumerable <string> headerValues;
request.Headers.TryGetValues("Id_User", out headerValues);
if (headerValues != null)
{
var Id_User = headerValues.FirstOrDefault();
if (Id_User != null)
{
bitacora.Id_User = Convert.ToInt32(Id_User);
}
}
bitacora.IP = GetClientIpAddress();
// IPHostEntry entry = Dns.GetHostEntry(bitacora.IP);
bitacora.Object_Id = Convert.ToInt32(objectId);
bitacora.Register_Date = DateTime.Now;
bitacora.Server_Name = builder.DataSource;
bitacora.Type_SQL = tipo.ToString();
bitacora.Windows_Version = System.Environment.OSVersion.ToString();
bitacora.System_Version = ConfigurationManager.AppSettings["VersionApp"].ToString();
bitacora.System_Name = ConfigurationManager.AppSettings["SystemName"].ToString();
return(bitacora);
}
catch
{
throw;
}
}
public HttpResponseMessage Delete(int id)
{
Spartan_Bitacora_SQL varSpartan_Bitacora_SQL = this.service.GetByKey(id, false);
bool result = false;
if (varSpartan_Bitacora_SQL == null)
{
return(Request.CreateResponse(HttpStatusCode.NotFound));
}
try
{
result = this.service.Delete(id);//, globalData, dataReference);
}
catch (ServiceException ex)
{
return(Request.CreateResponse(HttpStatusCode.InternalServerError, ex.Message));
}
return(Request.CreateResponse(HttpStatusCode.OK, result));
}
public HttpResponseMessage Post(Spartan_Bitacora_SQL varSpartan_Bitacora_SQL)
{
if (ModelState.IsValid)
{
var data = "-1";
try
{
data = Convert.ToString(this.service.Insert(varSpartan_Bitacora_SQL));
}
catch (ServiceException ex)
{
return(Request.CreateResponse(HttpStatusCode.InternalServerError, ex.Message));
}
return(Request.CreateResponse(HttpStatusCode.OK, data, Configuration.Formatters.JsonFormatter));
}
else
{
var errors = ModelState.Values.SelectMany(v => v.Errors).Select(error => error.ErrorMessage);
return(Request.CreateResponse(HttpStatusCode.BadRequest, errors));
}
}
