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