public ActionResult DeleteConfirmed(string id)
{
item_table item_table = db.item_tables.Find(id);
db.item_tables.Remove(item_table);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "itemname,itemownerID")] item_table item_table)
{
if (ModelState.IsValid)
{
db.Entry(item_table).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.itemownerID = new SelectList(db.trader_indices, "traderID", "firstname", item_table.itemownerID);
return(View(item_table));
}
protected void upload_item_table_button_Click(object sender, EventArgs e)
{
item_table_model upload = new item_table_model();
item_table item = upload_item_table();
upload_item_table_lbl_results.Text = upload.add_item(item);
System.Threading.Thread.Sleep(3000);
Response.Redirect("~/Pages/Administration/administer.aspx");
}
// GET: item_table/Details/5
public ActionResult Details(string id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
item_table item_table = db.item_tables.Find(id);
if (item_table == null)
{
return(HttpNotFound());
}
return(View(item_table));
}
private item_table upload_item_table()
{
item_table itemtable = new item_table();
itemtable.ItemName = dbitemtablenametextboxlink.Text;
itemtable.Versions = Convert.ToInt32(dbitemtableversionsdropdownlink.SelectedValue);
itemtable.ItemDetails = dbitemtabledetailstextboxlink.Text;
itemtable.ItemCostBND = Convert.ToDecimal(dbitemtablepricetextboxlink.Text);
itemtable.ItemDisplay = dbitemtabledisplaydropdownlink.SelectedValue;
return(itemtable);
}
// GET: item_table/Edit/5
public ActionResult Edit(string id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
item_table item_table = db.item_tables.Find(id);
if (item_table == null)
{
return(HttpNotFound());
}
ViewBag.itemownerID = new SelectList(db.trader_indices, "traderID", "firstname", item_table.itemownerID);
return(View(item_table));
}
/*end array list of item versions from table*/
/*begin adding item to table*/
public string add_item(item_table itemtable)
{
try
{
SaPEEntitiesRemote db = new SaPEEntitiesRemote();
db.item_table.Add(itemtable);
db.SaveChanges();
return(itemtable.ItemName + " Added Sucessfull");
}
catch (Exception e)
{
return("Something When Wrong" + e);
}
}
/*begin getting item from table*/
public item_table retrieve_item(int Code)
{
try
{
using (SaPEEntitiesRemote db = new SaPEEntitiesRemote())
{
item_table itemtable = db.item_table.Find(Code);
return(itemtable);
}
}
catch (Exception)
{
return(null);
}
}
/*end adding item to table*/
/*begin deleting item to table*/
public string delete_item(int Code)
{
try
{
SaPEEntitiesRemote db = new SaPEEntitiesRemote();
item_table itemtable = db.item_table.Find(Code);
db.item_table.Attach(itemtable);
db.item_table.Remove(itemtable);
db.SaveChanges();
return(itemtable.ItemName + " Deleted Sucessfull");
}
catch (Exception e)
{
return("Something When Wrong" + e);
}
}
static void TestCompact()
{
MemoryStream memsout = new MemoryStream();
TCompactWriter compact_writer = new TCompactWriter(memsout);
item_table item0 = new item_table();
item_table item1 = new item_table();
item0.ID = 1;
item0.ItemName = "强化水晶";
item0.ReplaceItem = 64389;
item0.Medals = 1;
item0.Value = 1;
item0.ReserveMoneyFlag = 0;
item0.Quality = 1;
item0.ItemType = item_type.crystal;
item0.UseSingTime = 0;
item0.CanMoved = 1;
item0.CanDeleted = 1;
item0.CanTrade = 1;
item0.CanSold = 1;
item0.CanStored = 1;
item0.CanLocked = 1;
item0.IsExclusive = 0;
item0.CanDrop = 1;
item0.DecomposePackID = 0;
item0.vec = new string[1];
item0.vec[0] = "haha";
item0.Write(compact_writer);
byte[] bout = memsout.GetBuffer();
MemoryStream memsin = new MemoryStream(bout);
TCompactReader compact_reader = new TCompactReader(memsin);
item1.Read(compact_reader);
}
/*end deleting item to table*/
/*begin updating item to table*/
public string update_item(int Code, item_table itemtable)
{
try
{
SaPEEntitiesRemote db = new SaPEEntitiesRemote();
item_table i = db.item_table.Find(Code);
i.ItemName = itemtable.ItemName;
i.Versions = itemtable.Versions;
i.ItemDetails = itemtable.ItemDetails;
i.ItemCostBND = itemtable.ItemCostBND;
i.ItemDisplay = itemtable.ItemDisplay;
db.SaveChanges();
return("Updated Successfull");
}
catch (Exception e)
{
return("Something When Wrong" + e);
}
}
