/// <summary>
/// detete row from emailqueue
/// </summary>
/// <param name="emailQueue"></param>
public void DeletedFromEmailQueue(EmailQueue emailQueue)
{
try
{
db.EmailQueue.Remove(emailQueue);
db.SaveChanges();
}
catch (Exception ex)
{
MethodBase site = MethodBase.GetCurrentMethod();
string url = "";// HttpContext.Current.Request.Url.AbsoluteUri;// request.Url.AbsoluteUri;
exceptionLogsRepositery.InsertException(ex, url, site.Name);
}
}
/// <summary>
/// Get top email detail from email queue
/// </summary>
/// <returns></returns>
public EmailQueue GetTopEmailQueueDetail()
{
try
{
emailQueue = db.EmailQueue.Take(1).FirstOrDefault();
db.SaveChanges();
}
catch (Exception ex)
{
MethodBase site = MethodBase.GetCurrentMethod();
string url = "";// HttpContext.Current.Request.Url.AbsoluteUri;// request.Url.AbsoluteUri;
exceptionLogsRepositery.InsertException(ex, url, site.Name);
}
return(emailQueue);
}
/// <summary>
/// insrement tries in emailqueue
/// </summary>
/// <param name="emailQueue"></param>
public void IncrementTries(EmailQueue emailQueue)
{
try
{
EmailQueue nEmailQueue = db.EmailQueue.Where(x => x.Id == emailQueue.Id).FirstOrDefault();
nEmailQueue.Tries++;
db.SaveChanges();
}
catch (Exception ex)
{
MethodBase site = MethodBase.GetCurrentMethod();
string url = "";// HttpContext.Current.Request.Url.AbsoluteUri;// request.Url.AbsoluteUri;
exceptionLogsRepositery.InsertException(ex, url, site.Name);
}
}
/// <summary>
/// update isdeleted to true in email queue
/// </summary>
/// <param name="emailQueue"></param>
public void UpdateIsDeletedTrue(EmailQueue emailQueue)
{
try
{
nEmailQueue = db.EmailQueue.Where(x => x.Id == emailQueue.Id).FirstOrDefault();
if (nEmailQueue != null)
{
nEmailQueue.IsDeleted = true;
db.SaveChanges();
}
}
catch (Exception ex)
{
MethodBase site = MethodBase.GetCurrentMethod();
string url = "";// HttpContext.Current.Request.Url.AbsoluteUri;// request.Url.AbsoluteUri;
exceptionLogsRepositery.InsertException(ex, url, site.Name);
}
}
// //insert into emailqueue table
/// </summary>
/// <param name="from"></param>
/// <param name="to"></param>
/// <param name="subject"></param>
/// <param name="body"></param>
public void InsertEmailDeatailsInEmailQueue(string from, string to, string subject, string body)
{
try
{
EmailQueue NewemailQueue = new EmailQueue();
NewemailQueue.FromAddress = from;
NewemailQueue.ToAddress = to;
NewemailQueue.Subject = subject;
NewemailQueue.Body = body;
NewemailQueue.CreatedOn = DateTime.Now;
NewemailQueue.ModifiedOn = DateTime.Now;
db.EmailQueue.Add(NewemailQueue);
db.SaveChanges();
}
catch (Exception ex)
{
MethodBase site = MethodBase.GetCurrentMethod();
string url = "";// HttpContext.Current.Request.Url.AbsoluteUri;// request.Url.AbsoluteUri;
exceptionLogsRepositery.InsertException(ex, url, site.Name);
}
}
/// <summary>
/// read tries from emailqueue
/// </summary>
/// <param name="emailQueue"></param>
/// <returns>no of tries</returns>
public int GetTries(EmailQueue emailQueue)
{
EmailQueue nEmailQueue = new EmailQueue();
try
{
nEmailQueue = db.EmailQueue.Where(x => x.Id == emailQueue.Id).FirstOrDefault();
db.SaveChanges();
}
catch (Exception ex)
{
MethodBase site = MethodBase.GetCurrentMethod();
string url = "";// HttpContext.Current.Request.Url.AbsoluteUri;// request.Url.AbsoluteUri;
exceptionLogsRepositery.InsertException(ex, url, site.Name);
}
if (nEmailQueue != null)
{
return(nEmailQueue.Tries);
}
return(0);
}
