public static List <DragButtonTransfer> GetButtons()
{
MySqlCommand cmd = new MySqlCommand("GetButtons", new MySqlConnection(connectionString));
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection.Open();
MySqlDataReader rdr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
List <DragButtonTransfer> buttons = new List <DragButtonTransfer>();
while (rdr.Read())
{
DragButtonTransfer button = new DragButtonTransfer();
button.Tag = int.Parse(rdr[0].ToString());
button.Text = rdr[1].ToString();
button.Name = rdr[2].ToString();
button.Left = int.Parse(rdr[3].ToString());
button.Top = int.Parse(rdr[4].ToString());
button.Type = rdr[5].ToString() == "0" ? Enums.ButtonTypes.Unit : Enums.ButtonTypes.Collection;
buttons.Add(button);
}
rdr.Close();
return(buttons);
}
public static DragButtonTransfer mapDragButtonToTransferButton(DragButton btnDrag)
{
DragButtonTransfer btnTransfer = new DragButtonTransfer();
btnTransfer.Tag = int.Parse(btnDrag.Tag.ToString());
btnTransfer.Text = btnDrag.Text;
btnTransfer.Name = btnDrag.Name;
btnTransfer.Left = btnDrag.Left;
btnTransfer.Top = btnDrag.Top;
btnTransfer.Type = btnDrag.Type;
return(btnTransfer);
}
public static void AddButtonToAllButtons(DragButtonTransfer button)
{
MySqlCommand cmd = new MySqlCommand("AddToAllButtons", new MySqlConnection(connectionString));
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new MySqlParameter("_id", button.Tag));
cmd.Parameters.Add(new MySqlParameter("_text", button.Text));
cmd.Parameters.Add(new MySqlParameter("_name", button.Name));
cmd.Parameters.Add(new MySqlParameter("_x", button.Left));
cmd.Parameters.Add(new MySqlParameter("_y", button.Top));
cmd.Parameters.Add(new MySqlParameter("_type", button.Type));
cmd.Connection.Open();
cmd.ExecuteNonQuery();
cmd.Connection.Close();
}
public static void AddButtonToAllButtons(DragButtonTransfer button)
{
TcpClient.sendObject <DragButtonTransfer>(new DBMsg(ManagerType.ButtonsManager, "AddButtonToAllButtons", JsonConvert.SerializeObject(button)));
}
