public DataSet CampaignReportSelectforgridBasedonFilter(string uertype, int companyid, string CampName, string Title, Nullable <DateTime> CreatedOn, string all)
{
objEmailCampDataContext = new EmailCampDataContext();
lstCampaignreport = new List <campaignreport>();
var Select = (from cde in objEmailCampDataContext.spCampaign_AllActions(null, companyid, CampName, Title, null, null, null, null, all, null, CreatedOn, null, null, null, null, null, null, null, uertype)
select cde).ToList();
if (Select.Count > 0)
{
lstCampaignreport = new List <campaignreport>();
foreach (var item in Select)
{
objcampaignreport = new campaignreport();
objcampaignreport.CampaignName = Convert.ToString(item.CampaignName);
objcampaignreport.CampTimezone = Convert.ToString(item.CampTimezone);
objcampaignreport.CreatedBy = item.CreatedBy;
objcampaignreport.CreatedOn = item.CreatedOn;
objcampaignreport.UpdatedBy = item.UpdatedBy;
objcampaignreport.UpdatedOn = item.UpdatedOn;
objcampaignreport.Emailid = item.Emailid;
objcampaignreport.FK_UserID = item.FK_UserID;
objcampaignreport.FromName = item.FromName;
objcampaignreport.PK_CampaignID = item.PK_CampaignID;
objcampaignreport.SchduleDateTime = item.SchduleDateTime;
objcampaignreport.Title = item.Title;
objcampaignreport.Utctime = item.utctime;
objcampaignreport.CampaignStatus = item.CampaignStatus;
objcampaignreport.mailcontent = item.mailcontent;
objcampaignreport.Subscribers = item.Subscribers;
objcampaignreport.mailsent = item.mailsent;
objcampaignreport.SentOn = item.SentOn;
lstCampaignreport.Add(objcampaignreport);
}
}
objEmailCampDataContext = null;
objcampaignreport = null;
DataSet converted = new DataSet();
if (lstCampaignreport.Count > 0)
{
converted.Tables.Add(ListToDataSet.newTable(lstCampaignreport));
return(converted);
}
else
{
converted.Tables.Add(ListToDataSet.newTableColumnAlone(lstCampaignreport));
return(converted);
}
}
/// <summary>
/// Created By :: Sakthivel.R
/// Created On :: 30-3-2015
/// Comments :: Select all records for Campaign details based on uertype and companyid.
/// </summary>
#region Select_All_Records_CreateCampaign
public DataSet CampaignSelectforgrid(string uertype, Nullable <int> companyid, Nullable <int> userid, string alpha)
{
objEmailCampDataContext = new EmailCampDataContext();
lstCampaign = new List <Campaign>();
var Select = (from cde in objEmailCampDataContext.spCampaign_AllActions(null, userid, null, null, null, null, null, null, alpha, companyid, null, 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 :: Updation function of Campaign details.
/// </summary>
#region Delete_CampaignCreation
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();
}
}
/// <summary>
/// Created By :: Sakthivel.R
/// Created On :: 30-3-2015
/// Comments :: Updation function of Campaign details.
/// </summary>
#region Update_CampaignCreation
public void CampaignUpdate(Campaign objCampaign)
{
try
{
objEmailCampDataContext = new EmailCampDataContext();
var Update = (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, "u")
select cde).ToList();
Update = null;
objCampaign = null;
objEmailCampDataContext = null;
}
catch (Exception ex)
{
ex.ToString();
}
}
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();
}
}
/// <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);
}
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 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 DataSet CampaignReportSelectforgrid(string uertype, int userid, string alpha)
{
objEmailCampDataContext = new EmailCampDataContext();
lstCampaignreport = new List<campaignreport>();
var Select = (from cde in objEmailCampDataContext.spCampaign_AllActions(null, userid, null, null, null, null, null, null, alpha, null, null, null, null, null, null, null, null, null, uertype)
select cde).ToList();
if (Select.Count > 0)
{
lstCampaignreport = new List<campaignreport>();
foreach (var item in Select)
{
objcampaignreport = new campaignreport();
objcampaignreport.CampaignName = Convert.ToString(item.CampaignName);
objcampaignreport.CampTimezone = Convert.ToString(item.CampTimezone);
objcampaignreport.CreatedBy = item.CreatedBy;
objcampaignreport.CreatedOn = item.CreatedOn;
objcampaignreport.UpdatedBy = item.UpdatedBy;
objcampaignreport.UpdatedOn = item.UpdatedOn;
objcampaignreport.Emailid = item.Emailid;
objcampaignreport.FK_UserID = item.FK_UserID;
objcampaignreport.FromName = item.FromName;
objcampaignreport.PK_CampaignID = item.PK_CampaignID;
objcampaignreport.SchduleDateTime = item.SchduleDateTime;
objcampaignreport.Title = item.Title;
objcampaignreport.Utctime = item.utctime;
objcampaignreport.CampaignStatus = item.CampaignStatus;
objcampaignreport.mailcontent = item.mailcontent;
objcampaignreport.Subscribers = item.Subscribers;
objcampaignreport.mailsent = item.mailsent;
objcampaignreport.SentOn = item.SentOn;
lstCampaignreport.Add(objcampaignreport);
}
}
objEmailCampDataContext = null;
objcampaignreport = null;
DataSet converted = new DataSet();
if (lstCampaignreport.Count > 0)
{
converted.Tables.Add(ListToDataSet.newTable(lstCampaignreport));
return converted;
}
else
{
converted.Tables.Add(ListToDataSet.newTableColumnAlone(lstCampaignreport));
return converted;
}
}
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;
}