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));
}
