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 { }
}
