public CustomShareText Edit(CustomShareText shareText) { try { connection.Open(); var cmd = connection.CreateCommand() as SqlCommand; cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "CustomShareText_Edit"; cmd.Parameters.Add(new SqlParameter("@RegionId", shareText.RegionId)); cmd.Parameters.Add(new SqlParameter("@Language", shareText.Language)); cmd.Parameters.Add(new SqlParameter("@ShareOk", shareText.ShareOk)); cmd.Parameters.Add(new SqlParameter("@ShareAlert", shareText.ShareAlert)); cmd.Parameters.Add(new SqlParameter("@ShareAlertFinca", shareText.ShareAlertFinca)); cmd.Parameters.Add(new SqlParameter("@HashTagRegister", shareText.HashTagRegister)); cmd.Parameters.Add(new SqlParameter("@HashTagReportConfirmed", shareText.HashTagReportConfirmed)); cmd.Parameters.Add(new SqlParameter("@HashTagRanking", shareText.HashTagRanking)); cmd.Parameters.Add(new SqlParameter("@HashTagTop1", shareText.HashTagTop1)); cmd.Parameters.Add(new SqlParameter("@HashTagCheck", shareText.HashTagCheck)); cmd.Parameters.Add(new SqlParameter("@HashTagVerification", shareText.HashTagVerification)); cmd.Parameters.Add(new SqlParameter("@HashTagDenounce", shareText.HashTagDenounce)); cmd.Parameters.Add(new SqlParameter("@HashTagContestWon", shareText.HashTagContestWon)); cmd.Parameters.Add(new SqlParameter("@Id", shareText.Id)); cmd.ExecuteNonQuery(); connection.Close(); return null; } catch (Exception ex) { throw ex; } }
public HttpResponseMessage<CustomShareText> Edit(CustomShareText shareText, HttpRequestMessage<CustomShareText> request) { if (shareText != null) { var shareTextDb = customShareTextRepository.Edit(shareText); return new HttpResponseMessage<CustomShareText>(shareTextDb) { StatusCode = HttpStatusCode.Created }; } return new HttpResponseMessage<CustomShareText>(null) { StatusCode = HttpStatusCode.NotFound, }; }
public void GetByRegionIdAndLanguage(int regionId, string language) { client.Authenticator = new HttpBasicAuthenticator(Current.Instance.Username, Current.Instance.Password); var request = new RestRequest("customsharetext/getbyregionidandlanguage", Method.POST) { RequestFormat = DataFormat.Json }; request.JsonSerializer = new JsonSerializer(); var shareText = new CustomShareText(); shareText.RegionId= regionId; shareText.Language = language; request.AddBody(shareText); client.ExecuteAsync<CustomShareText>(request, response => Deployment.Current.Dispatcher.BeginInvoke(() => TextsReceived(response.Data, null) )); }
public HttpResponseMessage<CustomShareText> GetByRegionIdAndLanguage(CustomShareText shareText, HttpRequestMessage<CustomShareText> request) { try { return new HttpResponseMessage<CustomShareText>(customShareTextRepository.GetByRegionIdAndLanguage(shareText.RegionId, shareText.Language)) { StatusCode = HttpStatusCode.OK }; } catch { return new HttpResponseMessage<CustomShareText>(null) { StatusCode = HttpStatusCode.BadRequest }; } }
public HttpResponseMessage<CustomShareText> Post(CustomShareText shareText, HttpRequestMessage<CustomShareText> request) { if (shareText != null) { var shareTextDB = customShareTextRepository.Insert(shareText); var response = new HttpResponseMessage<CustomShareText>(shareTextDB) { StatusCode = HttpStatusCode.Created }; return response; } return new HttpResponseMessage<CustomShareText>(null) { StatusCode = HttpStatusCode.NotFound, }; }