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))); }