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