public void FillList() { using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["con"].ToString())) { SqlCommand query = new SqlCommand(@"exec Get_AllRecepts", conn); conn.Open(); SqlDataAdapter sqlDataAdapter = new SqlDataAdapter(query); DataTable dataTable = new DataTable(); sqlDataAdapter.Fill(dataTable); if (Recepies == null) { Recepies = new ObservableCollection <Recept>(); } foreach (DataRow row in dataTable.Rows) { Recept r = new Recept { ReceptId = int.Parse(row[0].ToString()), UserId = int.Parse(row[1].ToString()), TypeId = int.Parse(row[2].ToString()), ReceptName = row[3].ToString(), PersonNumber = int.Parse(row[4].ToString()), Author = row[5].ToString(), ReceptText = row[6].ToString(), CreationDate = DateTime.Parse(row[7].ToString()), ReceptType = row[9].ToString(), }; if (LoginWindow.CurrentUser.UserId == r.UserId) { r.CanEdit = true; } if (LoginWindow.CurrentUser.Username == "Admin") { r.CanEdit = true; r.CanDelete = true; } using (SqlConnection conn1 = new SqlConnection(ConfigurationManager.ConnectionStrings["con"].ToString())) { SqlCommand query1 = new SqlCommand(@"exec Get_AllReceptsComponentsNumber @ReceptID = @Id;", conn1); query1.Parameters.AddWithValue("@Id", r.ReceptId); conn1.Open(); SqlDataAdapter sqlDataAdapter1 = new SqlDataAdapter(query1); DataTable dataTable1 = new DataTable(); sqlDataAdapter1.Fill(dataTable1); foreach (DataRow row1 in dataTable1.Rows) { r.ComponentsNumber = int.Parse(row1[0].ToString()); } } Recepies.Add(r); } } }
public RecepiesDetail(int recepieId) { InitializeComponent(); IngredientsColection = new ObservableCollection <Ingredient>(); PreparationStepsColection = new ObservableCollection <PreparationStep>(); Recepieses = new Recepies(); GetRecepieDetail(recepieId); }
public EditRecepiePage(int recepieId) { InitializeComponent(); Iingredients = new List <Ingredient>(); PreparationSteps = new List <PreparationStep>(); Recepieses = new Recepies(); GetRecepieDetail(recepieId); }
public PRDChemProdReq GetRequisitionDetailsAfterSearch(int _RequisitionID) { var model = new PRDChemProdReq(); var RequisitionInfo = (from r in _context.PRD_ChemProdReq.AsEnumerable() where r.RequisitionID == _RequisitionID join re in _context.PRD_Recipe on(r == null?null:r.RecipeID) equals re.RecipeID into Recepies from re in Recepies.DefaultIfEmpty() join c in _context.Sys_Color on(re == null? null: re.ArticleColor) equals c.ColorID into Colors from c in Colors.DefaultIfEmpty() join u in _context.Sys_Unit on(re == null ? 0 : re.BaseUnit) equals u.UnitID into Units from u in Units.DefaultIfEmpty() select new PRDChemProdReq { RequisitionID = r.RequisitionID, RequisitionNo = r.RequisitionNo, RequisitionCategory = r.RequisitionCategory, RequisitionType = r.RequisitionType, ReqRaisedOn = (Convert.ToDateTime(r.ReqRaisedOn)).ToString("dd'/'MM'/'yyyy"), RequiredByTime = (r.RequiredByTime == 0? null: r.RequiredByTime), ReqRaisedBy = (r.ReqRaisedBy), RequisitionFrom = r.RequisitionFrom, RequisitionTo = r.RequisitionTo, RecipeFor = (r.RecipeFor), RecipeID = (r.RecipeID), ArticleNo = r.ArticleNo, ArticleName = (re == null? null: re.ArticleName), ArticleChallanNo = (re == null ? null : re.ArticleChallanNo), ArticleColor = (re == null ? null : re.ArticleColor), ArticleColorName = (c == null ? null : c.ColorName), BaseQuantity = (re == null ? null : (re.BaseQuantity).ToString()), //BaseUnit = (re == null ? null : re.BaseUnit), BaseUnitName = (u == null ? null : u.UnitName), LeatherSize = r.LeatherSize, SizeUnit = (r.SizeUnit), Selection = r.Selection, Thickness = r.Thickness, ThicknessUnit = (r.ThicknessUnit), ProductionQty = (r.ProductionQty == 0 ? null : r.ProductionQty), ProductionQuantityUnit = (u == null ? null : u.UnitName), RecordStatus = r.RecordStatus }).FirstOrDefault(); model.RequisitionInfo = RequisitionInfo; model.RequisitionItemList = GetRequisitionItemList(_RequisitionID, RequisitionInfo.RequisitionTo); return(model); }
public void DeleteRecepie() { using (var conn = new SqlConnection(ConfigurationManager.ConnectionStrings["con"].ToString())) { var cmd = new SqlCommand(@"Delete from tblComponents where ReceptID=@RecepieID; Delete from tblRecept where ReceptID=@RecepieID;", conn); cmd.Parameters.AddWithValue("@RecepieID", recepie.ReceptId); conn.Open(); cmd.ExecuteNonQuery(); conn.Close(); MessageBoxResult messageBoxResult = System.Windows.MessageBox.Show("Recepie successfully deleted.", "Notification"); Recepies.Remove(recepie); } }
public RecepiesRepo() { List <string> steps = new List <string> { "step 1", "step 2", "step 3" }; TimeSpan span1 = TimeSpan.FromMinutes(40); TimeSpan span2 = TimeSpan.FromMinutes(30); TimeSpan span3 = TimeSpan.FromMinutes(15); Recepies test1 = new Recepies("Kødsovs", steps, span1); Recepies test2 = new Recepies("test1", steps, span2); Recepies test3 = new Recepies("test3", steps, span3); recepies.Add(test1); recepies.Add(test2); recepies.Add(test3); }
private async void BtEDITRecepie_OnClicked(object sender, EventArgs e) { try { Recepies recepies = new Recepies(); recepies.id = this.Recepieses.id; recepies.title = this.EntryTitle.Text; recepies.description = this.EntryDescription.Text; recepies.preparationTime = Int32.Parse(this.EntryPreparationTime.Text); recepies.cookingTime = Int32.Parse(this.EntryCookingTime.Text); recepies.people = Int32.Parse(this.EntryPeople.Text); recepies.difficulty = this.EntryDifficulty.Text; recepies.category = this.EntryCategory.Text; recepies.UserId = Preferences.Get("userId", 0); recepies.ingredients = this.Iingredients; recepies.preparationSteps = this.PreparationSteps; var responce = await ApiService.EditRecepie(recepies.id, recepies); if (file != null) { responce = await ApiService.EditRecepieIMG(recepies.id, recepies.title, this.file); } if (responce) { await DisplayAlert("Sukces!", "Pomyślnie dokonano edycji przepisu", "OK"); Navigation.PopModalAsync(); } else { await DisplayAlert("Ooops", "Coś poszło nie tak", "Zamknij"); } } catch (Exception exception) { await DisplayAlert("Ooops", "Coś poszło nie tak", "Zamknij"); } }
private async void BtAddRecepie_OnClicked(object sender, EventArgs e) { try { Recepies recepies = new Recepies(); //var ImageArray = FromFile.ToArray(file.GetStream()); recepies.title = this.EntryTitle.Text; recepies.description = this.EntryDescription.Text; recepies.preparationTime = Int32.Parse(this.EntryPreparationTime.Text); recepies.cookingTime = Int32.Parse(this.EntryCookingTime.Text); recepies.people = Int32.Parse(this.EntryPeople.Text); recepies.difficulty = this.EntryDifficulty.Text; recepies.category = this.EntryCategory.Text; recepies.UserId = Preferences.Get("userId", 0); recepies.ingredients = this.Iingredients; recepies.preparationSteps = this.PreparationSteps; await ApiService.AddRecepie(recepies); var responce = await ApiService.AddRecepieIMG(recepies.title, this.file); if (responce) { await DisplayAlert("Sukces!", "Pomyślnie dodano nowy przepis", "OK"); Application.Current.MainPage = new NavigationPage(new AppMainPage()); } else { await DisplayAlert("Ooops", "Coś poszło nie tak", "Zamknij"); } } catch (Exception exception) { await DisplayAlert("Ooops", "Coś poszło nie tak", "Zamknij"); } }
private async void GetRecepieDetail(int recepieId) { var recepie = await ApiService.GetRecepieDetail(recepieId); Recepieses = (Recepies)recepie.First(); this.EntryTitle.Text = Recepieses.title; this.EntryDescription.Text = Recepieses.description; this.EntryPreparationTime.Text = Recepieses.preparationTime.ToString(); this.EntryCookingTime.Text = Recepieses.cookingTime.ToString(); this.EntryPeople.Text = Recepieses.people.ToString(); this.EntryDifficulty.Text = Recepieses.difficulty; this.EntryCategory.Text = Recepieses.category; this.Iingredients = Recepieses.ingredients; this.CvIngredients.ItemsSource = Iingredients; this.PreparationSteps = Recepieses.preparationSteps; this.CvPreparationStep.ItemsSource = PreparationSteps; this.ImgAddFromFile.Source = Recepieses.FullImage; this.ImgAddFromFile.HeightRequest = 350; }
private async void GetRecepieDetail(int movieId) { var recepie = await ApiService.GetRecepieDetail(movieId); Recepieses = (Recepies)recepie.First(); this.ImgMovie.Source = Recepieses.FullImage; this.LblCategory.Text = Recepieses.category; this.LblPeople.Text = Recepieses.people.ToString(); this.LblTitle.Text = Recepieses.title; this.LblDifficulty.Text = Recepieses.difficulty; this.LblPeople.Text = $"Dla {Recepieses.people.ToString()} osób"; this.LblPreparationTime.Text = $"Czas przygotowania: {Recepieses.preparationTime.ToString()} min"; this.LblDescription.Text = Recepieses.description; var test = recepie.SelectMany(x => x.ingredients).ToList(); foreach (var lala in test) { IngredientsColection.Add(lala); } CvIngredients.ItemsSource = IngredientsColection; var test2 = recepie.SelectMany(x => x.preparationSteps).ToList(); foreach (var lala in test2) { PreparationStepsColection.Add(lala); } LvPreparationStep.ItemsSource = PreparationStepsColection; }
public static async Task <bool> EditRecepie(int id, Recepies recepies) { await TokenValidator.Check(); var httpClient = new HttpClient(); var json = JsonConvert.SerializeObject(recepies); var content = new StringContent(json, Encoding.UTF8, "application/json"); httpClient.DefaultRequestHeaders.Authorization = new AuthenticationHeaderValue("bearer", Preferences.Get("accessToken", string.Empty)); var response = await httpClient.PutAsync(AppSettings.ApiUrl + $"Recipes/EditRecepie/{id}", content); if (!response.IsSuccessStatusCode) { return(false); } else { return(true); } }
public void SearchByRecepieComponent() { string[] words = components.Split(' '); Recepies.Clear(); UserHaveComponents.Clear(); MissingComponents.Clear(); foreach (string s in words) { if (s == "") { continue; } using (SqlConnection conn1 = new SqlConnection(ConfigurationManager.ConnectionStrings["con"].ToString())) { SqlCommand query1 = new SqlCommand(@"exec Get_AllComponentsByInput @ComponentName;", conn1); query1.Parameters.AddWithValue("@ComponentName", s); conn1.Open(); SqlDataAdapter sqlDataAdapter1 = new SqlDataAdapter(query1); DataTable dataTable1 = new DataTable(); sqlDataAdapter1.Fill(dataTable1); foreach (DataRow row1 in dataTable1.Rows) { Components c = new Components { ComponentId = int.Parse(row1[0].ToString()), ReceptId = int.Parse(row1[1].ToString()), ComponentName = row1[2].ToString(), ComponentAmount = int.Parse(row1[3].ToString()) }; bool contains = false; foreach (Components item in UserHaveComponents) { if (item.ComponentName == c.ComponentName) { contains = true; break; } } if (!contains) { UserHaveComponents.Add(c); } } conn1.Close(); } using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["con"].ToString())) { SqlCommand query = new SqlCommand(@"exec Get_AllReceptsByComponents @Components", conn); query.Parameters.AddWithValue("@Components", s); conn.Open(); SqlDataAdapter sqlDataAdapter = new SqlDataAdapter(query); DataTable dataTable = new DataTable(); sqlDataAdapter.Fill(dataTable); foreach (DataRow row in dataTable.Rows) { Recept r = new Recept { ReceptId = int.Parse(row[0].ToString()), UserId = int.Parse(row[1].ToString()), TypeId = int.Parse(row[2].ToString()), ReceptName = row[3].ToString(), PersonNumber = int.Parse(row[4].ToString()), Author = row[5].ToString(), ReceptText = row[6].ToString(), CreationDate = DateTime.Parse(row[7].ToString()), ReceptType = row[9].ToString(), }; if (LoginWindow.CurrentUser.UserId == r.UserId) { r.CanEdit = true; } if (LoginWindow.CurrentUser.Username == "Admin") { r.CanEdit = true; r.CanDelete = true; } using (SqlConnection conn1 = new SqlConnection(ConfigurationManager.ConnectionStrings["con"].ToString())) { SqlCommand query1 = new SqlCommand(@"exec Get_AllReceptsComponentsNumber @ReceptID = @Id;", conn1); query1.Parameters.AddWithValue("@Id", r.ReceptId); conn1.Open(); SqlDataAdapter sqlDataAdapter1 = new SqlDataAdapter(query1); DataTable dataTable1 = new DataTable(); sqlDataAdapter1.Fill(dataTable1); foreach (DataRow row1 in dataTable1.Rows) { r.ComponentsNumber = int.Parse(row1[0].ToString()); } } List <int> ids = new List <int>(); foreach (Recept i in Recepies) { ids.Add(i.ReceptId); } if (!ids.Contains(r.ReceptId)) { Recepies.Add(r); } } conn.Close(); } } }