public void bindPopup(int CampID) { try { if (CampID > 0) { CampaignPrimaryKey pk = new CampaignPrimaryKey(CampID); Campaign Campaign = Campaign.SelectOne(pk, ConnectionString); txtEditCampName.Text = Campaign.CampaignsName; txtEditCampDescription.Text = Campaign.CampaignsDesc; } else { txtEditCampName.Text = string.Empty; txtEditCampDescription.Text = string.Empty; } } catch { } }
protected void imgbtnExport_Click(object sender, ImageClickEventArgs e) { try { #region Ex1 //CrystalDecisions.Shared.ExportFormatType formateType = ExportFormatType.PortableDocFormat; //if (dpExport.SelectedValue == "PDF") //{ // formateType = ExportFormatType.PortableDocFormat; //} //else if (dpExport.SelectedValue == "Excel") //{ // formateType = ExportFormatType.Excel; //} //else if (dpExport.SelectedValue == "Word") //{ // formateType = ExportFormatType.WordForWindows; //} //else if (dpExport.SelectedValue == "RichText") //{ // formateType = ExportFormatType.RichText; //} //else if (dpExport.SelectedValue == "CrystalReport") //{ // formateType = ExportFormatType.CrystalReport; //} //if (ContactRptname == "Contacts Targeted") //{ // SetDatabase(TargetedRpt, Request.QueryString["ListIds"].ToString()); // TargetedRpt.SetParameterValue("@ListID", Request.QueryString["ListIds"].ToString()); // TargetedRpt.SetParameterValue("@CampaignID", Request.QueryString["CampId"].ToString()); // TargetedRpt.ExportToHttpResponse(formateType, Response, true, "ContactsTargeted"); //} //else if (ContactRptname == "Advanced") //{ // SetDatabase(AdvancedRpt, Request.QueryString["ListIds"].ToString()); // AdvancedRpt.SetParameterValue("@ListIds", Request.QueryString["ListIds"].ToString()); // AdvancedRpt.SetParameterValue("@CampaignId", Request.QueryString["CampId"].ToString()); // AdvancedRpt.ExportToHttpResponse(formateType, Response, true, "Advanced"); //} //else if (ContactRptname == "Successful Delivered") //{ // SetDatabase(SuccessDRpt, string.Empty); // SuccessDRpt.SetParameterValue("@CampaignId", Request.QueryString["CampId"].ToString()); // SuccessDRpt.ExportToHttpResponse(formateType, Response, true, "SuccessfulDeliveredContacts"); //} //else if (ContactRptname == "Clicked") //{ // SetDatabase(ClickedRpt, string.Empty); // ClickedRpt.SetParameterValue("@CampaignId", Request.QueryString["CampId"].ToString()); // ClickedRpt.ExportToHttpResponse(formateType, Response, true, "ClickedContacts"); //} //else if (ContactRptname == "Forwards") //{ // SetDatabase(ForwardRpt, string.Empty); // ForwardRpt.SetParameterValue("@CampaignId", Request.QueryString["CampId"].ToString()); // ForwardRpt.ExportToHttpResponse(formateType, Response, true, "ForwardContacts"); //} //else if (ContactRptname == "Opened") //{ // SetDatabase(OpenMailRpt, string.Empty); // OpenMailRpt.SetParameterValue("@CampaignId", Request.QueryString["CampId"].ToString()); // OpenMailRpt.ExportToHttpResponse(formateType, Response, true, "OpenedContacts"); //} //else if (ContactRptname == "Unopened") //{ // SetDatabase(UnopenRpt, string.Empty); // UnopenRpt.SetParameterValue("@CampaignId", Request.QueryString["CampId"].ToString()); // UnopenRpt.ExportToHttpResponse(formateType, Response, true, "UnopenedContacts"); //} //else if (ContactRptname == "Unsubscribed") //{ // SetDatabase(UnsubRpt, string.Empty); // UnsubRpt.SetParameterValue("@CampaignId", Request.QueryString["CampId"].ToString()); // UnsubRpt.ExportToHttpResponse(formateType, Response, true, "UnsubscribedContacts"); //} //else if (ContactRptname == "Bounced") //{ // SetDatabase(BouncedRpt, string.Empty); // BouncedRpt.SetParameterValue("@CampaignId", Request.QueryString["CampId"].ToString()); // BouncedRpt.ExportToHttpResponse(formateType, Response, true, "BounceContacts"); //} #endregion #region Ex2 //SetDatabase(TargetedRpt, Request.QueryString["ListIds"].ToString()); //if (dpExport.SelectedValue == "PDF") //{ // oStream = (MemoryStream)TargetedRpt.ExportToStream(ExportFormatType.PortableDocFormat); // Response.Clear(); // Response.Buffer = true; // Response.ContentType = "application/pdf"; // Response.BinaryWrite(oStream.ToArray()); // Response.AddHeader("Content-disposition", "Attachment;filename=" + filename.ToString().Trim()+ ".pdf"); // Response.End(); // //TargetedRpt.ExportToHttpResponse(ExportFormatType.WordForWindows, Response, true, Page.Title); //} //else if (dpExport.SelectedValue == "Excel") //{ // oStream = (MemoryStream)TargetedRpt.ExportToStream(ExportFormatType.Excel); // Response.Clear(); // Response.Buffer = true; // Response.ContentType = "application/vnd.xls"; // Response.BinaryWrite(oStream.ToArray()); // Response.AddHeader("Content-disposition", "Attachment;filename=" + filename.ToString().Trim()+ ".xls"); // Response.End(); //} //else if (dpExport.SelectedValue == "Word") //{ // oStream = (MemoryStream)TargetedRpt.ExportToStream(ExportFormatType.WordForWindows); // Response.Clear(); // Response.Buffer = true; // Response.ContentType = "application/vnd.doc"; // Response.BinaryWrite(oStream.ToArray()); // Response.AddHeader("Content-disposition", "Attachment;filename=" + filename.ToString().Trim()+ ".doc"); // Response.End(); //} //else if (dpExport.SelectedValue == "RichText") //{ // oStream = (MemoryStream)TargetedRpt.ExportToStream(ExportFormatType.RichText); // Response.Clear(); // Response.Buffer = true; // Response.ContentType = "application/rtf"; // Response.BinaryWrite(oStream.ToArray()); // Response.AddHeader("Content-disposition", "Attachment;filename=" + filename.ToString().Trim()+ ".rtf"); // Response.End(); //} //else if (dpExport.SelectedValue == "CrystalReport") //{ // oStream = (MemoryStream)TargetedRpt.ExportToStream(ExportFormatType.CrystalReport); // Response.Clear(); // Response.Buffer = true; // Response.ContentType = "application/rpt"; // Response.BinaryWrite(oStream.ToArray()); // Response.AddHeader("Content-disposition", "Attachment;filename=" + filename.ToString().Trim()+ ".rpt"); // Response.End(); //} #endregion string CampName = string.Empty; string campId = HttpContext.Current.Request.QueryString["CampId"] != null ? HttpContext.Current.Request.QueryString["CampId"].ToString() : string.Empty; string mailingId = HttpContext.Current.Request.QueryString["MailingID"] != null ? HttpContext.Current.Request.QueryString["MailingID"].ToString() : string.Empty; //Get the MailingName Using MailingId if (mailingId != string.Empty) { CampaignMasterPrimaryKey pk = new CampaignMasterPrimaryKey(Convert.ToInt64(mailingId)); CampaignMaster objCampMaster = CampaignMaster.SelectOneWithCampaignJobUsingCampaignMasterID(pk, ConnectionString); CampName = objCampMaster.CampaignName.ToString().Trim(); } else { CampaignPrimaryKey pk = new CampaignPrimaryKey(Convert.ToInt64(campId)); Campaign Campaign = Campaign.SelectOne(pk, ConnectionString); CampName = Campaign.CampaignsName; } string listIds = HttpContext.Current.Request.QueryString["ListIds"] != null ? HttpContext.Current.Request.QueryString["ListIds"].ToString() : string.Empty; //string CampName = HttpContext.Current.Request.QueryString["CampName"] != null ? HttpContext.Current.Request.QueryString["CampName"].ToString() : string.Empty; string TabName = string.Empty; DataTable table = new DataTable(); int TotalBounceCount, SoftBounceCount, HardBounceCount = -1; int NeverOptedCount, CommCount, NotInterestedCount, OtherCount = -1, TotalUnsubCount = -1; Export Export = new Export("Web"); #region download using Dll if (ContactRptname == "Contacts Targeted") { TabName = "ContactsTargeted"; ListContactMaster objListContactMaster = new ListContactMaster(ConnectionString); if (listIds != string.Empty && mailingId != string.Empty) table = objListContactMaster.getContactsWithCampaignID(listIds, mailingId); else table = objListContactMaster.getContactsWithAssignCampaignID(campId); } else if (ContactRptname == "Successful Delivered") { TabName = "SuccessfulDelivered"; if (campId != string.Empty) table = ContactMaster.SelectSuccDeliveredByAssignCampIdwithDistinct(ConnectionString, Convert.ToInt32(campId)); else table = ContactMaster.SelectSuccessfulDeliveredByCampId(ConnectionString, Convert.ToInt32(mailingId)); } else if (ContactRptname == "Bounced") { TabName = "Bounced"; if (campId != string.Empty) table = ContactMaster.SelectRecipientsBounceRecByAssignCampId(ConnectionString, Convert.ToInt32(campId), out TotalBounceCount, out SoftBounceCount, out HardBounceCount); else table = ContactMaster.SelectRecipientsBounceRecByCampId(ConnectionString, Convert.ToInt32(mailingId), out TotalBounceCount, out SoftBounceCount, out HardBounceCount); } else if (ContactRptname == "Opened") { TabName = "Opened"; int TotalOpenCounts = -1; if (campId != string.Empty) table = ContactMaster.EmailOpendByAssignCampId(ConnectionString, Convert.ToInt32(campId), out TotalOpenCounts); else table = ContactMaster.EmailOpendByCampId(ConnectionString, Convert.ToInt32(mailingId)); } else if (ContactRptname == "Unopened") { TabName = "Unopened"; if (campId != string.Empty) table = ContactMaster.EmailUnopendRecByAssignCampId(ConnectionString, campId); else table = ContactMaster.EmailUnopendByCampId(ConnectionString, Convert.ToInt32(mailingId)); } else if (ContactRptname == "Clicked") { TabName = "Clicked"; int TotalClickCounts = -1; if (campId != string.Empty) table = ContactMaster.EmailClickedRecByAssignCampId(ConnectionString, Convert.ToInt32(campId), out TotalClickCounts); else table = ContactMaster.EmailClickedRecByCampId(ConnectionString, Convert.ToInt32(mailingId)); } else if (ContactRptname == "Forwards") { TabName = "Forwards"; int TotalForwardCount = -1; if (campId != string.Empty) table = ContactMaster.SelectForwardRecipientsByAssignId(ConnectionString, Convert.ToInt32(campId), out TotalForwardCount); else table = ContactMaster.SelectForwardRecipients(ConnectionString, Convert.ToInt32(mailingId)); } else if (ContactRptname == "Unsubscribed") { TabName = "Unsubscribed"; if (campId != string.Empty) table = ContactMaster.SelectUnsubscribeRecipientsByAssignedCampId(ConnectionString, Convert.ToInt32(campId), out NeverOptedCount, out CommCount, out NotInterestedCount, out OtherCount, out TotalUnsubCount); else table = ContactMaster.SelectUnsubscribeRecipients(ConnectionString, Convert.ToInt32(mailingId), out NeverOptedCount, out CommCount, out NotInterestedCount, out OtherCount); } else if (ContactRptname == "Advanced") { TabName = "Advanced"; if (campId != string.Empty) table = ContactMaster.SelectRecipientsDomainCountsByAssign(ConnectionString, Convert.ToInt32(campId), "TargetedDomain", string.Empty); else table = ContactMaster.SelectRecipientsDomainCounts(ConnectionString, listIds, Convert.ToInt32(mailingId), "TargetedDomain", string.Empty); table.Columns["TargetedDomain"].ColumnName = "Domains"; table.Columns["Unsubs"].ColumnName = "Unsubscribe"; } if (dpExport.SelectedValue.Equals("CSV")) Export.ExportDetails(table, Export.ExportFormat.CSV, TabName + "_" + CampName + "_" + DateTime.Now.ToShortDateString() + ".csv"); else if (dpExport.SelectedValue.Equals("Excel")) Export.ExportDetails(table, Export.ExportFormat.Excel, TabName + "_" + CampName + "_" + DateTime.Now.ToShortDateString() + ".xls"); else if (dpExport.SelectedValue.Equals("Text")) { Export.ExportDetails(table, Export.ExportFormat.Text, TabName + "_" + CampName + "_" + DateTime.Now.ToShortDateString() + ".txt"); } else ExportToPDF(table, TabName + "_" + CampName + "_" + DateTime.Now.ToShortDateString() + ".pdf"); #endregion } catch (Exception ex) { throw ex; } }
protected void lBtnSave_Click(object sender, EventArgs e) { try { lbMsg.Text = string.Empty; Campaign = new Campaign(ConnectionString); Campaign.CampaignsName = txtCampName.Text; Campaign.CampaignsDesc = txtCampDescription.Text; Campaign.Active = true; Campaign.TotalCount = 0; DataTable dtCheck = CampaignBase.SelectByField("CampaignsName", txtCampName.Text.ToString(), ConnectionString); if (dtCheck.Rows.Count > 0) { if (dtCheck.Rows[0]["Active"].ToString() == "True") { lbMsg.ForeColor = Color.Red; lbMsg.Text = string.Format("Campaign: {0}, already exists. Please enter other name.", txtCampName.Text); CreateCampPE.Show(); } else { CampaignPrimaryKey pk = new CampaignPrimaryKey(Convert.ToInt64(dtCheck.Rows[0]["ID"].ToString())); CampaignBase campaignMail = CampaignBase.SelectOne(pk, ConnectionString); campaignMail.CampaignsDesc = string.Empty; campaignMail.CreatedDate = DateTime.Now; campaignMail.ModifiedDate = DateTime.Now; campaignMail.Active = true; lblMainMsg.Text = string.Format(campaignMail.Update() == true ? "Campaign {0} Created Successfully." : "Campaign {0} Created Failed.", txtCampName.Text); bindGrid(string.Empty, RGridCampMails.CurrentPageIndex); } } else { Campaign.CreatedDate = System.DateTime.Now; Campaign.ModifiedDate = System.DateTime.Now; lblMainMsg.Text = string.Format(Campaign.Insert() == true ? "Campaign {0} Created Successfully." : "Campaign {0} Created Failed.", txtCampName.Text); bindGrid(string.Empty, RGridCampMails.CurrentPageIndex); } } catch (Exception ex) { CreateCampPE.Show(); lbMsg.ForeColor = Color.Red; lbMsg.Text = "Error: " + ex.Message; } }
protected void lbtnYes_Click(object sender, EventArgs e) { try { StringBuilder strbDeletedContacts = new StringBuilder(); rememberCampaignsSelection("PgrdaddchkSelectRecs", "lblDCampaignId", RGridCampMails, "Pgrdaddselectall"); if (ViewState["SelectedContacts"] != null) { //adding selected contatIds to stringbuilder for (int i = 0; i < CampaignsSelected.Count; i++) { strbDeletedContacts.Append(CampaignsSelected[i] + ", "); } strbDeletedContacts.Remove(strbDeletedContacts.Length - 2, 1); string[] CampIds = strbDeletedContacts.ToString().Split(','); for (int i = 0; i < CampIds.Length; i++) { //Get Related Mailings then Change AssignedCampaignId is zero. CampaignMailings objCampMail = CampaignMailing.SelectByField("CampaignsId", Convert.ToInt32(CampIds[i].ToString()), ConnectionString); for (int j = 0; j < objCampMail.Count; j++) { long campMasterId = Convert.ToInt64(objCampMail[j].CampaignId.ToString()); CampaignMasterPrimaryKey campMasterPk = new CampaignMasterPrimaryKey(campMasterId); CampaignMaster campMaster = CampaignMaster.SelectOne(campMasterPk, ConnectionString); if (rbtnKeepMails.Checked) campMaster.AssignedCampaignID = 0; else { campMaster.AssignedCampaignID = 0; campMaster.Active = false; } campMaster.Update(); } //Delete All Recoreds in CampaignMailing Table Related to Mailings bool delStatus = CampaignMailing.DeleteByField("CampaignsID", Convert.ToInt32(CampIds[i].ToString()), ConnectionString); CampaignPrimaryKey pk = new CampaignPrimaryKey(Convert.ToInt32(CampIds[i].ToString())); CampaignBase campaignMail = CampaignBase.SelectOne(pk, ConnectionString); campaignMail.Active = false; bool status = campaignMail.Update(); } MDelModalPopupExtender.Hide(); GridPrevSortExpression = string.Empty; bindGrid("sort", 0); ViewState["SelectedContacts"] = null; lblMainMsg.Visible = true; lblMainMsg.Text = "Successfully Deleted Campaign(s) with ids: " + strbDeletedContacts.ToString(); lblMainMsg.Style.Add("color", "Green"); } } catch (Exception ex) { throw ex; } }
//lbtnEditMultipleYes_Click protected void lbtnEditMultipleYes_Click(object sender, EventArgs e) { if (RGridCampMails.MasterTableView.Items.Count > 0) { //Get contact Selection rememberCampaignsSelection("PgrdaddchkSelectRecs", "lblDCampaignId", RGridCampMails, "Pgrdaddselectall"); if (ViewState["SelectedContacts"] != null) { StringBuilder strbEditContacts = new StringBuilder(); //adding selected contatIds to stringbuilder for (int i = 0; i < CampaignsSelected.Count; i++) { strbEditContacts.Append(CampaignsSelected[i] + ", "); Campaign campaign = new Campaign(ConnectionString); campaign.ID = Convert.ToInt64(CampaignsSelected[i]); campaign.CampaignsDesc = txtMultiCampaignDesc.Text; CampaignPrimaryKey pk = new CampaignPrimaryKey(Convert.ToInt64(CampaignsSelected[i])); CampaignBase campaignnew = CampaignBase.SelectOne(pk, ConnectionString); campaign.CreatedDate = campaignnew.CreatedDate; campaign.ModifiedDate = System.DateTime.Now; campaign.Active = true; CampaignBase objCampaignBase = new CampaignBase(ConnectionString); objCampaignBase.SelectedEditUpdateCampaign(campaign); } strbEditContacts.Remove(strbEditContacts.Length - 2, 1); ViewState["SelectedContacts"] = null; hdrchkselected.Clear(); if (txtCampNameSearch.Text != string.Empty || txtCampDesSearch.Text != string.Empty || txtCreatedDate.Text != string.Empty) { SearchCriteria(0, string.Empty); } else { bindGrid(string.Empty, 0); } lblMainMsg.Text = "Successfully Edit Campaign(s) with ids: " + strbEditContacts.ToString(); hdnMeditselect.Value = "false"; } } }
// Edit protected void lbSaveCamp_Click(object sender, EventArgs e) { try { string campName = txtEditCampName.Text.ToString(); DataTable dtCheck = CampaignBase.SelectByField("CampaignsName", txtEditCampName.Text.ToString(), ConnectionString); Campaign objCampaign = new Campaign(ConnectionString); objCampaign.CampaignsName = txtEditCampName.Text; objCampaign.CampaignsDesc = txtEditCampDescription.Text; if (Convert.ToInt64(hiddenEditID.Value) > 0) { objCampaign.ID = Convert.ToInt64(hiddenEditID.Value); if (dtCheck.Rows.Count > 0 && Convert.ToInt64(dtCheck.Rows[0]["ID"]) != Convert.ToInt64(hiddenEditID.Value)) { lbMsgForEdit.Text = "Campaign:" + txtEditCampName.Text + ", already exists. Please enter other name."; MpextDivEdit.Show(); } else { CampaignPrimaryKey pk = new CampaignPrimaryKey(Convert.ToInt64(hdId.Value.ToString())); Campaign CampNew = Campaign.SelectOne(pk, ConnectionString); Campaign = new Campaign(ConnectionString); Campaign.ID = Convert.ToInt64(hdId.Value.ToString()); Campaign.CampaignsName = txtEditCampName.Text.ToString().Trim(); Campaign.CampaignsDesc = txtEditCampDescription.Text.ToString().Trim(); Campaign.CreatedDate = CampNew.CreatedDate; Campaign.ModifiedDate = DateTime.Now; Campaign.Active = true; if (Campaign.Update() == true) { lblMainMsg.Text = string.Format("Campaign: {0} Updated Successfully.", Server.HtmlEncode(txtEditCampName.Text)); bindGrid(string.Empty, RGridCampMails.CurrentPageIndex); } else { lblMainMsg.Text = string.Format("Campaign: {0} Updation Failed.", Server.HtmlEncode(txtEditCampName.Text)); } } } } catch (Exception ex) { throw ex; } }
/// <summary> /// This method will get row(s) from the database using the value of the field specified /// along with the details of the child table. /// </summary> /// /// <param name="pk" type="CampaignsPrimaryKey">Primary Key information based on which data is to be fetched.</param> /// /// <returns>object of class Campaigns</returns> /// /// <remarks> /// /// <RevisionHistory> /// Author Date Description /// DLGenerator 6/25/2012 02:05:58 PM Created function /// /// </RevisionHistory> /// /// </remarks> /// public static Campaign SelectOneWithCampaignMailingUsingCampaignMailId(CampaignPrimaryKey pk,string ConnectionString) { DatabaseHelper oDatabaseHelper = new DatabaseHelper(); bool ExecutionState = false; Campaign obj=null; // Pass the values of all key parameters to the stored procedure. System.Collections.Specialized.NameValueCollection nvc = pk.GetKeysAndValues(); foreach (string key in nvc.Keys) { oDatabaseHelper.AddParameter("@" + key,nvc[key] ); } // The parameter '@ErrorCode' will contain the status after execution of the stored procedure. oDatabaseHelper.AddParameter("@ErrorCode", -1, System.Data.ParameterDirection.Output); IDataReader dr=oDatabaseHelper.ExecuteReader("sp_Campaigns_SelectOneWithCampaignMailingUsingCampaignMailId", ref ExecutionState); if (dr.Read()) { obj = new Campaign(ConnectionString); PopulateObjectFromReader(obj,dr); dr.NextResult(); //Get the child records. obj.CampaignMailings = CampaignMailing.PopulateObjectsFromReader(dr, ConnectionString); } dr.Close(); oDatabaseHelper.Dispose(); return obj; }
/// <summary> /// This method will Delete one row from the database using the primary key information /// </summary> /// /// <param name="pk" type="CampaignPrimaryKey">Primary Key information based on which data is to be fetched.</param> /// /// <returns>True if succeeded</returns> /// /// <remarks> /// /// <RevisionHistory> /// Author Date Description /// DLGenerator 6/25/2012 02:05:58 PM Created function /// /// </RevisionHistory> /// /// </remarks> /// public static bool Delete(CampaignPrimaryKey pk) { DatabaseHelper oDatabaseHelper = new DatabaseHelper(); bool ExecutionState = false; // Pass the values of all key parameters to the stored procedure. System.Collections.Specialized.NameValueCollection nvc = pk.GetKeysAndValues(); foreach (string key in nvc.Keys) { oDatabaseHelper.AddParameter("@" + key,nvc[key] ); } // The parameter '@ErrorCode' will contain the status after execution of the stored procedure. oDatabaseHelper.AddParameter("@ErrorCode", -1, System.Data.ParameterDirection.Output); oDatabaseHelper.ExecuteScalar("sp_Campaigns_Delete", ref ExecutionState); oDatabaseHelper.Dispose(); return ExecutionState; }
protected void imgbtnExport_Click(object sender, ImageClickEventArgs e) { try { string CampName = string.Empty; string campId = HttpContext.Current.Request.QueryString["CampId"] != null ? HttpContext.Current.Request.QueryString["CampId"].ToString() : string.Empty; string mailingId = HttpContext.Current.Request.QueryString["MailingID"] != null ? HttpContext.Current.Request.QueryString["MailingID"].ToString() : string.Empty; //Get the MailingName Using MailingId if (mailingId != string.Empty) { CampaignMasterPrimaryKey pk = new CampaignMasterPrimaryKey(Convert.ToInt64(mailingId)); CampaignMaster objCampMaster = CampaignMaster.SelectOneWithCampaignJobUsingCampaignMasterID(pk, ConnectionString); CampName = objCampMaster.CampaignName.ToString().Trim(); } else { CampaignPrimaryKey pk = new CampaignPrimaryKey(Convert.ToInt64(campId)); Campaign Campaign = Campaign.SelectOne(pk, ConnectionString); CampName = Campaign.CampaignsName; } //string CampName = HttpContext.Current.Request.QueryString["CampName"] != null ? HttpContext.Current.Request.QueryString["CampName"].ToString() : string.Empty; string TabName = string.Empty; DataTable table = new DataTable(); Export Export = new Export("Web"); #region download using Dll if (ContactRptname == "Wheelock") { TabName = "Wheelock"; if (campId != string.Empty) table = ContactMaster.getWheelockClickCountsByAssignCampId(ConnectionString, campId); else table = ContactMaster.getWheelockClickCounts(ConnectionString, mailingId); } else if (ContactRptname == "Widener") { TabName = "Widener"; if (campId != string.Empty) table = ContactMaster.getWidenerClickCountsByAssignCampId(ConnectionString, campId); else table = ContactMaster.getWidenerClickCounts(ConnectionString, mailingId); } if (dpExport.SelectedValue.Equals("CSV")) Export.ExportDetails(table, Export.ExportFormat.CSV, TabName + "_" + CampName + "_" + DateTime.Now.ToShortDateString() + ".csv"); else if (dpExport.SelectedValue.Equals("Excel")) Export.ExportDetails(table, Export.ExportFormat.Excel, TabName + "_" + CampName + "_" + DateTime.Now.ToShortDateString() + ".xls"); else if (dpExport.SelectedValue.Equals("Text")) { Export.ExportDetails(table, Export.ExportFormat.Text, TabName + "_" + CampName + "_" + DateTime.Now.ToShortDateString() + ".txt"); } else ExportToPDF(table, TabName + "_" + CampName + "_" + DateTime.Now.ToShortDateString() + ".pdf"); #endregion } catch (Exception ex) { throw ex; } }