public WebinarAudience getWebinarAudience(int webinarID)
{
WebinarAudience objWebinarAudience = new WebinarAudience();
try
{
using (MySqlConnection sqlCon = new MySqlConnection(Constant.EBirdConnectionString))
{
using (MySqlCommand sqlCmd = new MySqlCommand(DBQuery.sqlWebinarAudiSelect, sqlCon))
{
sqlCon.Open();
sqlCmd.CommandType = CommandType.Text;
sqlCmd.Parameters.Add(new MySqlParameter("@webinarID", webinarID));
MySqlDataReader reader = sqlCmd.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
objWebinarAudience.WebinarID = webinarID;
objWebinarAudience.AudienceViewBgColor = reader["audiBgColor"] == DBNull.Value ? string.Empty : Convert.ToString(reader["audiBgColor"]);
objWebinarAudience.AudienceViewBgImageID = reader["audiBgImageID"] == DBNull.Value ? -1 : Convert.ToInt32(reader["audiBgImageID"]);
objWebinarAudience.AudienceViewBackground = reader["audiBackGround"] == DBNull.Value ? string.Empty : Convert.ToString(reader["audiBackGround"]);
objWebinarAudience.Email = reader["Email"] == DBNull.Value ? 0 : Convert.ToInt32(reader["Email"]);
objWebinarAudience.Chat = reader["Chat"] == DBNull.Value ? 0 : Convert.ToInt32(reader["Chat"]);
objWebinarAudience.Content = reader["Content"] == DBNull.Value ? 0 : Convert.ToInt32(reader["Content"]);
objWebinarAudience.Download = reader["Download"] == DBNull.Value ? 0 : Convert.ToInt32(reader["Download"]);
objWebinarAudience.FaceBook = reader["FaceBook"] == DBNull.Value ? 0 : Convert.ToInt32(reader["FaceBook"]);
objWebinarAudience.LinkedIn = reader["LinkedIn"] == DBNull.Value ? 0 : Convert.ToInt32(reader["LinkedIn"]);
objWebinarAudience.Search = reader["Search"] == DBNull.Value ? 0 : Convert.ToInt32(reader["Search"]);
objWebinarAudience.SpeakerBio = reader["SpeakerBio"] == DBNull.Value ? 0 : Convert.ToInt32(reader["SpeakerBio"]);
objWebinarAudience.SubmitQuestion = reader["SubmitQuestion"] == DBNull.Value ? 0 : Convert.ToInt32(reader["SubmitQuestion"]);
objWebinarAudience.Twitter = reader["Twitter"] == DBNull.Value ? 0 : Convert.ToInt32(reader["Twitter"]);
objWebinarAudience.Video = reader["Video"] == DBNull.Value ? 0 : Convert.ToInt32(reader["Video"]);
objWebinarAudience.Wiki = reader["Wiki"] == DBNull.Value ? 0 : Convert.ToInt32(reader["Wiki"]);
}
}
reader.Close();
reader = null;
}
sqlCon.Close();
}
}
catch (Exception ex)
{
throw;
}
return objWebinarAudience;
}
public void SaveWebinarAudience(WebinarAudience objWebinarAudience)
{
try
{
using (MySqlConnection sqlCon = new MySqlConnection(Constant.EBirdConnectionString))
{
MySqlCommand sqlCmd = new MySqlCommand(DBQuery.sqlWebinarAudiComponentUpdate, sqlCon);
sqlCon.Open();
sqlCmd.CommandType = CommandType.Text;
sqlCmd.Parameters.Add(new MySqlParameter("@audiBackGround", objWebinarAudience.AudienceViewBackground));
sqlCmd.Parameters.Add(new MySqlParameter("@Download", objWebinarAudience.Download));
sqlCmd.Parameters.Add(new MySqlParameter("@chat", objWebinarAudience.Chat));
sqlCmd.Parameters.Add(new MySqlParameter("@submitQuestion", objWebinarAudience.SubmitQuestion));
sqlCmd.Parameters.Add(new MySqlParameter("@Wiki", objWebinarAudience.Wiki));
sqlCmd.Parameters.Add(new MySqlParameter("@Email", objWebinarAudience.Email));
sqlCmd.Parameters.Add(new MySqlParameter("@webinarID", objWebinarAudience.WebinarID));
sqlCmd.ExecuteNonQuery();
}
}
catch (Exception ex)
{
throw;
}
}
public void saveAudienceComponent()
{
WebinarAudience objWebinarAudience = new WebinarAudience();
if (hSelBgID.Value != "")
objWebinarAudience.AudienceViewBackground = hSelBgID.Value;
else
objWebinarAudience.AudienceViewBackground = "None";
objWebinarAudience.Download = getCheckFeatureID(Convert.ToInt32(ClientConfigMaster.Audi_Component_Download_Slides));
objWebinarAudience.Chat = getCheckFeatureID(Convert.ToInt32(ClientConfigMaster.Audi_Component_Group_Chat));
objWebinarAudience.SubmitQuestion = getCheckFeatureID(Convert.ToInt32(ClientConfigMaster.Audi_Component_Submit_Question));
objWebinarAudience.Wiki = getCheckFeatureID(Convert.ToInt32(ClientConfigMaster.Audi_Component_Wikipedia));
objWebinarAudience.Email = getCheckFeatureID(Convert.ToInt32(ClientConfigMaster.Audi_Component_EmailFriend));
objWebinarAudience.WebinarID = Convert.ToInt32(hWebinarID.Value);
objWebinarDA.SaveWebinarAudience(objWebinarAudience);
getAudBackGround1();
}