public int SaveWeibarScheduleAs(WebinarBE objWebinarBE)
{
int webinarID = 0;
try
{
using (MySqlConnection sqlCon = new MySqlConnection(Constant.EBirdConnectionString))
{
MySqlCommand sqlCmd = new MySqlCommand("spSaveWebinarAs", sqlCon);
sqlCon.Open();
sqlCmd.CommandType = CommandType.StoredProcedure;
sqlCmd.Parameters.Add(new MySqlParameter("pWebinarTitle", objWebinarBE.Title));
sqlCmd.Parameters.Add(new MySqlParameter("pDescription", objWebinarBE.Description));
sqlCmd.Parameters.Add(new MySqlParameter("pWebinarID", objWebinarBE.WebinarID));
sqlCmd.Parameters.Add(new MySqlParameter("pStartDate", objWebinarBE.StartDate.ToString("yyyy-MM-dd")));
sqlCmd.Parameters.Add(new MySqlParameter("pStartTime", Convert.ToDateTime(objWebinarBE.StartTime).ToString("HH:mm:ss")));
sqlCmd.Parameters.Add(new MySqlParameter("pEndTime", Convert.ToDateTime(objWebinarBE.EndTime).ToString("HH:mm:ss")));
sqlCmd.Parameters.Add(new MySqlParameter("pCreatedBy", objWebinarBE.Createdby));
sqlCmd.Parameters.Add(new MySqlParameter("pTimeZoneID", objWebinarBE.TimeZoneID));
MySqlDataReader reader = sqlCmd.ExecuteReader();
if (reader.HasRows)
{
reader.Read();
webinarID = reader["WebinarID"] == DBNull.Value ? 0 : Convert.ToInt32(reader["WebinarID"]);
}
reader.Close();
reader = null;
if (webinarID != 0)
SaveWebinarURLs(webinarID);
}
}
catch (Exception ex)
{
throw;
}
return webinarID;
}
/* Public Webinar */
private void popPublishWebinars()
{
List<WebinarBE> objWebinarBE = new List<WebinarBE>();
//if (Session["Role"].ToString() == "Admin")
// objWebinarBE = objWebinarDA.GetMyCompanyRecycleWebinarListDA(Convert.ToInt32(Session["ClientID"]));
//else
objWebinarBE = objSnapSiteDA.GetMyPublicWebinarListDA(Convert.ToInt32(Session["UserID"]));
tgrdWebinarList.DataSource = objWebinarBE;
tgrdWebinarList.DataBind();
if (objWebinarBE.Count > 0)
btnPublish.Enabled = true;
else
btnPublish.Enabled = false;
}
public int SaveWebinarSchedule(WebinarBE objWebinarBE, WebinarRecurrencyBE objWebRecurrenceBE, string UpdateToEmails)
{
int webinarID = objWebinarBE.WebinarID;
string sql1 = "";
bool isNew = true;
if (webinarID == 0)
sql1 = "spAddNewWebinar";
else
{
sql1 = "spUpdateWebinar";
isNew = false;
}
try
{
using (MySqlConnection sqlCon = new MySqlConnection(Constant.EBirdConnectionString))
{
MySqlCommand sqlCmd = new MySqlCommand(sql1, sqlCon);
sqlCon.Open();
sqlCmd.CommandType = CommandType.StoredProcedure;
sqlCmd.Parameters.Add(new MySqlParameter("pWebinarTitle", objWebinarBE.Title));
sqlCmd.Parameters.Add(new MySqlParameter("pDescription", objWebinarBE.Description));
sqlCmd.Parameters.Add(new MySqlParameter("pStartDate", objWebinarBE.StartDate.ToString("yyyy-MM-dd")));
sqlCmd.Parameters.Add(new MySqlParameter("pStartTime", Convert.ToDateTime(objWebinarBE.StartTime).ToString("HH:mm:ss")));
sqlCmd.Parameters.Add(new MySqlParameter("pEndTime", Convert.ToDateTime(objWebinarBE.EndTime).ToString("HH:mm:ss")));
sqlCmd.Parameters.Add(new MySqlParameter("pRecurrence", objWebinarBE.isRecurrence));
sqlCmd.Parameters.Add(new MySqlParameter("pTimeZoneID", objWebinarBE.TimeZoneID));
sqlCmd.Parameters.Add(new MySqlParameter("pDeliveryChannel", objWebinarBE.DeliveryChannel));
sqlCmd.Parameters.Add(new MySqlParameter("pIsPublic", objWebinarBE.isPublic));
sqlCmd.Parameters.Add(new MySqlParameter("pIsPassRequired", objWebinarBE.isPasswordRequired));
sqlCmd.Parameters.Add(new MySqlParameter("pWebinarPassword", objWebinarBE.WebinarPassword));
sqlCmd.Parameters.Add(new MySqlParameter("pUpdateToEmails", UpdateToEmails));
if (webinarID == 0)
{
sqlCmd.Parameters.Add(new MySqlParameter("pCreatedBy", objWebinarBE.Createdby));
}
else
{
sqlCmd.Parameters.Add(new MySqlParameter("pModifiedBy", objWebinarBE.Modifiedby));
sqlCmd.Parameters.Add(new MySqlParameter("pWebinarID", objWebinarBE.WebinarID));
}
sqlCmd.Parameters.Add(new MySqlParameter("pRecurrType", objWebRecurrenceBE.recurrType));
sqlCmd.Parameters.Add(new MySqlParameter("pEndType", objWebRecurrenceBE.endType));
sqlCmd.Parameters.Add(new MySqlParameter("pEndValue", objWebRecurrenceBE.endValue));
sqlCmd.Parameters.Add(new MySqlParameter("pRecurrCriteria", objWebRecurrenceBE.recurrCriteria));
MySqlDataReader reader = sqlCmd.ExecuteReader();
if (reader.HasRows)
{
reader.Read();
webinarID = reader["WebinarID"] == DBNull.Value ? 0 : Convert.ToInt32(reader["WebinarID"]);
}
reader.Close();
reader = null;
if (isNew)
{
SaveWebinarURLs(webinarID);
}
}
}
catch (Exception ex)
{
throw;
}
return webinarID;
}
protected void btnSaveWebinar_Click(object sender, EventArgs e)
{
lblWebSaveAsError.Text = "";
if ((Convert.ToDateTime(rdtStartDate1.SelectedDate) - DateTime.Now).Days < 0)
{
lblWebSaveAsError.Text = "Cannot schedule webinar in the past";
}
else if ((Convert.ToDateTime(rdtStartDate1.SelectedDate) - DateTime.Now).Days == 0)
{
UserDA objUserDA = new UserDA();
float tm = objUserDA.getTimezoneToServerTimeDiff(Convert.ToInt32(ddlTimeZone.SelectedValue));
DateTime currentClientPreferDateTime = DateTime.Now.AddHours(-tm);
if ((Convert.ToDateTime(rdtStartTime.SelectedDate) - Convert.ToDateTime(currentClientPreferDateTime)).Minutes < 0)
lblWebSaveAsError.Text = "Cannot schedule webinar past the current time";
}
if (lblWebSaveAsError.Text == "")
{
if (objWebinarDA.IsWebinarOverlapping(objUtil.FormDBDate(Convert.ToDateTime(rdtStartDate1.SelectedDate)), rdtStartTime.SelectedDate.ToString(), rdEndTime.SelectedDate.ToString(), Convert.ToInt32(Session["UserID"]), Convert.ToInt32(hWebinarID.Value)))
{
lblWebSaveAsError.Text = objError.getMessage("WB0008");
}
else
{
WebinarBE objWebinarBE = new WebinarBE();
objWebinarBE.WebinarID = Convert.ToInt32(hWebinarID.Value);
objWebinarBE.Createdby = Convert.ToInt32(Session["UserID"]);
objWebinarBE.Title = txtWebinarTitle.Text;
//objWebinarBE.Description = txtDescription.Text;
objWebinarBE.Description = redtSummary1.Content;
objWebinarBE.StartDate = Convert.ToDateTime(rdtStartDate1.SelectedDate);
objWebinarBE.StartTime = Convert.ToDateTime(rdtStartTime.SelectedDate).ToString("HH:mm:ss");
objWebinarBE.EndTime = Convert.ToDateTime(rdEndTime.SelectedDate).ToString("HH:mm:ss");
objWebinarBE.TimeZoneID = Convert.ToInt32(ddlTimeZone.SelectedValue);
objWebinarDA.SaveWeibarScheduleAs(objWebinarBE);
Response.Redirect("~/Pages/Webinar");
}
}
}
