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