public Task <int> ReadDataFromJson() { var assembly = typeof(DynamicScreen).GetTypeInfo().Assembly; Stream stream = assembly.GetManifestResourceStream("SampleDB.getbannerdata.json"); using (var reader = new System.IO.StreamReader(stream)) { var json = reader.ReadToEnd(); List <GetActiveCategoriesModel.RootObject> data = JsonConvert.DeserializeObject <List <GetActiveCategoriesModel.RootObject> >(json); GetActiveCategoriesModel.RootObject[] arrayobj = data.ToArray(); for (int k = 0; k < arrayobj.Length; k++) { JSSEMasterCategory mctbl = new JSSEMasterCategory(); mctbl.Category_ID = arrayobj[k].Category_ID; mctbl.Category = arrayobj[k].Category; App.Database.SaveCategoriesAsync(mctbl); for (int t = 0; t < arrayobj[k].Ratings.Count; t++) { RatingTable rtbl = new RatingTable(); rtbl.Rating_ID = arrayobj[k].Ratings[t].Rating_ID; rtbl.Rating = arrayobj[k].Ratings[t].Rating; App.Database.SaveRatingsAsync(rtbl); } GetActiveCategoriesModel.EntBehavior[] eorgdata = arrayobj[k].EntBehaviors.ToArray(); for (int l = 0; l < eorgdata.Length; l++) { JSSEMasterBehavior mbhtbl = new JSSEMasterBehavior(); mbhtbl.Behavior_ID = eorgdata[l].Behavior_ID; mbhtbl.Behavior = eorgdata[l].Behavior; mbhtbl.Category_ID = arrayobj[k].Category_ID; mbhtbl.BehaviorType_ID = eorgdata[l].BehaviorType_ID; App.Database.SaveBehaviorssAsync(mbhtbl); } for (int i = 0; i < arrayobj[k].AllOrgBehaviors.Count; i++) { for (int j = 0; j < arrayobj[k].AllOrgBehaviors[i].Count; j++) { JSSEMasterBehavior mbhtbl = new JSSEMasterBehavior(); mbhtbl.Behavior_ID = arrayobj[k].AllOrgBehaviors[i][j].Behavior_ID; mbhtbl.Behavior = arrayobj[k].AllOrgBehaviors[i][j].Behavior; mbhtbl.Category_ID = arrayobj[k].Category_ID; mbhtbl.Org_ID = arrayobj[k].AllOrgBehaviors[i][j].Org_ID; mbhtbl.BehaviorType_ID = arrayobj[k].AllOrgBehaviors[i][j].BehaviorType_ID; App.Database.SaveBehaviorssAsync(mbhtbl); } } } } return(Task.FromResult(1)); }
public Task <int> SaveCategoriesAsync(JSSEMasterCategory employee) { //if (employee.EmpId != 0) //{ // return database.UpdateAsync(employee); //} //else //{ return(database.InsertAsync(employee)); //} }
public async void DynamicCategaryDesign(List <JSSEMasterCategory> listOfCategarys) { for (int i = 0; i < listOfCategarys.Count; i++) { StackLayout mainStackLayout = new StackLayout(); mainStackLayout.Padding = new Thickness(20, 0, 20, 0); mainStackLayout.Orientation = StackOrientation.Horizontal; mainStackLayout.Spacing = 20; mainStackLayout.HorizontalOptions = LayoutOptions.FillAndExpand; mainStackLayout.VerticalOptions = LayoutOptions.Start; mainStackLayout.BindingContext = listOfCategarys[i]; mainStackLayout.BackgroundColor = Color.Beige; // mainStackLayout.Margin = new Thickness(0, 5, 0, 5); Label titleLabel = new Label(); titleLabel.Text = listOfCategarys[i].Category; titleLabel.HorizontalOptions = LayoutOptions.FillAndExpand; titleLabel.VerticalOptions = LayoutOptions.Center; titleLabel.FontSize = 14; titleLabel.TextColor = Color.Black; titleLabel.FontAttributes = FontAttributes.Bold; titleLabel.Margin = new Thickness(0, 12, 0, 12); Image arrowImage = new Image(); arrowImage.Source = "ArrowDown"; arrowImage.HorizontalOptions = LayoutOptions.End; arrowImage.VerticalOptions = LayoutOptions.Center; arrowImage.HeightRequest = 20; arrowImage.WidthRequest = 20; mainStackLayout.Children.Add(titleLabel); mainStackLayout.Children.Add(arrowImage); BoxView bottomLine = new BoxView(); bottomLine.HorizontalOptions = LayoutOptions.FillAndExpand; bottomLine.VerticalOptions = LayoutOptions.Start; bottomLine.HeightRequest = 1; bottomLine.BackgroundColor = Color.Silver; CategaryStacklayout.Children.Add(mainStackLayout); CategaryStacklayout.Children.Add(bottomLine); CategaryStacklayout.StyleId = listOfCategarys[i].Category; //CategaryStacklayout.BackgroundColor = Color.Beige; var communicationTapGestureRecognizer = new TapGestureRecognizer(); communicationTapGestureRecognizer.Tapped += (sender, e) => { StackLayout selectedLayout = sender as StackLayout; StackLayout selecteLayoutParent = selectedLayout.Parent as StackLayout; var selectedObject = selectedLayout.Children.Count; var countVal = selecteLayoutParent.Children.Count; // var obj = visibleOrInvisible.StyleId; //StackLayout selectedStackChildern = selectedLayout.Parent.FindByName<StackLayout>("isVisibleOrInVisibleRef"); //listOfObjectsPerCategary = await App.Database.GetJsseBehaviors(0, 1); for (int j = 0; j < selecteLayoutParent.Children.Count; j++) { Label selectedLabel = selectedLayout.Children[0] as Label; Image selectedImage = selectedLayout.Children[1] as Image; if (selectedLabel.Text == selecteLayoutParent.Children[j].StyleId) { if (selecteLayoutParent.Children[j].IsVisible) { selecteLayoutParent.Children[j].IsVisible = false; selectedImage.Source = "ArrowDown"; } else { selecteLayoutParent.Children[j].IsVisible = true; selectedImage.Source = "Arrowup"; } } } JSSEMasterCategory sec = selectedLayout.BindingContext as JSSEMasterCategory; }; mainStackLayout.GestureRecognizers.Add(communicationTapGestureRecognizer); communicationTapGestureRecognizer.NumberOfTapsRequired = 1; listOfEnterprisePerCategary = await App.Database.GetJsseBehaviors(0, listOfCategarys[i].Category_ID); listOfBehaviersPerCategary = await App.Database.GetJsseBehaviors(720, listOfCategarys[i].Category_ID); VisibleOrInVisibleScreenDesign(CategaryStacklayout, listOfCategarys[i].Category, listOfCategarys[i].Category_ID); } }
public Task <int> DelteEmployeeAsync(JSSEMasterCategory employee) { return(database.DeleteAsync(employee)); }