/// <summary> /// Created By :: Sakthivel.R /// Created On :: 2-6-2015 /// Comments :: Delete function of ScheduleMailDetails details. /// </summary> #region Delete_ScheduleMailDetailsCreation public void ScheduleMailDetailsDelete(int ScheduleMailDetailsid) { try { objEmailCampDataContext = new EmailCampDataContext(); var Delete = (from cde in objEmailCampDataContext.spScheduleMailDetails_AllActions(ScheduleMailDetailsid, null, null, null, null, null, null, null, null, null, "d") select cde).ToList(); Delete = null; objScheduleMailDetails = null; objEmailCampDataContext = null; } catch (Exception ex) { ex.ToString(); } }
/// <summary> /// Created By :: Sakthivel.R /// Created On :: 2-6-2015 /// Comments :: Updation function of ScheduleMailDetails details. /// </summary> #region Update_ScheduleMailDetailsCreation public void ScheduleMailDetailsUpdate(ScheduleMailDetails objScheduleMailDetails) { try { objEmailCampDataContext = new EmailCampDataContext(); var Update = (from cde in objEmailCampDataContext.spScheduleMailDetails_AllActions(objScheduleMailDetails.PK_ScheduleID, objScheduleMailDetails.FK_ContactID, objScheduleMailDetails.Scheduledatetime, objScheduleMailDetails.FK_Scheduleby, objScheduleMailDetails.QueueStatus, objScheduleMailDetails.CreatedBy, objScheduleMailDetails.CreatedOn, objScheduleMailDetails.UpdatedBy, objScheduleMailDetails.UpdatedOn, objScheduleMailDetails.FK_CampaignID, "u") select cde).ToList(); Update = null; objScheduleMailDetails = null; objEmailCampDataContext = null; } catch (Exception ex) { ex.ToString(); } }
public void ScheduleMailDetailsInsert(ScheduleMailDetails objScheduleMailDetails) { try { objEmailCampDataContext = new EmailCampDataContext(); var Insert = (from cde in objEmailCampDataContext.spScheduleMailDetails_AllActions(objScheduleMailDetails.PK_ScheduleID, objScheduleMailDetails.FK_ContactID, objScheduleMailDetails.Scheduledatetime, objScheduleMailDetails.FK_Scheduleby, objScheduleMailDetails.QueueStatus, objScheduleMailDetails.CreatedBy, objScheduleMailDetails.CreatedOn, objScheduleMailDetails.UpdatedBy, objScheduleMailDetails.UpdatedOn, objScheduleMailDetails.FK_CampaignID, "i") select cde).ToList(); Insert = null; objScheduleMailDetails = null; objEmailCampDataContext = null; } catch (Exception ex) { ex.ToString(); } }
public void ScheduleMailDetailsDelete(int ScheduleMailDetailsid) { try { objEmailCampDataContext = new EmailCampDataContext(); var Delete = (from cde in objEmailCampDataContext.spScheduleMailDetails_AllActions(ScheduleMailDetailsid, null, null, null, null, null, null, null, null, null, "d") select cde).ToList(); Delete = null; objScheduleMailDetails = null; objEmailCampDataContext = null; } catch (Exception ex) { ex.ToString(); } }
/// <summary> /// Created By :: Sakthivel.R /// Created On :: 30-3-2015 /// Comments :: Select all records for ScheduleMailDetails details based on uertype and companyid. /// </summary> //#region Select_All_Records_CreateScheduleMailDetails //public List<ScheduleMailDetails> ScheduleMailDetailsbasedoncampid(int campid) //{ // objEmailCampDataContext = new EmailCampDataContext(); // lstScheduleMailDetails = new List<ScheduleMailDetails>(); // var Select = (from cde in objEmailCampDataContext.spScheduleMailDetails_AllActions(null, campid, null, null, null, null, null, null, null, null, "a") // select cde).ToList(); // if (Select.Count > 0) // { // lstScheduleMailDetails = new List<ScheduleMailDetails>(); // foreach (var item in Select) // { // objScheduleMailDetails = new ScheduleMailDetails(); // objScheduleMailDetails.PK_ScheduleMailDetailsID = item.PK_ScheduleMailDetailsID; // if (item.FK_CampaignID != null) // objScheduleMailDetails.FK_CampaignID = Convert.ToInt32(item.FK_CampaignID); // objScheduleMailDetails.SentOn = item.SentOn; // objScheduleMailDetails.MailFailedContent = item.MailFailedContent; // objScheduleMailDetails.IsMailSent = item.IsMailSent; // objScheduleMailDetails.IsBounced = item.isBounced; // objScheduleMailDetails.Isdelivered = item.Isdelivered; // objScheduleMailDetails.IsHardBounce = item.IsHardBounce; // objScheduleMailDetails.IsRead = item.IsRead; // if (item.ReadCount != null) // objScheduleMailDetails.ReadCount = Convert.ToByte(item.ReadCount.ToString()); // if (item.FK_ContactID != null) // objScheduleMailDetails.FK_ContactID = Convert.ToInt32(item.FK_ContactID); // objScheduleMailDetails.CreatedBy = item.CreatedBy; // objScheduleMailDetails.CreatedOn = item.CreatedOn; // objScheduleMailDetails.UpdatedBy = item.UpdatedBy; // objScheduleMailDetails.UpdatedOn = item.UpdatedOn; // lstScheduleMailDetails.Add(objScheduleMailDetails); // } // } // objEmailCampDataContext = null; // objScheduleMailDetails = null; // return lstScheduleMailDetails; //} //#endregion /// <summary> /// Created By :: Sakthivel.R /// Created On :: 30-5-2015 /// Comments :: Select all records for ScheduleMailDetails details based on contactid. /// </summary> #region Select_All_Records_CreateScheduleMailDetails //public List<ScheduleMailDetails> ScheduleMailDetailsbasedoncontactid(int contactid) //{ // objEmailCampDataContext = new EmailCampDataContext(); // lstScheduleMailDetails = new List<ScheduleMailDetails>(); // var Select = (from cde in objEmailCampDataContext.spScheduleMailDetails_AllActions(null, null, null, null, null, null, null, null, null, null, null, null, null, null, contactid, "c") // select cde).ToList(); // if (Select.Count > 0) // { // lstScheduleMailDetails = new List<ScheduleMailDetails>(); // foreach (var item in Select) // { // objScheduleMailDetails = new ScheduleMailDetails(); // objScheduleMailDetails.PK_ScheduleMailDetailsID = item.PK_ScheduleMailDetailsID; // if (item.FK_CampaignID != null) // objScheduleMailDetails.FK_CampaignID = Convert.ToInt32(item.FK_CampaignID); // objScheduleMailDetails.SentOn = item.SentOn; // objScheduleMailDetails.MailFailedContent = item.MailFailedContent; // objScheduleMailDetails.IsMailSent = item.IsMailSent; // objScheduleMailDetails.IsBounced = item.isBounced; // objScheduleMailDetails.Isdelivered = item.Isdelivered; // objScheduleMailDetails.IsHardBounce = item.IsHardBounce; // objScheduleMailDetails.IsRead = item.IsRead; // if (item.ReadCount != null) // objScheduleMailDetails.ReadCount = Convert.ToByte(item.ReadCount.ToString()); // if (item.FK_ContactID != null) // objScheduleMailDetails.FK_ContactID = Convert.ToInt32(item.FK_ContactID); // objScheduleMailDetails.CreatedBy = item.CreatedBy; // objScheduleMailDetails.CreatedOn = item.CreatedOn; // objScheduleMailDetails.UpdatedBy = item.UpdatedBy; // objScheduleMailDetails.UpdatedOn = item.UpdatedOn; // lstScheduleMailDetails.Add(objScheduleMailDetails); // } // } // objEmailCampDataContext = null; // objScheduleMailDetails = null; // return lstScheduleMailDetails; //} #endregion /// <summary> /// Created By :: Sakthivel.R /// Created On :: 30-3-2015 /// Comments :: Select all records for ScheduleMailDetails details based on ScheduleMailDetailsid. /// </summary> public List <ScheduleMailDetails> ScheduleMailDetailsSelectbasedonid(int ScheduleMailDetailsid) { objEmailCampDataContext = new EmailCampDataContext(); lstScheduleMailDetails = new List <ScheduleMailDetails>(); var Select = (from cde in objEmailCampDataContext.spScheduleMailDetails_AllActions(ScheduleMailDetailsid, null, null, null, null, null, null, null, null, null, "s") select cde).ToList(); if (Select.Count > 0) { lstScheduleMailDetails = new List <ScheduleMailDetails>(); foreach (var item in Select) { objScheduleMailDetails = new ScheduleMailDetails(); objScheduleMailDetails.PK_ScheduleID = item.PK_ScheduleID; if (item.FK_CampaignID != null) { objScheduleMailDetails.FK_CampaignID = Convert.ToInt32(item.FK_CampaignID); } objScheduleMailDetails.Scheduledatetime = item.scheduledatetime; if (item.FK_Scheduleby != null) { objScheduleMailDetails.FK_Scheduleby = Convert.ToInt32(item.FK_Scheduleby); } objScheduleMailDetails.QueueStatus = item.QueueStatus; if (item.FK_ContactID != null) { objScheduleMailDetails.FK_ContactID = Convert.ToInt32(item.FK_ContactID); } objScheduleMailDetails.CreatedBy = item.CreatedBy; objScheduleMailDetails.CreatedOn = item.CreatedOn; objScheduleMailDetails.UpdatedBy = item.UpdatedBy; objScheduleMailDetails.UpdatedOn = item.UpdatedOn; lstScheduleMailDetails.Add(objScheduleMailDetails); } } objEmailCampDataContext = null; objScheduleMailDetails = null; return(lstScheduleMailDetails); }
/// <summary> /// Created By :: Sakthivel.R /// Created On :: 30-3-2015 /// Comments :: Select all records for ScheduleMailDetails details based on ScheduleMailDetailsid. /// </summary> public List<ScheduleMailDetails> ScheduleMailDetailsSelectbasedonid(int ScheduleMailDetailsid) { objEmailCampDataContext = new EmailCampDataContext(); lstScheduleMailDetails = new List<ScheduleMailDetails>(); var Select = (from cde in objEmailCampDataContext.spScheduleMailDetails_AllActions(ScheduleMailDetailsid, null, null, null, null, null, null, null, null, null, "s") select cde).ToList(); if (Select.Count > 0) { lstScheduleMailDetails = new List<ScheduleMailDetails>(); foreach (var item in Select) { objScheduleMailDetails = new ScheduleMailDetails(); objScheduleMailDetails.PK_ScheduleID = item.PK_ScheduleID; if (item.FK_CampaignID != null) objScheduleMailDetails.FK_CampaignID = Convert.ToInt32(item.FK_CampaignID); objScheduleMailDetails.Scheduledatetime = item.scheduledatetime; if (item.FK_Scheduleby != null) objScheduleMailDetails.FK_Scheduleby = Convert.ToInt32(item.FK_Scheduleby); objScheduleMailDetails.QueueStatus = item.QueueStatus; if (item.FK_ContactID != null) objScheduleMailDetails.FK_ContactID = Convert.ToInt32(item.FK_ContactID); objScheduleMailDetails.CreatedBy = item.CreatedBy; objScheduleMailDetails.CreatedOn = item.CreatedOn; objScheduleMailDetails.UpdatedBy = item.UpdatedBy; objScheduleMailDetails.UpdatedOn = item.UpdatedOn; lstScheduleMailDetails.Add(objScheduleMailDetails); } } objEmailCampDataContext = null; objScheduleMailDetails = null; return lstScheduleMailDetails; }