public void Update(ItemToSell itemToSell)
{
using (var conn = new SqlConnection(_ConnStr))
{
using (var cmd = conn.CreateCommand())
{
cmd.CommandText = "udspUpdateItemToSellBYID";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@ID", itemToSell.ItemToSellId);
cmd.Parameters.AddWithValue("@ItemName", itemToSell.ItemName);
cmd.Parameters.AddWithValue("@ItemBrand", itemToSell.ItemBrand ?? (object)DBNull.Value);
cmd.Parameters.AddWithValue("@ItemDescription", itemToSell.ItemDescription ?? (object)DBNull.Value);
cmd.Parameters.AddWithValue("@ItemModel", itemToSell.ItemModel ?? (object)DBNull.Value);
cmd.Parameters.AddWithValue("@ItemAddedDate", itemToSell.ItemAddedDate);
cmd.Parameters.AddWithValue("@ItemImage", itemToSell.ItemImage ?? (object)DBNull.Value);
cmd.Parameters.AddWithValue("@IsActive", itemToSell.IsActive);
cmd.Parameters.AddWithValue("@ItemCategoryID", itemToSell.ItemCategoryId ?? (object)DBNull.Value);
cmd.Parameters.AddWithValue("@ItemRemained", itemToSell.ItemRemained ?? (object)DBNull.Value);
cmd.Parameters.AddWithValue("@ItemLeft", itemToSell.ItemLeft ?? (object)DBNull.Value);
conn.Open();
cmd.ExecuteNonQuery();
}
}
}
public void Insert(ItemToSell itm) //itm = itemtosell
{
using (var conn = new SqlConnection(_ConnStr))
{
using (var cmd = conn.CreateCommand())
{
cmd.CommandText = "udspCreateNewItemToSell";
cmd.CommandType = CommandType.StoredProcedure;
//how it is done in anywhere
var pItemName = cmd.CreateParameter();
pItemName.ParameterName = "ItemName";
pItemName.DbType = System.Data.DbType.String;
pItemName.Value = itm.ItemName;
pItemName.Direction = System.Data.ParameterDirection.Input;
cmd.Parameters.Add(pItemName);
//in ado.net SQL parameter
cmd.Parameters.AddWithValue("ItemBrand", itm.ItemBrand ?? (object)DBNull.Value);
cmd.Parameters.AddWithValue("ItemDescription", itm.ItemDescription ?? (object)DBNull.Value);
cmd.Parameters.AddWithValue("ItemModel", itm.ItemModel ?? (object)DBNull.Value);
cmd.Parameters.AddWithValue("ItemAddedDate", itm.ItemAddedDate);
cmd.Parameters.AddWithValue("ItemImage", itm.ItemImage ?? (object)DBNull.Value);
cmd.Parameters.AddWithValue("IsActive", itm.IsActive);
cmd.Parameters.AddWithValue("ItemCategoryID", itm.ItemCategoryId ?? (object)DBNull.Value);
cmd.Parameters.AddWithValue("ItemRemained", itm.ItemRemained ?? (object)DBNull.Value);
cmd.Parameters.AddWithValue("ItemLeft", itm.ItemLeft ?? (object)DBNull.Value);
conn.Open();
cmd.ExecuteNonQuery();
}
}
}
public ItemToSell GetById(int id)
{
ItemToSell itemToSell = new ItemToSell();
using (var conn = new SqlConnection(_ConnStr))
{
using (var cmd = conn.CreateCommand())
{
cmd.CommandText = SELECT_BY_ID;
cmd.Parameters.AddWithValue(@"ItemToSellID", id);
conn.Open();
using (var rdr = cmd.ExecuteReader())
{
if (rdr.Read())
{
itemToSell = MapReaderToItemToSell(rdr);
}
}
}
}
return(itemToSell);
}
public void Buy(ushort gid, uint quantity)
{
ItemRecord template = ItemToSell.FirstOrDefault(x => x.Id == gid);
if (template != null)
{
if (this.TokenId == 0)
{
int cost = (int)(template.GetPrice(LevelPrice) * quantity);
if (!Character.RemoveKamas(cost))
{
return;
}
}
else
{
CharacterItemRecord tokenItem = Character.Client.Character.Inventory.GetFirstItem(TokenId, (uint)(template.GetPrice(LevelPrice) * quantity));
if (tokenItem == null)
{
Character.Client.Character.ReplyError("Vous ne possedez pas asser de token.");
return;
}
else
{
Character.Inventory.RemoveItem(tokenItem.UId, (uint)(quantity * template.GetPrice(LevelPrice)));
}
}
Character.Inventory.AddItem(gid, quantity, TokenId != 0);
Character.Client.Send(new ExchangeBuyOkMessage());
}
}
public ActionResult Edit(ItemToSell itemToSell)
{
try
{
ItemRep.Update(itemToSell);
return(RedirectToAction(nameof(Index)));
}
catch (Exception ex)
{
return(View());
}
}
private ItemToSell MapReaderToItemToSell(DbDataReader rdr)
{
var item = new ItemToSell();
item.ItemToSellId = rdr.GetInt32(rdr.GetOrdinal("ID"));
item.ItemName = rdr.GetString(rdr.GetOrdinal("ItemName"));
item.ItemBrand = rdr.IsDBNull(rdr.GetOrdinal("ItemBrand"))
? (string)null
: rdr.GetString(rdr.GetOrdinal("ItemBrand"));
item.ItemDescription = rdr.IsDBNull(rdr.GetOrdinal("ItemDescription"))
? null
: rdr.GetString(rdr.GetOrdinal("ItemDescription"));
item.ItemModel = rdr.IsDBNull(rdr.GetOrdinal("ItemModel"))
? null
: rdr.GetString(rdr.GetOrdinal("ItemModel"));
item.ItemAddedDate = rdr.GetDateTime(rdr.GetOrdinal("ItemAddedDate"));
item.ItemImage = rdr.IsDBNull(rdr.GetOrdinal("ItemImage"))
? null
: rdr.GetString(rdr.GetOrdinal("ItemImage"));
item.IsActive = rdr.GetBoolean(rdr.GetOrdinal("IsActive"));
item.ItemCategoryId = rdr.IsDBNull(rdr.GetOrdinal("ItemCategoryID"))
? (int?)null
: rdr.GetInt32(rdr.GetOrdinal("ItemCategoryID"));
item.ItemRemained = (rdr.IsDBNull(rdr.GetOrdinal("ItemRemained"))
? (int?)null
: rdr.GetInt32(rdr.GetOrdinal("ItemRemained")));
item.ItemLeft = (rdr.IsDBNull(rdr.GetOrdinal("ItemLeft"))
? (int?)null
: rdr.GetInt32(rdr.GetOrdinal("ItemLeft")));
return(item);
}
