示例#1
0
        void DeleteUser()
        {
            if (MessageBox.Show("Czy na pewno chcesz usunąć wskazane pozycje?", Application.ProductName, MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.Yes)
            {
                try
                {
                    var sqlString         = UserSQL.DeleteUser();
                    var RecordCount       = 0;
                    var sqlParamWithValue = new HashSet <Tuple <string, object> >();

                    foreach (User U in olvUser.CheckedObjects)
                    {
                        sqlParamWithValue.Add(new Tuple <string, object>("@Login", U.Login));
                    }
                    using (var scope = AppSession.TypeContainer.BeginLifetimeScope())
                    {
                        var dbs = scope.Resolve <IDataBaseService>();
                        RecordCount = dbs.RemoveManyRecordsAsync(sqlString, sqlParamWithValue).Result;
                    }
                    RefreshData();
                    MessageBox.Show($"{RecordCount} rekordów zostało usuniętych.", Application.ProductName, MessageBoxButtons.OK, MessageBoxIcon.Information);
                }
                catch (Exception ex)
                {
                    MessageBox.Show(ex.Message, Application.ProductName, MessageBoxButtons.OK, MessageBoxIcon.Error);
                }
            }
        }