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); } }