public ActionResult Create(FormCollection collection)
{
try
{
ITEM item = db.ITEMS.Create();
//var tempSeller = collection["sellerName"];
//Debug.WriteLine(tempSeller);
//var tempID = db.SELLERS.Where(s => s.SellerName == tempSeller).FirstOrDefault().SellerID;
//Debug.WriteLine(tempID);
item.ItemName = collection["itemName"];
item.ItemDesc = collection["itemDesc"];
//item.SellerName = collection["sellerName"];
item.SellerID = 1;
//Debug.WriteLine(tempID);
//item.SellerID = collection["sellerID"];
db.ITEMS.Add(item);
db.SaveChanges();
return(RedirectToAction("Items"));
}
catch
{
return(View());
}
}
public IActionResult Post([FromBody] Item item)
{
if (item == null)
{
return(BadRequest());
}
_context.Items.Add(item);
_context.SaveChanges();
return(Ok(item));
}
public ActionResult Create([Bind(Include = "BuyerID,Name")] Buyer buyer)
{
if (ModelState.IsValid)
{
db.Buyers.Add(buyer);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(buyer));
}
public ActionResult Create([Bind(Include = "ID,Name,ManName,Quant")] Items items)
{
if (ModelState.IsValid)
{
db.Items.Add(items);
db.SaveChanges();
return RedirectToAction("Index");
}
return View(items);
}
public IHttpActionResult CreateProizvod(Proizvod proizvod)
{
if (!ModelState.IsValid)
{
return(BadRequest());
}
_context.Items.Add(proizvod);
_context.SaveChanges();
return(Created(new Uri(Request.RequestUri + "/" + proizvod.Id), proizvod));
}
public ActionResult Create([Bind(Include = "ItemID,Name,Description,SellerID")] Item item)
{
if (ModelState.IsValid)
{
db.Items.Add(item);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.SellerID = new SelectList(db.Sellers, "SellerID", "Name", item.SellerID);
return(View(item));
}
public OrderState ChangeOrderState(Order order)
{
Order orderToChange = db.Orders.Find(order.OrderId);
orderToChange.OrderState = order.OrderState;
db.SaveChanges();
if (orderToChange.OrderState == OrderState.Executed)
{
mailService.OrderSendMessage(orderToChange);
}
return(order.OrderState);
}
public ActionResult Create([Bind(Include = "BidID,ItemID,BuyerID,Price")] Bid bid)
{
if (ModelState.IsValid)
{
db.Bids.Add(bid);
bid.TimeStamp = DateTime.Now;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.BuyerID = new SelectList(db.Buyers, "BuyerID", "Name", bid.BuyerID);
ViewBag.ItemID = new SelectList(db.Items, "ItemID", "Name", bid.ItemID);
return(View(bid));
}
private void Seed()
{
using var context = new ItemsContext(this.ContextOptions);
context.Database.EnsureDeleted();
context.Database.EnsureCreated();
var one = new Item("ItemOne");
one.AddTag("Tag11");
one.AddTag("Tag12");
one.AddTag("Tag13");
var two = new Item("ItemTwo");
var three = new Item("ItemThree");
three.AddTag("Tag31");
three.AddTag("Tag31");
three.AddTag("Tag31");
three.AddTag("Tag32");
three.AddTag("Tag32");
context.AddRange(one, two, three);
context.SaveChanges();
}
// Creates new order from basket data
public Order CreateOrder(Order newOrder, string userId)
{
var bucket = DownloadBucket();
newOrder.AdditionDate = DateTime.Now;
newOrder.UserId = userId;
db.Orders.Add(newOrder);
if (newOrder.ItemPosition == null)
{
newOrder.ItemPosition = new List <ItemPosition>();
}
decimal bucketValue = 0;
foreach (var bucketElement in bucket)
{
var newOrderPosition = new ItemPosition()
{
ItemId = bucketElement.Item.ItemId,
Quantity = bucketElement.Quantity,
OrderValue = bucketElement.Item.ItemPrice
};
bucketValue += (bucketElement.Quantity * bucketElement.Item.ItemPrice);
newOrder.ItemPosition.Add(newOrderPosition);
}
newOrder.OrderValue = bucketValue;
db.SaveChanges();
return(newOrder);
}
private void Seed()
{
using (var context = new ItemsContext(ContextOptions))
{
context.Database.EnsureDeleted();
context.Database.EnsureCreated();
context.Add(new Item {
Id = 1, Name = "El_1", Price = 5, Description = "Opis"
});
context.Add(new Item {
Id = 2, Name = "El_2", Price = 15, Description = "Opis - El_2"
});
context.Add(new Item {
Id = 3, Name = "A", Price = 35, Description = "Opis - A"
});
context.Add(new Item {
Id = 5, Name = "B", Price = 55, Description = "Opis - B"
});
context.Add(new Item {
Id = 6, Name = "C", Price = 11, Description = "Opis - C"
});
context.Add(new Item {
Id = 11, Name = "D", Price = 102, Description = "Opis - D"
});
context.Add(new Item {
Id = 12, Name = "D1", Price = 85, Description = "Opis - D1"
});
context.SaveChanges();
}
}
public IActionResult UpdateElement(Item element)
{
try
{
var updateElement = _context.Items.FirstOrDefault(x => x.Id == element.Id);
if (updateElement == null)
{
throw new Exception("Element not found.");
}
updateElement.Name = element.Name;
updateElement.Price = element.Price;
updateElement.Description = element.Description;
_context.SaveChanges();
return(Ok());
}
catch (Exception ex)
{
return(StatusCode(StatusCodes.Status500InternalServerError, ex.Message));
}
}
private void Seed()
{
using var context = new ItemsContext(this.contextOptions);
context.Database.EnsureDeleted();
context.Database.EnsureCreated();
var one = new Item {
Name = "ItemOne"
};
var two = new Item {
Name = "ItemTwo"
};
var three = new Item {
Name = "ItemThree"
};
context.AddRange(one, two, three);
context.SaveChanges();
}
public void SaveChanges()
{
if (_context != null)
{
_context.SaveChanges();
}
if (_spellsContext != null)
{
_spellsContext.SaveChanges();
}
if (_itemsContext != null)
{
_itemsContext.SaveChanges();
}
if (_playableClassContext != null)
{
_playableClassContext.SaveChanges();
}
if (_raceContext != null)
{
_raceContext.SaveChanges();
}
}
public string Get()
{
string outString = "";
string path = "https://www.avtoall.ru/catalog/paz-20/avtobusy-36/paz_672m-393/";
HtmlAgilityPack.HtmlWeb connection = new HtmlAgilityPack.HtmlWeb();
HtmlAgilityPack.HtmlDocument page = connection.Load(path);
var div = page.DocumentNode.SelectSingleNode(".//ul[@class='catalog-groups-tree']");
foreach (var list in div.SelectNodes(".//li"))
{
var Big = list.SelectSingleNode(".//a[@href='#']");
if (Big != null)
{
Tree dbTree = new Tree();
dbTree.Name = Big.InnerText;
db.Trees.Add(dbTree);
foreach (var item in list.SelectNodes(".//li"))
{
var middle = item.SelectSingleNode(".//a[@href='#']");
if (middle != null)
{
FirstSub firstSub = new FirstSub();
firstSub.Name = middle.InnerText;
firstSub.TreeId = dbTree.Id; //?
db.FirstSubs.Add(firstSub);
foreach (var smal in item.SelectNodes(".//li"))
{
var small = smal.SelectSingleNode(".//a[@data-id]");
if (small != null)
{
SecondSub secondSub = new SecondSub();
secondSub.IdFirstSub = firstSub.Id;//?
secondSub.Link = small.GetAttributeValue("href", "NULL");
secondSub.Name = small.InnerText;
db.SecondSubs.Add(secondSub);
}
}
}
}
}
db.SaveChanges();
}
foreach (var sub in db.SecondSubs.ToList())
{
var link = sub.Link;
Item item = new Item();
HtmlAgilityPack.HtmlDocument subPage = connection.Load("https://www.avtoall.ru" + link);
var number = subPage.DocumentNode.SelectSingleNode("//th[@class='number']");
if (number.InnerText != "Номер детали")
{
item.Number = number.InnerText;
}
var name = subPage.DocumentNode.SelectSingleNode(".//th[@class='name']");
if (name.InnerText != "Наименование")
{
item.Name = name.InnerText;
}
var count = subPage.DocumentNode.SelectSingleNode(".//th[@class='count']");
if (count.InnerText != "Кол-во на модель")
{
item.Count = count.InnerText;
}
var image = subPage.DocumentNode.SelectSingleNode(".//img[@id='picture_img']");
var srcImage = image.GetAttributeValue("src", "NULL");
if (srcImage.Length != 0)
{
item.ImageSrc = srcImage;
}
item.SecondSubId = sub.Id;
item.SoldOut = false;
db.Items.Add(item);
db.SaveChanges();
Item itemAbs = new Item();
var absrows = subPage.DocumentNode.SelectNodes(".//tr[@class='part']");
foreach (var row in absrows)
{
var absNumber = row.SelectSingleNode(".//td[@class='number']");
itemAbs.Number = absNumber.InnerText;
var absName = row.SelectSingleNode(".//td[@class='name']");
itemAbs.Name = absName.InnerText;
var absCount = row.SelectSingleNode(".//td[@class='count']");
itemAbs.Count = absCount.InnerText;
itemAbs.SecondSubId = sub.Id;
itemAbs.SoldOut = true;
if (itemAbs.Number != null && itemAbs.Name != null && itemAbs.Count != null)
{
db.Items.Add(itemAbs);
//db.SaveChanges();
}
}
foreach (var a in subPage.DocumentNode.SelectNodes(".//td[@colspan='4']"))
{
foreach (var c in a.SelectNodes(".//div[@class='price-list']"))
{
foreach (var i in c.SelectNodes(".//div[@class='list-compact']"))
{
foreach (var k in i.SelectNodes(".//div[@class='item item-elem']"))
{
Part part = new Part();
part.SecondSubId = sub.Id;
foreach (var z in k.SelectNodes(".//div[@class='decr']"))
{
foreach (var w in z.SelectNodes(".//strong[@class='item-name']"))
{
var t = w.SelectSingleNode(".//a");
part.FullName = t.InnerText;
}
}
foreach (var m in k.SelectNodes(".//div[@class='image']"))
{
foreach (var x in m.SelectNodes(".//a[@href]"))
{
var w = x.SelectSingleNode(".//img[@class='lazy']");
var srcThisImage = w.GetAttributeValue("src", "NULL");
part.ImageSrc = srcThisImage;
}
}
foreach (var q in k.SelectNodes(".//div[@class='right-block']"))
{
foreach (var n in q.SelectNodes(".//div[@class='price']"))
{
var o = n.SelectSingleNode(".//b[@class='price-internet']");
part.Price = o.InnerText;
}
}
}
}
}
}
}
return(outString);
}
public void SaveChanges()
{
_context.SaveChanges();
}
public IActionResult Create(Item item)
{
db.Items.Add(item);
db.SaveChanges();
return(RedirectToAction("Index"));
}