private void DeleteCampaign_Click(object sender, RoutedEventArgs e) { DataSet DS = new DataSet(); DataTable DT = new DataTable(); string campaignName = string.Empty; DataRowView drv = (DataRowView)dgv_CampaignFollow.SelectedItem; try { campaignName = drv.Row.ItemArray[0].ToString(); } catch (Exception ex) { GlobusLogHelper.log.Error("Error : " + ex.StackTrace); } if (!string.IsNullOrEmpty(campaignName)) { var result = ModernDialog.ShowMessage("Are You Sure Delete This Campaign ?? ", "Delete Campaign", MessageBoxButton.YesNoCancel); if (result == MessageBoxResult.Yes) { string DeleteQuery = "delete from tbl_Campaign_Follow where CampaignName='" + campaignName + "'"; DataBaseHandler.DeleteQuery(DeleteQuery, "tbl_Campaign_Follow"); showToGridViewCampaign(); } } else { ModernDialog.ShowMessage("Please Select Campaign From Datagrid !", "Delete Campaign ", MessageBoxButton.OK); GlobusLogHelper.log.Info("Please Select Campaign From Datagrid !"); } }
public void DeleteAllfromtb_RandomiserMention() { try { string strQuery = "Delete from tb_RandomiserMention"; DataBaseHandler.DeleteQuery(strQuery, "tb_RandomiserMention"); } catch { } }
public void Deletetb_GroupUrlforSpecificUser(string user) { try { string strTable = "tb_GroupUrl"; string strQuery = "DELETE FROM tb_GroupUrl where UserName='******'"; DataBaseHandler.DeleteQuery(strQuery, strTable); } catch (Exception) { } }
public void DeleteDBCDecaptcherData(string strDeathByCaptcha) { try { string strTable = "tb_Setting"; string strQuery = "DELETE FROM tb_Setting WHERE FileType='" + strDeathByCaptcha + "'"; DataBaseHandler.DeleteQuery(strQuery, strTable); } catch (Exception) { } }
private void btnClearAccounts_Click(object sender, EventArgs e) { try { if (dgvAccount.Rows.Count <= 1) { MessageBox.Show("There are no Accounts in DataBase"); return; } else if (MessageBox.Show("Do you really want to delete all the accounts from Database", "Confirm delete", MessageBoxButtons.YesNo) == DialogResult.Yes) { string DeleteQuery = "Delete from tb_LinkedInAccount"; DataBaseHandler.DeleteQuery(DeleteQuery, "tb_LinkedInAccount"); Ld_lstAccountCheckerEmail.Clear(); lstLogger.Items.Clear(); AddLoggerAccountLoad("[ " + DateTime.Now + " ] => [ All Accounts Are Clear From The Record ! ]"); LoadGridView(); } } catch { } }