public virtual BirthdayMessageLog CreateBirthdayMessageLogFromReader(IDataReader reader)
{
BirthdayMessageLog item = new BirthdayMessageLog();
try
{
if (!reader.IsDBNull(reader.GetOrdinal("BirthdayMessageDay"))) item.BirthdayMessageDay = (string)reader["BirthdayMessageDay"];
if (!reader.IsDBNull(reader.GetOrdinal("ProccessYN"))) item.ProccessYN = (string)reader["ProccessYN"];
}
catch (Exception ex)
{
// log this exception
log4net.Util.LogLog.Error(ex.Message, ex);
// wrap it and rethrow
throw new ApplicationException(SR.DataAccessCreateBirthdayMessageLogFromReaderException, ex);
}
return item;
}
public static void UpdateBirthdayMessageLog(BirthdayMessageLog birthdayMessageLog)
{
try
{
BirthdayMessageLogDAO birthdayMessageLogDAO = new BirthdayMessageLogDAO();
birthdayMessageLogDAO.UpdateBirthdayMessageLog(birthdayMessageLog);
}
catch (ApplicationException)
{
throw;
}
catch (Exception ex)
{
// log this exception
log4net.Util.LogLog.Error(ex.Message, ex);
// wrap it and rethrow
throw new ApplicationException(SR.BusinessUpdateBirthdayMessageLogException, ex);
}
}
public virtual void UpdateBirthdayMessageLog(BirthdayMessageLog birthdayMessageLog)
{
try
{
Database database = DatabaseFactory.CreateDatabase("CustommerServiceConnection");
DbCommand dbCommand = database.GetStoredProcCommand("spBirthdayMessageLogUpdate");
database.AddInParameter(dbCommand, "@BirthdayMessageDay", DbType.String, birthdayMessageLog.BirthdayMessageDay);
database.AddInParameter(dbCommand, "@ProccessYN", DbType.String, birthdayMessageLog.ProccessYN);
database.ExecuteNonQuery(dbCommand);
}
catch (Exception ex)
{
// log this exception
log4net.Util.LogLog.Error(ex.Message, ex);
// wrap it and rethrow
throw new ApplicationException(SR.DataAccessUpdateBirthdayMessageLogException, ex);
}
}
public static void SendBirthdaySmsMessage(Int32 birthdaySmsMessageTemplateId)
{
ContentTemplate contentTemplate = null;
if (DateTime.Now.Hour < 8 && DateTime.Now.Hour > 17) return;
if (BirthdayMessageLogService.GetBirthdayMessageLog(DateTime.Now.Year.ToString() + DateTime.Now.Month.ToString().PadLeft(2, '0') + DateTime.Now.Day.ToString().PadLeft(2, '0')) != null) return;
CustomerCollection customerCollection = CustomerService.GetCustomerListByBirthDay();
contentTemplate = ContentTemplateService.GetContentTemplate(birthdaySmsMessageTemplateId);
if (contentTemplate != null)
{
foreach (Customer cust in customerCollection)
{
MessageContent messageContent = null;
messageContent = new MessageContent();
messageContent.Sender = contentTemplate.Sender;
messageContent.Receiver = cust.Mobile;
messageContent.Subject = contentTemplate.Subject;
messageContent.BodyContentType = contentTemplate.BodyContentType;
messageContent.BodyEncoding = contentTemplate.BodyEncoding;
messageContent.BodyMessage = contentTemplate.BodyMessage;
messageContent.ContentTemplateID = contentTemplate.ContentTemplateID;
messageContent.ServiceTypeID = contentTemplate.ServiceTypeID;
messageContent.ModifiedDate = DateTime.Now;
messageContent.CreatedDate = DateTime.Now;
messageContent.Status = 0;
MessageContentService.CreateMessageContent(messageContent);
}
BirthdayMessageLog birthdayMessageLog = new BirthdayMessageLog();
birthdayMessageLog.BirthdayMessageDay = DateTime.Now.Year.ToString() + DateTime.Now.Month.ToString().PadLeft(2,'0') + DateTime.Now.Day.ToString().PadLeft(2,'0');;
birthdayMessageLog.ProccessYN = "Y";
BirthdayMessageLogService.CreateBirthdayMessageLog(birthdayMessageLog);
}
}
