private void setNotificationDefaults(int webinarID) { #region email contents WebinarNotification objWebNotify = new WebinarNotification(); objWebNotify.WebinarID = webinarID; objWebNotify.isConfirmEmailAllReg = true; objWebNotify.RegConfirmEmailContentID = Convert.ToInt32(Constant.RegConfirmContentID); objWebNotify.ReminderEmailContentID = Convert.ToInt32(Constant.ReminderContentID); objWebNotify.FollowupAEmailContentID = Convert.ToInt32(Constant.AttendeeFollowUpContentID); objWebNotify.FollowupNAEmailContentID = Convert.ToInt32(Constant.NonAttendeeFollowUpContentID); objWebNotify.InvitationContentID = Convert.ToInt32(Constant.InvitationContentID); objWebinarDA.SaveWebinarNotificationDefault(objWebNotify); #endregion #region Registrant Updates EmailDA objEmailDA = new EmailDA(); RegistrantUpdateBO objRegistrantUpdateBO = new RegistrantUpdateBO(); objRegistrantUpdateBO.WebinarID = webinarID; objRegistrantUpdateBO.IsRegularUpdate = true; objRegistrantUpdateBO.IsUpdateWhenRegister = true; objRegistrantUpdateBO.UpdateTime = "08:00:00"; objRegistrantUpdateBO.updateToEmails = Session["EmailID"].ToString(); objRegistrantUpdateBO.UpdateWeekday = 2; objEmailDA.SaveRegistrantUpdate(objRegistrantUpdateBO); #endregion // Reminder email setting RegistrantEmailSettingBO objEmailSetting = new RegistrantEmailSettingBO(); #region Hour reminder objEmailSetting.intervalType = "H"; objEmailSetting.intervalValue = 2; objEmailSetting.EmailScheduleStatus = "Draft"; objEmailSetting.SettingType = "Reminder Email"; objEmailSetting.setID = 0; objEmailSetting.webinarID = webinarID; objEmailDA.SaveRegistrantEmailSetting(objEmailSetting); #endregion #region Day reminder objEmailSetting.intervalType = "D"; objEmailSetting.intervalValue = 2; objEmailSetting.EmailScheduleStatus = "Draft"; objEmailSetting.SettingType = "Reminder Email"; objEmailSetting.setID = 0; objEmailSetting.webinarID = webinarID; objEmailDA.SaveRegistrantEmailSetting(objEmailSetting); #endregion #region Week reminder objEmailSetting.intervalType = "W"; objEmailSetting.intervalValue = 1; objEmailSetting.EmailScheduleStatus = "Draft"; objEmailSetting.SettingType = "Reminder Email"; objEmailSetting.setID = 0; objEmailSetting.webinarID = webinarID; objEmailDA.SaveRegistrantEmailSetting(objEmailSetting); #endregion #region Follow-up - Attendees objEmailSetting.intervalType = "D"; objEmailSetting.intervalValue = 2; objEmailSetting.EmailScheduleStatus = "Draft"; objEmailSetting.SettingType = "Follow-up Email - Attended"; objEmailSetting.setID = 0; objEmailSetting.webinarID = webinarID; objEmailDA.SaveRegistrantEmailSetting(objEmailSetting); #endregion #region Follow-up - Non-Attendees objEmailSetting.intervalType = "D"; objEmailSetting.intervalValue = 2; objEmailSetting.EmailScheduleStatus = "Draft"; objEmailSetting.SettingType = "Follow-up Email - Unattended"; objEmailSetting.setID = 0; objEmailSetting.webinarID = webinarID; objEmailDA.SaveRegistrantEmailSetting(objEmailSetting); #endregion }
public void SaveWebinarNotificationDefault(WebinarNotification objWebNotify) { try { using (MySqlConnection sqlCon = new MySqlConnection(Constant.EBirdConnectionString)) { MySqlCommand sqlCmd = new MySqlCommand(DBQuery.sqlWebinarNotifyDefaultInsert, sqlCon); sqlCon.Open(); sqlCmd.CommandType = CommandType.Text; sqlCmd.Parameters.Add(new MySqlParameter("@webinarID", objWebNotify.WebinarID)); sqlCmd.Parameters.Add(new MySqlParameter("@isConfirmEmailAllReg", objWebNotify.isConfirmEmailAllReg)); sqlCmd.Parameters.Add(new MySqlParameter("@RegConfirmEmailContentID", objWebNotify.RegConfirmEmailContentID)); sqlCmd.Parameters.Add(new MySqlParameter("@ReminderEmailContentID", objWebNotify.ReminderEmailContentID)); sqlCmd.Parameters.Add(new MySqlParameter("@FollowupAEmailContentID", objWebNotify.FollowupAEmailContentID)); sqlCmd.Parameters.Add(new MySqlParameter("@FollowupNAEmailContentID", objWebNotify.FollowupAEmailContentID)); sqlCmd.Parameters.Add(new MySqlParameter("@invitationContentID", objWebNotify.RegConfirmEmailContentID)); //sqlCmd.Parameters.Add(new MySqlParameter("RegConfirmEmailContentID", objWebNotify.RegConfirmEmailContentID)); //sqlCmd.Parameters.Add(new MySqlParameter("ReminderEmailHour", objWebNotify.ReminderEmailHour)); //sqlCmd.Parameters.Add(new MySqlParameter("ReminderEmailDay", objWebNotify.ReminderEmailDay)); //sqlCmd.Parameters.Add(new MySqlParameter("ReminderEmailWeek", objWebNotify.ReminderEmailWeek)); //sqlCmd.Parameters.Add(new MySqlParameter("ReminderEmailContentID", objWebNotify.ReminderEmailContentID)); //sqlCmd.Parameters.Add(new MySqlParameter("RegListEmailOn", objWebNotify.RegListEmailOn)); //sqlCmd.Parameters.Add(new MySqlParameter("isEmailNewReg", objWebNotify.isEmailNewReg)); //sqlCmd.Parameters.Add(new MySqlParameter("UpdateSendToEmail", objWebNotify.UpdateSendToEmail)); //sqlCmd.Parameters.Add(new MySqlParameter("FollowupAttendee", objWebNotify.FollowupAttendee)); //sqlCmd.Parameters.Add(new MySqlParameter("FollowupAEmailContentID", objWebNotify.FollowupAEmailContentID)); //sqlCmd.Parameters.Add(new MySqlParameter("FollowupNonAttendee", objWebNotify.FollowupNonAttendee)); //sqlCmd.Parameters.Add(new MySqlParameter("FollowupNAEmailContentID", objWebNotify.FollowupNAEmailContentID)); sqlCmd.ExecuteNonQuery(); sqlCon.Close(); } } catch (Exception ex) { throw; } }