private void LoadCampaigns()
{
try
{
blCampData._Action = "getDataOnload";
dtGatReturnedData = dlCampData.GetDataOnLoad(blCampData);
if (dtGatReturnedData.Rows.Count > 0)
{
GridCampaigns.DataSource = dtGatReturnedData;
GridCampaigns.DataBind();
ViewState["VsCampaignData"] = dtGatReturnedData;
if (Session["SessionTable"] == null)
{
Session.Add("SessionTable", dtGatReturnedData as DataTable);
}
else
{
Session["SessionTable"] = dtGatReturnedData as DataTable;
}
BindCampaignData();
}
else
{
GridCampaigns.DataSource = null;
GridCampaigns.DataBind();
ViewState["VsCampaignData"] = null;
}
}
catch
{
}
}
protected void GridCampaigns_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
GridCampaigns.PageIndex = e.NewPageIndex;
DataTable dt = Session["SessionTable"] as DataTable;
GridCampaigns.DataSource = dt;
GridCampaigns.DataBind();
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "scr", "javascript:Callback2();", true);
}
private void load_filter_dd(string query)
{
try
{
if (con.State != ConnectionState.Open)
{
con.Open();
}
SqlDataAdapter adp = new SqlDataAdapter(query, con);
DataSet ds = new DataSet();
adp.Fill(ds);
con.Close();
if (ds.Tables[0].Rows.Count > 0)
{
GridCampaigns.DataSource = ds.Tables[0];
GridCampaigns.DataBind();
ViewState["VsCampaignData"] = ds.Tables[0];
if (Session["SessionTable"] == null)
{
Session.Add("SessionTable", ds.Tables[0] as DataTable);
}
else
{
Session["SessionTable"] = ds.Tables[0] as DataTable;
}
BindCampaignData();
}
else
{
GridCampaigns.DataSource = null;
GridCampaigns.DataBind();
ViewState["VsCampaignData"] = null;
}
}
catch
{
}
}
protected void gvTeacher_Sorting(object sender, GridViewSortEventArgs e)
{
string sortingDirection = string.Empty;
if (direction == SortDirection.Ascending)
{
direction = SortDirection.Descending;
sortingDirection = "Desc";
}
else
{
direction = SortDirection.Ascending;
sortingDirection = "Asc";
}
DataTable dt = (DataTable)ViewState["VsCampaignData"];
DataView sortedView = new DataView(dt);
sortedView.Sort = e.SortExpression + " " + sortingDirection;
Session["SortedView"] = sortedView;
GridCampaigns.DataSource = sortedView;
GridCampaigns.DataBind();
BindCampaignData();
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "scr", "javascript:Callback2();", true);
}
protected void DeleteCampaign(object sender, EventArgs e)
{
try
{
con.Open();
string camp_id = lbCampaingDeleteID.Text.ToString();
SqlCommand cmd = new SqlCommand("delete from campaigns where campaign_id='" + camp_id + "' ");
cmd.Connection = con;
int a = cmd.ExecuteNonQuery();
con.Close();
if (a > 0)
{
//campain_details
//try
//{
// con.Open();
// SqlCommand cmd2 = new SqlCommand("delete from campain_details where campain_id='" + camp_id + "' ");
// cmd2.Connection = con;
// int a2 = cmd2.ExecuteNonQuery();
// con.Close();
//}
//catch(Exception sqe)
//{
//}
////campain_details_Affiliate_wise
//try
//{
// con.Open();
// SqlCommand cmd3 = new SqlCommand("delete from campain_details_Affiliate_wise where campain_id='" + camp_id + "' ");
// cmd3.Connection = con;
// int a3 = cmd3.ExecuteNonQuery();
// con.Close();
//}
//catch
//{
//}
////campain_details_Affiliate_wise
//try
//{
// con.Open();
// SqlCommand cmd4 = new SqlCommand("delete from campain_details_Affiliate_wise where campain_id='" + camp_id + "' ");
// cmd4.Connection = con;
// int a4 = cmd4.ExecuteNonQuery();
// con.Close();
//}
//catch
//{
//}
////report_manage_table
//try
//{
// con.Open();
// SqlCommand cmd5 = new SqlCommand("delete from report_manage_table where campain_id='" + camp_id + "' ");
// cmd5.Connection = con;
// int a5 = cmd5.ExecuteNonQuery();
// con.Close();
//}
//catch
//{
//}
////report_manage_table_for_affilaite
//try
//{
// con.Open();
// SqlCommand cmd6 = new SqlCommand("delete from report_manage_table_for_affilaite where campain_id='" + camp_id + "' ");
// cmd6.Connection = con;
// int a6 = cmd6.ExecuteNonQuery();
// con.Close();
//}
//catch
//{
//}
////view_click_maintain_on_daily_base
//try
//{
// con.Open();
// SqlCommand cmd7 = new SqlCommand("delete from view_click_maintain_on_daily_base where campain_id='" + camp_id + "' ");
// cmd7.Connection = con;
// int a7 = cmd7.ExecuteNonQuery();
// con.Close();
//}
//catch
//{
//}
}
else
{
}
//if (Session["SessionTable"] == null)
//{
// // Session.Add("SessionTable", ds.Tables[0] as DataTable);
// LoadCampaigns();
//}
//else
//{
//}
DataTable dt = Session["SessionTable"] as DataTable;
foreach (DataRow dr in dt.Rows)
{
if (dr["campain_id"].ToString() == camp_id.ToString())
{
dr.Delete();
}
}
dt.AcceptChanges();
GridCampaigns.DataSource = dt;
GridCampaigns.DataBind();
BindCampaignData();
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "scr", "javascript:Callback2();", true);
}
catch
{
}
}
protected void load_check_boxes(object sender, EventArgs e)
{
try
{
CheckBox start = (CheckBox)sender;
GridViewRow row = (GridViewRow)start.Parent.Parent;
Label lbId = (Label)GridCampaigns.Rows[row.RowIndex].Cells[2].FindControl("lbId");
string campaign_id = lbId.Text;
if (start.Checked == true)
{
con.Open();
SqlCommand cmd = new SqlCommand("update campain_details set status='Running' where campain_id='" + campaign_id + "'");
cmd.Connection = con;
int QueryResponse = cmd.ExecuteNonQuery();
con.Close();
if (QueryResponse > 0)
{
con.Open();
SqlCommand cmd2 = new SqlCommand("update campain_details_Affiliate_wise set status='Running' where campain_id='" + campaign_id + "'");
cmd2.Connection = con;
int a2 = cmd2.ExecuteNonQuery();
con.Close();
DataTable dt = Session["SessionTable"] as DataTable;
for (int i = 0; i < dt.Rows.Count; i++)
{
if (dt.Rows[i]["campain_id"].ToString() == campaign_id)
{
dt.Rows[i]["status"] = "Running";
}
}
dt.AcceptChanges();
GridCampaigns.DataSource = dt;
GridCampaigns.DataBind();
this.BindCampaignData();
this.RegisterPostBackControl();
}
}
else
{
con.Open();
SqlCommand cmd = new SqlCommand("update campain_details set status='Stopped' where campain_id='" + campaign_id + "'");
cmd.Connection = con;
int QueryResponse = cmd.ExecuteNonQuery();
con.Close();
if (QueryResponse > 0)
{
con.Open();
SqlCommand cmd2 = new SqlCommand("update campain_details_Affiliate_wise set status='Stopped' where campain_id='" + campaign_id + "'");
cmd2.Connection = con;
int QueryResponse2 = cmd2.ExecuteNonQuery();
con.Close();
DataTable dt = Session["SessionTable"] as DataTable;
for (int i = 0; i < dt.Rows.Count; i++)
{
if (dt.Rows[i]["campain_id"].ToString() == campaign_id)
{
dt.Rows[i]["status"] = "Stopped";
}
}
dt.AcceptChanges();
GridCampaigns.DataSource = dt;
GridCampaigns.DataBind();
this.BindCampaignData();
this.RegisterPostBackControl();
}
// this. LoadCampaigns();
//DataTable dtFilteredData = Session["SessionTable"] as DataTable;
//GridCampaigns.DataSource = dtFilteredData;
//GridCampaigns.DataBind();
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "scr", "javascript:Callback2();", true);
}
}
catch (Exception sqe)
{
}
}
