context: using System.Collections.Generic;
  using System.Net;
  using System.Net.Http;
  using System.Web.Http;
  using MixERP.Net.ApplicationState.Cache;
  using MixERP.Net.Common.Extensions;
  using MixERP.Net.EntityParser;
  using Newtonsoft.Json;
  using PetaPoco;
  
  namespace MixERP.Net.Api.Localization
  {
      /// <summary>
      ///     Provides a direct HTTP access to perform various tasks such as adding, editing, and removing Cultures.
      /// </summary>
      [RoutePrefix("api/v1.5/localization/culture")]
      public class CultureController : ApiController
      {
          /// <summary>
          ///     The Culture data context.
          /// </summary>
          private readonly MixERP.Net.Schemas.Localization.Data.Culture CultureContext;
  
          public CultureController()
          {
              this.LoginId = AppUsers.GetCurrent().View.LoginId.ToLong();
              this.UserId = AppUsers.GetCurrent().View.UserId.ToInt();
              this.OfficeId = AppUsers.GetCurrent().View.OfficeId.ToInt();
              this.Catalog = AppUsers.GetCurrentUserDB();
  
              this.CultureContext = new MixERP.Net.Schemas.Localization.Data.Culture
              {
                  Catalog = this.Catalog,
                  LoginId = this.LoginId
              };
          }
  
          public long LoginId { get; }
          public int UserId { get; private set; }
          public int OfficeId { get; private set; }
          public string Catalog { get; }
  
          /// <summary>
          ///     Counts the number of cultures.
          /// </summary>
          /// <returns>Returns the count of the cultures.</returns>
          [AcceptVerbs("GET", "HEAD")]
          [Route("count")]
          [Route("~/api/localization/culture/count")]
          public long Count()
          {
              try
              {
                  return this.CultureContext.Count();
              }
              catch (UnauthorizedException)
              {
                  throw new HttpResponseException(new HttpResponseMessage(HttpStatusCode.Unauthorized));
              }
              catch
              {
                  throw new HttpResponseException(new HttpResponseMessage(HttpStatusCode.InternalServerError));
              }
          }
  
          /// <summary>
          ///     Returns an instance of culture.
          /// </summary>
          /// <param name="cultureCode">Enter CultureCode to search for.</param>
          /// <returns></returns>
          [AcceptVerbs("GET", "HEAD")]
          [Route("{cultureCode}")]
          [Route("~/api/localization/culture/{cultureCode}")]
          public MixERP.Net.Entities.Localization.Culture Get(string cultureCode)
          {
              try
              {
                  return this.CultureContext.Get(cultureCode);
              }
              catch (UnauthorizedException)
              {
                  throw new HttpResponseException(new HttpResponseMessage(HttpStatusCode.Unauthorized));
              }
              catch
              {
                  throw new HttpResponseException(new HttpResponseMessage(HttpStatusCode.InternalServerError));
              }
          }
  
          /// <summary>
          ///     Creates a paginated collection containing 25 cultures on each page, sorted by the property CultureCode.
          /// </summary>
          /// <returns>Returns the first page from the collection.</returns>
          [AcceptVerbs("GET", "HEAD")]
          [Route("")]
          [Route("~/api/localization/culture")]
          public IEnumerable<MixERP.Net.Entities.Localization.Culture> GetPagedResult()
          {
              try
              {
                  return this.CultureContext.GetPagedResult();
              }
              catch (UnauthorizedException)
              {
                  throw new HttpResponseException(new HttpResponseMessage(HttpStatusCode.Unauthorized));
              }
              catch
              {
                  throw new HttpResponseException(new HttpResponseMessage(HttpStatusCode.InternalServerError));
              }
          }
  
          /// <summary>
          ///     Creates a paginated collection containing 25 cultures on each page, sorted by the property CultureCode.
          /// </summary>
          /// <param name="pageNumber">Enter the page number to produce the resultset.</param>
          /// <returns>Returns the requested page from the collection.</returns>
          [AcceptVerbs("GET", "HEAD")]
          [Route("page/{pageNumber}")]
          [Route("~/api/localization/culture/page/{pageNumber}")]
          public IEnumerable<MixERP.Net.Entities.Localization.Culture> GetPagedResult(long pageNumber)
          {
              try
              {
                  return this.CultureContext.GetPagedResult(pageNumber);
              }
              catch (UnauthorizedException)
              {
                  throw new HttpResponseException(new HttpResponseMessage(HttpStatusCode.Unauthorized));
              }
              catch
              {
                  throw new HttpResponseException(new HttpResponseMessage(HttpStatusCode.InternalServerError));
              }
          }
  
          /// <summary>
          ///     Creates a filtered and paginated collection containing 25 cultures on each page, sorted by the property CultureCode.
          /// </summary>
          /// <param name="pageNumber">Enter the page number to produce the resultset.</param>
          /// <param name="filters">The list of filter conditions.</param>
          /// <returns>Returns the requested page from the collection using the supplied filters.</returns>
          [AcceptVerbs("POST")]
          [Route("get-where/{pageNumber}")]
          [Route("~/api/localization/culture/get-where/{pageNumber}")]
          public IEnumerable<MixERP.Net.Entities.Localization.Culture> GetWhere(long pageNumber, [FromBody]dynamic filters)
          {
              try
              {
                  List<EntityParser.Filter> f = JsonConvert.DeserializeObject<List<EntityParser.Filter>>(filters);
                  return this.CultureContext.GetWhere(pageNumber, f);
              }
              catch (UnauthorizedException)
              {
                  throw new HttpResponseException(new HttpResponseMessage(HttpStatusCode.Unauthorized));
              }
              catch
              {
                  throw new HttpResponseException(new HttpResponseMessage(HttpStatusCode.InternalServerError));
              }
          }
  
          /// <summary>
          ///     Displayfields is a lightweight key/value collection of cultures.
          /// </summary>
          /// <returns>Returns an enumerable key/value collection of cultures.</returns>
          [AcceptVerbs("GET", "HEAD")]
          [Route("display-fields")]
          [Route("~/api/localization/culture/display-fields")]
          public IEnumerable<DisplayField> GetDisplayFields()
          {
              try
              {
                  return this.CultureContext.GetDisplayFields();
              }
              catch (UnauthorizedException)
              {
                  throw new HttpResponseException(new HttpResponseMessage(HttpStatusCode.Unauthorized));
              }
              catch
              {
                  throw new HttpResponseException(new HttpResponseMessage(HttpStatusCode.InternalServerError));
              }
          }
  
          /// <summary>
          ///     Adds your instance of Account class.
          /// </summary>
          /// <param name="culture">Your instance of cultures class to add.</param>
          [AcceptVerbs("POST")]
          [Route("add/{culture}")]
          [Route("~/api/localization/culture/add/{culture}")]
          public void Add(MixERP.Net.Entities.Localization.Culture culture)
          {
              if (culture == null)
              {
                  throw new HttpResponseException(new HttpResponseMessage(HttpStatusCode.MethodNotAllowed));
              }
  
              try
              {
                  this.CultureContext.Add(culture);
              }
              catch (UnauthorizedException)
              {
                  throw new HttpResponseException(new HttpResponseMessage(HttpStatusCode.Unauthorized));
              }
              catch
              {
                  throw new HttpResponseException(new HttpResponseMessage(HttpStatusCode.InternalServerError));
              }
          }
  
          /// <summary>
          ///     Edits existing record with your instance of Account class.
          /// </summary>
          /// <param name="culture">Your instance of Account class to edit.</param>
          /// <param name="cultureCode">Enter the value for CultureCode in order to find and edit the existing record.</param>
          [AcceptVerbs("PUT")]
          [Route("edit/{cultureCode}/{culture}")]
          [Route("~/api/localization/culture/edit/{cultureCode}/{culture}")]
          public void Edit(string cultureCode, MixERP.Net.Entities.Localization.Culture culture)
          {
  
gt:             if (culture == null)