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