public ActionResult Save(OrderForm product)
{
using (var db = new LifeIsFeudalDb())
{
try
{
db.OrderForms.Add(product);
db.SaveChanges();
product.OrderNumber = product.Id.ToString().PadLeft(5, '0');
db.Entry(product).State = EntityState.Modified;
db.SaveChanges();
var ret = new
{
OrderNumber = product.OrderNumber,
PlayerName = product.PlayerName
};
return(Json(ret));
}
catch (Exception ie)
{
var e = ie;
return(Json(ie));
}
}
}
public ActionResult Save(ItemQuality item)
{
using (var db = new LifeIsFeudalDb())
{
if (item.Id == 0)
{
db.ItemQualities.Add(item);
}
else
{
var existing = db.ItemQualities.ToList().FirstOrDefault(x => x.Id == item.Id);
existing.BuyActive = item.BuyActive;
existing.SellActive = item.SellActive;
existing.Item_Id = item.Item_Id;
existing.ItemQualityType_Id = item.ItemQualityType_Id;
existing.Free = item.Free;
existing.OverridePrice = item.OverridePrice;
db.Entry(existing).State = System.Data.Entity.EntityState.Modified;
}
db.SaveChanges();
var ret = new
{
buy_active = item.BuyActive,
id = item.Id,
Item_id = item.Item_Id,
ItemQualityType_id = item.ItemQualityType_Id,
sell_active = item.SellActive,
created_at = item.Created,
free = item.Free,
overridePrice = item.OverridePrice
};
return(Json(ret, JsonRequestBehavior.AllowGet));
}
}
public ActionResult SaveOrderFormProduct(OrderFormProduct product)
{
using (var db = new LifeIsFeudalDb())
{
db.OrderFormProducts.Add(product);
db.SaveChanges();
return(Json(product, JsonRequestBehavior.AllowGet));
}
}
public ActionResult Save(Configuration config)
{
using (var db = new LifeIsFeudalDb())
{
db.Entry(config).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
return(Json(config));
}
}
public static void ReadFile(string filePath)
{
using (var wb = new XLWorkbook(filePath))
using (var db = new LifeIsFeudalDb())
{
var qualities = db.ItemQualityTypes.ToList();
var ws = wb.Worksheet(1);
List <Category> _categoriesReadyToSave = new List <Category>();
List <SubCategory> _subCategoriesReadyToSave = new List <SubCategory>();
List <Item> _itemsReadyToSave = new List <Item>();
Category cat = new Category();
SubCategory _sub = new SubCategory();
foreach (IXLRow row in ws.RowsUsed())
{
if (row.RowNumber() >= 5)
{
try
{
var name = row.Cell("A").Value.ToString();
var buy = row.Cell("C").Value.ToString();
var sell = row.Cell("D").Value.ToString();
var hidden = row.IsHidden;
if (name == "Builder's Corner")
{
Console.WriteLine("----=======");
}
if (row.IsHidden)
{
continue;
}
if (string.IsNullOrEmpty(buy) && string.IsNullOrEmpty(sell) && name != "Hand and a Half Swords")
{
if (!string.IsNullOrEmpty(name))
{
_sub = db.SubCategories.ToList().FirstOrDefault(x => x.Name == "General Goods");
//Leave and continue
cat = new Category
{
Name = name,
Created = DateTime.Now
};
_categoriesReadyToSave.Add(cat);
Console.WriteLine($"Category: {name}");
}
}
else
{
if (string.IsNullOrEmpty(sell))
{
_sub = new SubCategory
{
Name = name
};
_subCategoriesReadyToSave.Add(_sub);
Console.WriteLine($"SubCategory: {name}");
}
else
{
var setFree = false;
if (sell.Equals("Free"))
{
setFree = true;
sell = "0";
}
Item _item = new Item
{
Name = name,
Category = cat,
SubCategory = _sub,
Price = Convert.ToInt32(StripCharacters(sell)),
Created = DateTime.Now
};
foreach (var quality in qualities)
{
_item.Qualities.Add(new ItemQuality
{
Item = _item,
Free = setFree,
BuyActive = true,
SellActive = true,
ItemQualityType = quality,
ItemQualityType_Id = quality.Id,
Created = DateTime.Now
});
}
_itemsReadyToSave.Add(_item);
Console.WriteLine($"Item: {name}");
}
}
}
catch (Exception e)
{
if (e.Message.Contains("base materials"))
{
continue;
}
Console.WriteLine(e);
}
}
}
db.Categories.AddRange(_categoriesReadyToSave);
db.SubCategories.AddRange(_subCategoriesReadyToSave);
db.Items.AddRange(_itemsReadyToSave);
db.SaveChanges();
}
}
