public async Task <RecetaFavorita> Alta(RecetaFavorita obj) { Token token = App.TokenDatabase.Obtener(); string Url = Web; using (HttpClient client = new HttpClient()) using (HttpRequestMessage request = new HttpRequestMessage(HttpMethod.Post, Url)) { client.DefaultRequestHeaders.Add("Authorization", "Bearer " + token._AccessToken); string json = JsonConvert.SerializeObject(obj); using (StringContent stringContent = new StringContent(json, Encoding.UTF8, "application/json")) { request.Content = stringContent; using (HttpResponseMessage response = await client .SendAsync(request, HttpCompletionOption.ResponseHeadersRead) .ConfigureAwait(false)) { string JsonResult = response.Content.ReadAsStringAsync().Result; try { RecetaFavorita ContentResp = Deseralizar(JsonResult); return(ContentResp); } catch (Exception) { return(null); } } } } }
public int CrearRecetaFavorita(RecetaFavorita recetaFavoritaNuevo) { try { Conexion con = new Conexion(); string query = "INSERT INTO HJA.FAVRECETA(ID,ENCARGADO_ID, PAM_ID, FECHA) VALUES(" + recetaFavoritaNuevo.id + recetaFavoritaNuevo.encargado_id + "," + recetaFavoritaNuevo.pam_id + ",'" + recetaFavoritaNuevo.fecha + "');"; NpgsqlCommand command = new NpgsqlCommand(query, con.ConexionProceso()); command.ExecuteNonQuery(); } catch (Exception) { return(2); } return(0); }
public RecetaFavorita TraerRecetaFavoritaPorId(int idReceta) { Conexion con = new Conexion(); string query = "SELECT ID,ENCARGADO_ID,PAM_ID,FECHA FROM HJA.FAVRECETA WHERE ID = ;"; DataTable dt = con.conexion(query).Tables[0]; List <RecetaFavorita> listas = (from DataRow row in dt.Rows select new RecetaFavorita() { id = Convert.ToInt32(row["id"].ToString()), encargado_id = Convert.ToInt32(row["encargado_id"].ToString()), pam_id = Convert.ToInt32(row["pam_id"].ToString()), fecha = Convert.ToDateTime(row["fecha"].ToString()) }).ToList(); RecetaFavorita recetaFavorita = listas[0]; return(recetaFavorita); }
private async void BtnAgregarFavoritos_Clicked(object sender, EventArgs e) { RecetaFavorita rf = new RecetaFavorita { _Email = Email, _IdReceta = Receta._IdReceta, _FechaHora = DateTime.Now }; var favorito = await App.RecetaFavoritaService.Alta(rf); if (favorito != null) { //this.BT BtnAgregarFavoritos.IsEnabled = false; //this.BtnAgregarFavoritos.Image = "favorite.png"; //this.BtnAgregarFavoritos.Text = ""; //this.BtnAgregarFavoritos.BorderColor = Color.Transparent; //this.btnAgregarFavoritos.BackgroundColor = Color.Transparent; } }
public async Task <string> Eliminar(RecetaFavorita obj) { Token token = App.TokenDatabase.Obtener(); string Url = Web + obj._Email + "," + obj._IdReceta; HttpClient client = new HttpClient(); client.DefaultRequestHeaders.Add("Authorization", "Bearer " + token._AccessToken); using (HttpResponseMessage response = await client.DeleteAsync(Url)) { string JsonResult = response.Content.ReadAsStringAsync().Result; try { return(JsonResult); } catch { return(null); } } }
public async Task <List <RecetaFavorita> > ObtenerList(RecetaFavorita obj) { Token token = App.TokenDatabase.Obtener(); string Url = Web + obj._Email; HttpClient client = new HttpClient(); client.DefaultRequestHeaders.Add("Authorization", "Bearer " + token._AccessToken); using (HttpResponseMessage response = await client.GetAsync(Url)) { string JsonResult = response.Content.ReadAsStringAsync().Result; try { List <RecetaFavorita> ContentResp = DeseralizarList(JsonResult); return(ContentResp); } catch (Exception) { return(null); } } }
private RecetaFavorita Deseralizar(string jsonResult) { RecetaFavorita p = JsonConvert.DeserializeObject <RecetaFavorita>(jsonResult); return(p); }