Beispiel #1
0
 private void cmdDelete_Click(object sender, EventArgs e)
 {
     if (MessageBox.Show("Czy na pewno chcesz usunąć wskazane pozycje?", Application.ProductName, MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.Yes)
     {
         try
         {
             var sqlString         = SubjectSQL.DeleteSubject();
             var recordCount       = 0;
             var sqlParamWithValue = new HashSet <Tuple <string, object> >();
             foreach (SubjectModel s in olvSchoolType.CheckedObjects)
             {
                 sqlParamWithValue.Add(new Tuple <string, object>("@ID", s.ID));
             }
             using (var scope = AppSession.TypeContainer.BeginLifetimeScope())
             {
                 var dbs = scope.Resolve <IDataBaseService>();
                 recordCount = dbs.RemoveManyRecordsAsync(sqlString, sqlParamWithValue).Result;
             }
             GetData(olvSchoolType);
             MessageBox.Show($"Liczba usuniętych rekordów: {recordCount}", Application.ProductName, MessageBoxButtons.OK, MessageBoxIcon.Information);
         }
         catch (Exception ex)
         {
             MessageBox.Show(ex.Message, Application.ProductName, MessageBoxButtons.OK, MessageBoxIcon.Error);
         }
     }
 }