public ActionResult DeleteConfirmed(int id)
{
Retainer retainer = db.Retainers.Find(id);
db.Retainers.Remove(retainer);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public void InsertRetainer(IdNameViewModel ovm)
{
Retainer newRecord = new Retainer {
RET_Id = ovm.Id, RET_Name = ovm.Name
};
context.Retainers.Add(newRecord);
context.SaveChanges();
}
public void UpdateRetainer(IdNameViewModel ovm)
{
Retainer newRecord = new Retainer {
RET_Id = ovm.Id, RET_Name = ovm.Name
};
context.Retainers.Attach(newRecord);
context.Entry(newRecord).State = EntityState.Modified;
context.SaveChanges();
}
public void DeleteRetainer(IdNameViewModel ovm)
{
Retainer newRecord = new Retainer {
RET_Id = ovm.Id, RET_Name = ovm.Name
};
context.Retainers.Attach(newRecord);
context.Retainers.Remove(newRecord);
context.SaveChanges();
}
public IActionResult New(Retainer retainer)
{
if (!ModelState.IsValid)
{
return(View(retainer));
}
_retainersRepo.Save(retainer);
TempData["added"] = true;
return(RedirectToAction(nameof(New)));
}
public IActionResult Edit(Retainer retainer)
{
TempData.Keep();
if (!ModelState.IsValid)
{
return(View(retainer));
}
_retainersRepo.Save(retainer);
TempData["updated"] = true;
return(RedirectToAction("Admin", new { filter = TempData["filter"] }));
}
public ActionResult Edit([Bind(Include = "Ret_ID,Ret_Date,Client_Name,Client_Phone,Prod_Price,Prod_Count,Ret_Value,Due_date,Prod_ID")] Retainer retainer)
{
if (ModelState.IsValid)
{
db.Entry(retainer).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.Prod_ID = new SelectList(db.Products, "Prod_ID", "Prod_Name", retainer.Prod_ID);
return(View(retainer));
}
// GET: Retainers/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Retainer retainer = db.Retainers.Find(id);
if (retainer == null)
{
return(HttpNotFound());
}
return(View(retainer));
}
// GET: Retainers/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Retainer retainer = db.Retainers.Find(id);
if (retainer == null)
{
return(HttpNotFound());
}
ViewBag.Prod_ID = new SelectList(db.Products, "Prod_ID", "Prod_Name", retainer.Prod_ID);
return(View(retainer));
}
private void button7_Click(object sender, EventArgs e)
{
GameManager game = games.FirstOrDefault();
ffxiv_dbEntities db = new ffxiv_dbEntities();
var items = new Queue <dynamic>(from item in db.Items where item.IsUntradable == false select new { ItemId = item.ItemId });
foreach (Process p in Process.GetProcessesByName("ffxiv"))
{
if (realmData == null)
{
realmData = SetUpSaintCoinach(p.MainModule.FileName.Substring(0, p.MainModule.FileName.Length - p.MainModule.ModuleName.Length));
}
game = new GameManager(p, realmData);
game.PacketCaptured += PacketCaptured;
game.Begin();
break;
}
uint itemId = 0;
Server server = db.Servers.Where(d => d.ServerName == "Behemoth").FirstOrDefault();
FFXIVDeviare.Game.Market.MarketManager.MarketResponse mRepsonse = null;
mRepsonse = (marketListing, historyListing) => {
ItemByServer serverItem = db.ItemByServers.Where(i => i.ItemId == itemId && i.Server == server.ServerId).FirstOrDefault();;
db.MarketListings.RemoveRange(db.MarketListings.Where(i => i.ItemByServer == serverItem));
foreach (FFXIVDeviare.Packets.Subpackets.Received.MarketBoardDataForItem.MarketListing ml in marketListing)
{
if (serverItem == null)
{
serverItem = db.ItemByServers.Add(new ItemByServer()
{
Server1 = server,
ItemId = (int)itemId
});
}
Player player = db.Players.Where(i => i.PlayerId == ml.sellerId).FirstOrDefault();
if (player == null)
{
player = db.Players.Add(new Player()
{
Server1 = server,
PlayerId = (int)ml.sellerId,
});
}
Retainer retainer = db.Retainers.Where(i => i.RetainerId == ml.retainerId).FirstOrDefault();
if (retainer == null)
{
retainer = db.Retainers.Add(new Retainer()
{
LastUpdated = new DateTime(ml.timestamp),
RetainerName = ml.name,
Server1 = server,
RetainerId = (int)ml.retainerId,
});
}
db.MarketListings.Add(new MarketListing()
{
City = ml.city,
HQ = ml.hq > 0,
ItemByServer = serverItem,
Materia1 = ml.materia1.ToString(),
Materia2 = ml.materia2.ToString(),
Materia3 = ml.materia3.ToString(),
Materia4 = ml.materia4.ToString(),
Materia5 = ml.materia5.ToString(),
Price = (int)ml.price,
Quantity = ml.qty.ToString(),
Retainer1 = retainer,
});
}
db.SaveChanges();
if (items.Count > 0)
{
Thread.Sleep(3000);
itemId = (uint)(items.Dequeue().ItemId);
game.MarketHandler.GetMarketBoardPriceTablesForItem(itemId, mRepsonse);
}
};
if (items.Count > 1)
{
itemId = (uint)(items.Dequeue().ItemId);
itemId = (uint)(items.Dequeue().ItemId);
game.MarketHandler.GetMarketBoardPriceTablesForItem(itemId, mRepsonse);
}
}