/// <summary>
/// Created By :: Sakthivel.R
/// Created On :: 24-9-2015
/// Comments :: Select all records for Campaign details based on uertype and companyid.
/// </summary>
#region Select_MailCount
public string SelectMailCount(int companyid, DateTime ActiveFrom, DateTime ActiveTo)
{
objEmailCampDataContext = new EmailCampDataContext();
long?totrow = 0;
var Select = (from cde in objEmailCampDataContext.spCampaignQueue_AllActions(companyid, null, null, null, null, null, null, null, null, null, null, ActiveFrom, null, ActiveTo, null, ref totrow, "e")
select cde).ToList();
return(totrow.ToString());
}
/// <summary>
/// Created By :: Sakthivel.R
/// Created On :: 30-3-2015
/// Comments :: Select all records for CampaignQueue details based on CampaignQueueid.
/// </summary>
public List <CampaignQueue> CampaignQueueSelectbasedonid(int CampaignQueueid)
{
objEmailCampDataContext = new EmailCampDataContext();
lstCampaignQueue = new List <CampaignQueue>();
var Select = (from cde in objEmailCampDataContext.spCampaignQueue_AllActions(CampaignQueueid, null, null, null, null, null, null, null, null, null, null, null, null, null, null, ref val, "s")
select cde).ToList();
if (Select.Count > 0)
{
lstCampaignQueue = new List <CampaignQueue>();
foreach (var item in Select)
{
objCampaignQueue = new CampaignQueue();
objCampaignQueue.PK_CampaignQueueID = item.PK_CampaignQueueID;
if (item.FK_CampaignID != null)
{
objCampaignQueue.FK_CampaignID = Convert.ToInt32(item.FK_CampaignID);
}
objCampaignQueue.SentOn = item.SentOn;
objCampaignQueue.MailFailedContent = item.MailFailedContent;
objCampaignQueue.IsMailSent = item.IsMailSent;
objCampaignQueue.IsBounced = item.isBounced;
objCampaignQueue.Isdelivered = item.Isdelivered;
objCampaignQueue.IsHardBounce = item.IsHardBounce;
objCampaignQueue.IsRead = item.IsRead;
if (item.ReadCount != null)
{
objCampaignQueue.ReadCount = Convert.ToByte(item.ReadCount.ToString());
}
if (item.FK_ContactID != null)
{
objCampaignQueue.FK_ContactID = Convert.ToInt32(item.FK_ContactID);
}
objCampaignQueue.CreatedBy = item.CreatedBy;
objCampaignQueue.CreatedOn = item.CreatedOn;
objCampaignQueue.UpdatedBy = item.UpdatedBy;
objCampaignQueue.UpdatedOn = item.UpdatedOn;
lstCampaignQueue.Add(objCampaignQueue);
}
}
objEmailCampDataContext = null;
objCampaignQueue = null;
return(lstCampaignQueue);
}
/// <summary>
/// Created By :: Sakthivel.R
/// Created On :: 30-3-2015
/// Comments :: Updation function of CampaignQueue details.
/// </summary>
#region Delete_CampaignQueueCreation
public void CampaignQueueDelete(int CampaignQueueid)
{
try
{
objEmailCampDataContext = new EmailCampDataContext();
var Delete = (from cde in objEmailCampDataContext.spCampaignQueue_AllActions(CampaignQueueid, null, null, null, null, null, null, null, null, null, null, null, null, null, null, ref val, "d")
select cde).ToList();
Delete = null;
objCampaignQueue = null;
objEmailCampDataContext = null;
}
catch (Exception ex)
{
ex.ToString();
}
}
/// <summary>
/// Created By :: Sakthivel.R
/// Created On :: 30-3-2015
/// Comments :: Updation function of CampaignQueue details.
/// </summary>
#region Update_CampaignQueueCreation
public void CampaignQueueUpdate(CampaignQueue objCampaignQueue)
{
try
{
objEmailCampDataContext = new EmailCampDataContext();
var Update = (from cde in objEmailCampDataContext.spCampaignQueue_AllActions(objCampaignQueue.PK_CampaignQueueID, objCampaignQueue.FK_CampaignID, objCampaignQueue.SentOn, objCampaignQueue.MailFailedContent, objCampaignQueue.IsMailSent, objCampaignQueue.IsBounced, objCampaignQueue.Isdelivered, objCampaignQueue.IsHardBounce, objCampaignQueue.IsRead, objCampaignQueue.ReadCount, objCampaignQueue.CreatedBy, objCampaignQueue.CreatedOn, objCampaignQueue.UpdatedBy, objCampaignQueue.UpdatedOn, objCampaignQueue.FK_ContactID, ref val, "u")
select cde).ToList();
Update = null;
objCampaignQueue = null;
objEmailCampDataContext = null;
}
catch (Exception ex)
{
ex.ToString();
}
}
/// <summary>
/// Created By :: Sakthivel.R
/// Created On :: 27-5-2015
/// Comments :: Insertion function of CampaignQueue details.
/// </summary>
#region Insert_CampaignQueueCreation
public string CampaignQueueInsert(CampaignQueue objCampaignQueue)
{
try
{
objEmailCampDataContext = new EmailCampDataContext();
long?totrow = 0;
var Insert = (from cde in objEmailCampDataContext.spCampaignQueue_AllActions(objCampaignQueue.PK_CampaignQueueID, objCampaignQueue.FK_CampaignID, objCampaignQueue.SentOn, objCampaignQueue.MailFailedContent, objCampaignQueue.IsMailSent, objCampaignQueue.IsBounced, objCampaignQueue.Isdelivered, objCampaignQueue.IsHardBounce, objCampaignQueue.IsRead, objCampaignQueue.ReadCount, objCampaignQueue.CreatedBy, objCampaignQueue.CreatedOn, objCampaignQueue.UpdatedBy, objCampaignQueue.UpdatedOn, objCampaignQueue.FK_ContactID, ref totrow, "i")
select cde).ToList();
//totrow = (int)objEmailCampDataContext.spCampaignQueue_AllActions(objCampaignQueue.PK_CampaignQueueID, objCampaignQueue.FK_CampaignID, objCampaignQueue.SentOn, objCampaignQueue.MailFailedContent, objCampaignQueue.IsMailSent, objCampaignQueue.IsBounced, objCampaignQueue.Isdelivered, objCampaignQueue.IsHardBounce, objCampaignQueue.IsRead, objCampaignQueue.ReadCount, objCampaignQueue.CreatedBy, objCampaignQueue.CreatedOn, objCampaignQueue.UpdatedBy, objCampaignQueue.UpdatedOn, objCampaignQueue.FK_ContactID, ref val, "i").ReturnValue;
Insert = null;
objEmailCampDataContext = null;
return(totrow.ToString());
}
catch (Exception ex)
{
ex.ToString();
return(null);
}
}