public async Task LoadDescriptionsAsync()
{
var picker = new Windows.Storage.Pickers.FileOpenPicker();
picker.ViewMode = Windows.Storage.Pickers.PickerViewMode.Thumbnail;
picker.SuggestedStartLocation = Windows.Storage.Pickers.PickerLocationId.DocumentsLibrary;
picker.FileTypeFilter.Add(".txt");
StorageFile file = await picker.PickSingleFileAsync();
var stream = await file.OpenAsync(Windows.Storage.FileAccessMode.Read);
using (StreamReader sr = new StreamReader(stream.AsStreamForRead()))
{
while (!sr.EndOfStream)
{
string line = sr.ReadLine();
if (line[0] == '0')
{
var val = line.Split('\t');
if (val[4] == "1")
{
int id = Int32.Parse(val[1]);
BdoItem item = BdoDataService.GetItemById(id);
if (item != null)
{
string description = val[5].Trim('\"');
item.Description = description;
BdoDataService.UpdateItem(item);
BdoDataService.Commit();
}
}
}
else if (line.StartsWith("34"))
{
var val = line.Split('\t');
if (val[4] == "1")
{
BdoItem item = BdoDataService.GetItemsByKnowledge($"theme--{val[1]}")?.FirstOrDefault();
if (item != null)
{
string knowledge = val[5].Trim('\"');
item.Knowledge = knowledge;
BdoDataService.UpdateItem(item);
BdoDataService.Commit();
}
}
}
}
}
await LoadDataAsync();
}
public static BdoItem UpdateItem(BdoItem updatedItem)
{
var entity = db.Items.Attach(updatedItem);
entity.State = EntityState.Modified;
return(updatedItem);
}
public static BdoItem FirstItemFromItemGroup(int itemGroupId)
{
BdoItem query = (from ig in db.Items
where ig.ItemGroupId == itemGroupId
select ig).First();
return(query);
}
public static BdoItem DeleteItem(int id)
{
BdoItem item = GetItemById(id);
if (item != null)
{
db.Items.Remove(item);
}
return(item);
}
private void LoadMaterials()
{
Materials.Clear();
Results.Clear();
var materials = BdoDataService.GetRecipeMatsByRecipeID(SelectedRecipe.Id);
foreach (var material in materials)
{
if (material.IsItem)
{
material.Item = BdoDataService.GetItemById(material.ItemId.Value);
Materials.Add(new RecipeMaterialModel
{
Name = material.Item.Name,
Img = material.Item.Img,
Grade = material.Item.Grade,
IsItem = true,
Id = material.Item.Id,
Amount = material.Amount
});
}
else
{
//Item Group
material.ItemGroup = BdoDataService.GetItemGroupById(material.ItemGroupId.Value);
BdoItem item = BdoDataService.FirstItemFromItemGroup(material.ItemGroupId.Value);
Materials.Add(new RecipeMaterialModel
{
Name = material.ItemGroup.Name,
Img = material.ItemGroup.Items[0].Img,
Grade = ItemGrade.White,
IsItem = false,
Id = material.ItemGroup.Id,
Amount = material.Amount
});
}
}
BdoItem result0 = BdoDataService.GetItemById(SelectedRecipe.Item1Id.Value);
Results.Add(result0);
if (SelectedRecipe.Item2Id.HasValue)
{
BdoItem result1 = BdoDataService.GetItemById(SelectedRecipe.Item2Id.Value);
Results.Add(result1);
}
NotifyOfPropertyChange(() => Materials);
NotifyOfPropertyChange(() => Results);
}
public async Task LoadItemsAsync()
{
var picker = new Windows.Storage.Pickers.FileOpenPicker();
picker.ViewMode = Windows.Storage.Pickers.PickerViewMode.Thumbnail;
picker.SuggestedStartLocation = Windows.Storage.Pickers.PickerLocationId.DocumentsLibrary;
picker.FileTypeFilter.Add(".json");
StorageFile file = await picker.PickSingleFileAsync();
string jsonText = await FileIO.ReadTextAsync(file);
List <BdoItem> items = await Json.ToObjectAsync <List <BdoItem> >(jsonText);
foreach (var item in items)
{
BdoItem bdoItem = BdoDataService.GetItemById(item.Id);
if (bdoItem == null)
{
BdoDataService.AddItem(item);
}
else
{
bdoItem.Name = item.Name;
bdoItem.Grade = item.Grade;
bdoItem.Img = item.Img;
bdoItem.Description = item.Description;
bdoItem.Category = item.Category;
bdoItem.Weight = item.Weight;
bdoItem.ItemGroupId = item.ItemGroupId;
bdoItem.BuyPrice = item.BuyPrice;
bdoItem.SellPrice = item.SellPrice;
bdoItem.Knowledge = item.Knowledge;
BdoDataService.UpdateItem(bdoItem);
}
BdoDataService.Commit();
}
await LoadDataAsync();
}
public static BdoItem AddItem(BdoItem item)
{
db.Add(item);
return(item);
}
