Example #1
0
 public static void DeleteList(ListProp listProp)
 {
     using (IDbConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["cn"].ConnectionString))
     {
         connection.Open();
         connection.Execute("DeleteList", new { List_ID = listProp.List_ID }, commandType: CommandType.StoredProcedure);
     }
 }
Example #2
0
 public static void InsertList(ListProp listProp)
 {
     using (IDbConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["cn"].ConnectionString))
     {
         connection.Open();
         DynamicParameters dp = new DynamicParameters();
         dp.AddDynamicParams(new
         {
             Board_ID       = listProp.Board_ID,
             List_Name      = listProp.List_Name,
             List_Observing = listProp.List_Observing,
             List_Position  = listProp.List_Position
         });
         connection.Execute("InsertList", dp, commandType: CommandType.StoredProcedure);
     }
 }
Example #3
0
        private void ButtonAddList_Click(object sender, EventArgs e)
        {
            int Locate = -1;

            for (int i = 0; i < listBoards.Count; i++)
            {
                if (listBoards[i].BackColor == Color.LightBlue)
                {
                    Locate = i;
                    break;
                }
            }
            ButtonAddList.Location = new Point(ButtonAddList.Location.X + 300, ButtonAddList.Location.Y);
            Lists NewList = new Lists();

            NewList.TextboxListName.Text = "List (" + (listBoards[Locate].list.Count + 1) + ")";
            NewList.NameLists            = NewList.TextboxListName.Text;
            NewList.Location             = new Point(ButtonAddList.Location.X - 300, 0);
            NewList.Deleted          += NewList_Deleted;
            NewList.SecondFormShowed += NewList_SecondFormShowed;
            NewList.SecondFormClosed += NewList_SecondFormClosed;
            listBoards[Locate].list.Add(NewList);
            ListListPanel.Controls.Add(NewList);

            Data.BoardProp boardProp = new Data.BoardProp();
            boardProp = listBoards[Locate].boardProp;

            Data.ListProp listProp = new Data.ListProp();
            listProp.Board_ID       = boardProp.Board_ID;
            listProp.List_Name      = NewList.TextboxListName.Text;
            listProp.List_Observing = false;
            listProp.List_Position  = listBoards[Locate].list.Count - 1;
            Data.DataService.InsertList(listProp);
            listBoards[Locate].listProps = Data.DataService.GetListByBoardID(boardProp.Board_ID);
            NewList.listProp             = listBoards[Locate].listProps[listBoards[Locate].listProps.Count - 1];
        }