public bool GetItemInfo(uint itemId, ref ItemItem item) { MySqlCommand command = new MySqlCommand(); command.CommandText = getItemInfoStr; command.CommandType = System.Data.CommandType.Text; command.Connection = conn; command.Parameters.Add(new MySqlParameter("@itemId", itemId)); conn.Open(); try { var res = command.ExecuteReader(); if (res.Read()) { item.VoteId = (uint)res[1]; item.Desc = (string)res[3]; item.DescPicUrl = (string)res[4]; return(true); } } catch { return(false); } finally { conn.Close(); } return(false); }
public bool UpdateItenItem(ItemItem item) { //private string updateItenItemStr = "UPDATE `voters`.`item` SET `desc`=@desc, `desc_pic_url`=@descPicUrl WHERE `id`=@itemId"; MySqlCommand command = new MySqlCommand(); command.CommandText = updateItenItemStr; command.CommandType = System.Data.CommandType.Text; command.Connection = conn; command.Parameters.Add(new MySqlParameter("@desc", item.Desc)); command.Parameters.Add(new MySqlParameter("@descPicUrl", item.DescPicUrl)); command.Parameters.Add(new MySqlParameter("@itemId", item.ItemId)); conn.Open(); try { int res = command.ExecuteNonQuery(); if (res <= 0) { return(false); } } catch { return(false); } finally { conn.Close(); } return(true); }
public bool InsertItem(ItemItem item) { MySqlCommand command = new MySqlCommand(); command.CommandText = insertItemStr; command.CommandType = System.Data.CommandType.Text; command.Connection = conn; command.Parameters.Add(new MySqlParameter("@voteId", item.VoteId)); command.Parameters.Add(new MySqlParameter("@desc", item.Desc)); command.Parameters.Add(new MySqlParameter("@descPicUrl", item.DescPicUrl)); conn.Open(); try { int res = command.ExecuteNonQuery(); if (res <= 0) { return(false); } } catch { return(false); } finally { conn.Close(); } return(true); }