public void CampaignInsert(Campaign objCampaign) { try { objEmailCampDataContext = new EmailCampDataContext(); var Insert = (from cde in objEmailCampDataContext.spCampaign_AllActions(objCampaign.PK_CampaignID, objCampaign.FK_UserID, objCampaign.CampaignName, objCampaign.Title, objCampaign.SchduleDateTime, objCampaign.CampTimezone, objCampaign.Utctime, objCampaign.FromName, objCampaign.Emailid, objCampaign.CreatedBy, objCampaign.CreatedOn, objCampaign.UpdatedBy, objCampaign.UpdatedOn, objCampaign.CampaignStatus, objCampaign.mailcontent, null, null, null, "i") select cde).ToList(); Insert = null; objCampaign = null; objEmailCampDataContext = null; } catch (Exception ex) { ex.ToString(); } }
public void CampaignDelete(int Campaignid) { try { objEmailCampDataContext = new EmailCampDataContext(); var Delete = (from cde in objEmailCampDataContext.spCampaign_AllActions(Campaignid, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, "d") select cde).ToList(); Delete = null; objCampaign = null; objEmailCampDataContext = null; } catch (Exception ex) { ex.ToString(); } }
public List<Campaign> CampaignBindDashboard(int CompanyID) { objEmailCampDataContext = new EmailCampDataContext(); lstCampaign = new List<Campaign>(); var Select = (from cde in objEmailCampDataContext.spCampaign_AllActions(null, CompanyID, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, "p") select cde).ToList(); if (Select.Count > 0) { lstCampaign = new List<Campaign>(); foreach (var item in Select) { objCampaign = new Campaign(); objCampaign.CampaignName = Convert.ToString(item.CampaignName); objCampaign.PK_CampaignID = item.PK_CampaignID; lstCampaign.Add(objCampaign); } } objEmailCampDataContext = null; objCampaign = null; return lstCampaign; }
public void RetrieveCampaign() { try { objCampaign = new Campaign(); objBL_CreateCampaign = new BL_CreateCampaign(); lstCampaign = objBL_CreateCampaign.SelectCampaignListbasedonid(Convert.ToInt32(HttpUtility.UrlDecode(Request.QueryString["CampId"]).ToString())); if (lstCampaign.Count > 0) { txtCampaignName.Value = lstCampaign[0].CampaignName; txtTitle.Value = lstCampaign[0].Title; if(lstCampaign[0].FromName != null) FromName.Value = lstCampaign[0].FromName; if (lstCampaign[0].Emailid != null) EmailID.Value = lstCampaign[0].Emailid; } } catch (Exception ex) { New_EmailCampaign.App_Code.GlobalFunction.StoreLog("CampaignEdit.aspx:RetrieveCampaign() - " + ex.Message); } }
private void RetrieveCampaigndetails() { try { objCampaign = new Campaign(); objBL_CreateCampaign = new BL_CreateCampaign(); lstCampaign = objBL_CreateCampaign.SelectCampaignListbasedonid(Convert.ToInt32(Session["CampgnID"].ToString())); if (lstCampaign.Count > 0) { txtCampaignName.Value = lstCampaign[0].CampaignName; txtTitle.Value = lstCampaign[0].Title; if (lstCampaign[0].FromName != null) FromName.Value = lstCampaign[0].FromName; if (lstCampaign[0].FromName != null) EmailID.Value = lstCampaign[0].Emailid; } } catch (Exception ex) { New_EmailCampaign.App_Code.GlobalFunction.StoreLog("CreateCampign.aspx:RetrieveCampaigndetails() - " + ex.Message); } }
/// <summary> /// Created By :: Sakthivel.R /// Created On :: 27-3-2015 /// Comments :: Inserting all values of campaign form. /// </summary> protected void btnSubmit_Click(object sender, EventArgs e) { try { objCampaign = new Campaign(); objCampaign.FK_UserID = Convert.ToInt32(Session["UserID"].ToString()); objCampaign.CampaignName = txtCampaignName.Value.ToString().Trim(); objCampaign.Title = txtTitle.Value.ToString().Trim(); string dttime = dtScheduledatetime.Value; string[] dateString = dttime.Split('/'); DateTime enter_date = Convert.ToDateTime(dateString[1] + "/" + dateString[0] + "/" + dateString[2]); DateTime utcTime = enter_date.ToUniversalTime(); objCampaign.Utctime = utcTime; objCampaign.SchduleDateTime = enter_date; objCampaign.FromName = FromName.Value.ToString(); objCampaign.Emailid = EmailID.Value.ToString(); objCampaign.CampTimezone = ddlTimeZone.SelectedValue; objCampaign.CampaignStatus = false; //if (Editstatus == 1) //{ // objCampaign.UpdatedBy = Convert.ToInt32(Session["UserID"].ToString()); // objCampaign.UpdatedOn = DateTime.Now; // objBL_CreateCampaign.AccessInsertCampign(objCampaign); //} //else //{ // objCampaign.CreatedBy = Convert.ToInt32(Session["UserID"].ToString()); objCampaign.CreatedOn = DateTime.Now; objBL_CreateCampaign.AccessInsertCampign(objCampaign); //} ClientScript.RegisterStartupScript(Page.GetType(), "mykey", "Clearuserinput1();", true); } catch (Exception ex) { New_EmailCampaign.App_Code.GlobalFunction.StoreLog("CreateCampign.aspx:btnSubmit_Click() - " + ex.Message); } }
public void AccessUpdateCampign(Campaign objCampaign1) { objDL_CreateCampaign.CampaignUpdate(objCampaign1); }
public void AccessInsertCampign(Campaign objCampaign1) { objDL_CreateCampaign.CampaignInsert(objCampaign1); }
/// <summary> /// Created By :: Sakthivel.R /// Created On :: 20-5-2015 /// Comments :: Inserting all values of campaign form. /// </summary> protected void btnSubmit_Click(object sender, EventArgs e) { try { objCampaign = new Campaign(); lstCampaign = new List<Campaign>(); objCampaign.FK_UserID = Convert.ToInt32(Session["UserID"].ToString()); objCampaign.CampaignName = txtCampaignName.Value.ToString().Trim(); objCampaign.Title = txtTitle.Value.ToString().Trim(); //string dttime = dtScheduledatetime.Value; //string[] dateString = dttime.Split('/'); //DateTime enter_date = Convert.ToDateTime(dateString[1] + "/" + dateString[0] + "/" + dateString[2]); //DateTime utcTime = enter_date.ToUniversalTime(); //objCampaign.Utctime = utcTime; //objCampaign.SchduleDateTime = enter_date; objCampaign.FromName = FromName.Value.ToString(); objCampaign.Emailid = EmailID.Value.ToString(); //objCampaign.CampTimezone = ddlTimeZone.SelectedValue; objCampaign.CampaignStatus = false; //if (Editstatus == 1) //{ // objCampaign.UpdatedBy = Convert.ToInt32(Session["UserID"].ToString()); // objCampaign.UpdatedOn = DateTime.Now; // objBL_CreateCampaign.AccessInsertCampign(objCampaign); //} //else //{ // objCampaign.CreatedBy = Convert.ToInt32(Session["UserID"].ToString()); if (Request.QueryString["CampId"] != null) { objCampaign.PK_CampaignID = Convert.ToInt32(Request.QueryString["CampId"].ToString()); objCampaign.UpdatedBy = Convert.ToInt32(Session["UserID"].ToString()); objCampaign.UpdatedOn = DateTime.Now; lstCampaign = objBL_CreateCampaign.SelectCampaignListbasedonid(Convert.ToInt32(HttpUtility.UrlDecode(Request.QueryString["CampId"]).ToString())); if (lstCampaign.Count > 0) { //if(lstCampaign[0].FK_UserID != null) objCampaign.FK_UserID = lstCampaign[0].FK_UserID; if (lstCampaign[0].SchduleDateTime != null) objCampaign.SchduleDateTime = lstCampaign[0].SchduleDateTime; if (lstCampaign[0].CampTimezone != null) objCampaign.CampTimezone = lstCampaign[0].CampTimezone; if (lstCampaign[0].Utctime != null) objCampaign.Utctime = lstCampaign[0].Utctime; if (lstCampaign[0].CampaignStatus != null) objCampaign.CampaignStatus = lstCampaign[0].CampaignStatus; if (lstCampaign[0].CreatedOn != null) objCampaign.CreatedOn = lstCampaign[0].CreatedOn; if (lstCampaign[0].CreatedBy != null) objCampaign.CreatedBy = lstCampaign[0].CreatedBy; } objBL_CreateCampaign.AccessUpdateCampign(objCampaign); } else { objCampaign.CreatedOn = DateTime.Now; objCampaign.CreatedBy = Convert.ToInt32(Session["UserID"].ToString()); objBL_CreateCampaign.AccessInsertCampign(objCampaign); } ClientScript.RegisterStartupScript(Page.GetType(), "mykey", "Clearuserinput1();", true); } catch (Exception ex) { New_EmailCampaign.App_Code.GlobalFunction.StoreLog("CampaignEdit.aspx:btnSubmit_Click() - " + ex.Message); } }
public DataSet CampaignSelectforgridBasedonFilter(string uertype, int companyid, string CampName, string Title, Nullable<DateTime> CreatedOn, string all, string fromname) { objEmailCampDataContext = new EmailCampDataContext(); lstCampaign = new List<Campaign>(); var Select = (from cde in objEmailCampDataContext.spCampaign_AllActions(null, companyid, CampName, Title, null, null, null, fromname, all, null, CreatedOn, null, null, null, null, null, null, null, uertype) select cde).ToList(); if (Select.Count > 0) { lstCampaign = new List<Campaign>(); foreach (var item in Select) { objCampaign = new Campaign(); objCampaign.CampaignName = Convert.ToString(item.CampaignName); objCampaign.CampTimezone = Convert.ToString(item.CampTimezone); objCampaign.CreatedBy = item.CreatedBy; objCampaign.CreatedOn = item.CreatedOn; objCampaign.UpdatedBy = item.UpdatedBy; objCampaign.UpdatedOn = item.UpdatedOn; objCampaign.Emailid = item.Emailid; objCampaign.FK_UserID = item.FK_UserID; objCampaign.FromName = item.FromName; objCampaign.PK_CampaignID = item.PK_CampaignID; objCampaign.SchduleDateTime = item.SchduleDateTime; objCampaign.Title = item.Title; objCampaign.Utctime = item.utctime; objCampaign.CampaignStatus = item.CampaignStatus; objCampaign.mailcontent = item.mailcontent; lstCampaign.Add(objCampaign); } } objEmailCampDataContext = null; objCampaign = null; DataSet converted = new DataSet(); if (lstCampaign.Count > 0) { converted.Tables.Add(ListToDataSet.newTable(lstCampaign)); return converted; } else { converted.Tables.Add(ListToDataSet.newTableColumnAlone(lstCampaign)); return converted; } }
/// <summary> /// Created By :: Sakthivel.R /// Created On :: 30-3-2015 /// Comments :: Select all records for Campaign details based on campaignid. /// </summary> public List<Campaign> CampaignSelectbasedonid(int Campaignid) { objEmailCampDataContext = new EmailCampDataContext(); lstCampaign = new List<Campaign>(); var Select = (from cde in objEmailCampDataContext.spCampaign_AllActions(Campaignid, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, "s") select cde).ToList(); if (Select.Count > 0) { lstCampaign = new List<Campaign>(); foreach (var item in Select) { objCampaign = new Campaign(); objCampaign.CampaignName = Convert.ToString(item.CampaignName); objCampaign.CampTimezone = Convert.ToString(item.CampTimezone); objCampaign.CreatedBy = item.CreatedBy; objCampaign.CreatedOn = item.CreatedOn; objCampaign.UpdatedBy = item.UpdatedBy; objCampaign.UpdatedOn = item.UpdatedOn; objCampaign.Emailid = item.Emailid; objCampaign.FK_UserID = item.FK_UserID; objCampaign.CampaignStatus = item.CampaignStatus; objCampaign.CampTimezone = item.CampTimezone; objCampaign.FromName = item.FromName; objCampaign.PK_CampaignID = item.PK_CampaignID; objCampaign.SchduleDateTime = item.SchduleDateTime; objCampaign.Title = item.Title; objCampaign.Utctime = item.utctime; objCampaign.mailcontent = item.mailcontent; lstCampaign.Add(objCampaign); } } objEmailCampDataContext = null; objCampaign = null; return lstCampaign; }