public static void DeleteCheckList(CheckListProp checkListProp)
{
using (IDbConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["cn"].ConnectionString))
{
connection.Open();
connection.Execute("DeleteCheckList", new { CheckList_ID = checkListProp.CheckList_ID }, commandType: CommandType.StoredProcedure);
}
}
private void SpawnCheckListUserControl()
{
Data.CheckListProp checkListProp = new Data.CheckListProp();
checkListProp.Card_ID = cardProp.Card_ID;
checkListProp.CheckList_Name = $"Checklist ({checkListProps.Count})";
checkListProp.CheckList_Position = checkListProps.Count;
Data.DataService.InsertCheckList(checkListProp);
checkListProps = Data.DataService.GetCheckListByCardID(cardProp.Card_ID);
SpawnCheckListUserControl(checkListProps[checkListProps.Count - 1], true);
}
public static void InsertCheckList(CheckListProp checkListProp)
{
using (IDbConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["cn"].ConnectionString))
{
connection.Open();
DynamicParameters dp = new DynamicParameters();
dp.AddDynamicParams(new
{
Card_ID = checkListProp.Card_ID,
CheckList_Name = checkListProp.CheckList_Name,
CheckList_Position = checkListProp.CheckList_Position
});
connection.Execute("InsertCheckList", dp, commandType: CommandType.StoredProcedure);
}
}
private void SpawnCheckListUserControl(Data.CheckListProp clProp, bool focus)
{
CheckListUserControl checkListUserControl = new CheckListUserControl();
checkListUserControl.AutoSize = true;
checkListUserControl.AutoSizeMode = System.Windows.Forms.AutoSizeMode.GrowAndShrink;
checkListUserControl.BackColor = System.Drawing.Color.Teal;
checkListUserControl.Location = new System.Drawing.Point(5, 5);
checkListUserControl.Margin = new System.Windows.Forms.Padding(5, 10, 5, 10);
checkListUserControl.Name = "checkListUserControl";
checkListUserControl.Size = new System.Drawing.Size(693, 130);
checkListUserControl.CheckListDeleted += CheckListUserControl_CheckListDeleted;
checkListUserControl.Reset += CheckListUserControl_Reset;
checkListUserControl.LoadData(clProp);
checkListPanel.Controls.Add(checkListUserControl);
checkListPanel.Controls.SetChildIndex(checkListUserControl, clProp.CheckList_Position);
if (focus == true)
{
checkListUserControl.OnSpawned();
}
}