public int AddPresenter(PresenterBE objPreBE)
{
int presenterID = 0;
try
{
using (MySqlConnection sqlCon = new MySqlConnection(Constant.EBirdConnectionString))
{
{
using (MySqlCommand sqlCmd = new MySqlCommand(DBQuery.sqlPresenterInsert, sqlCon))
{
sqlCmd.CommandType = CommandType.Text;
sqlCmd.Parameters.Add(new MySqlParameter("@userID", objPreBE.UserID));
sqlCmd.Parameters.Add(new MySqlParameter("@presenterName", objPreBE.PresenterName));
sqlCmd.Parameters.Add(new MySqlParameter("@title", objPreBE.Title));
sqlCmd.Parameters.Add(new MySqlParameter("@organization", objPreBE.Organization));
sqlCmd.Parameters.Add(new MySqlParameter("@presenterBio", objPreBE.Bio));
sqlCmd.Parameters.Add(new MySqlParameter("@imgDocID", objPreBE.ImageDocID));
sqlCmd.Parameters.Add(new MySqlParameter("@isExternal", objPreBE.isExternal));
sqlCmd.Connection = sqlCon;
sqlCmd.Connection.Open();
sqlCmd.ExecuteNonQuery();
sqlCmd.Connection.Close();
}
}
}
}
catch (Exception ex)
{
throw ex;
}
return presenterID;
}
protected void btnSave_Click(object sender, EventArgs e)
{
UserBE objUserBE = new UserBE();
objUserBE.FirstName = txtFName.Text.Trim();
objUserBE.LastName = txtLName.Text.Trim();
objUserBE.Telephone = txtTelephone.Text.Trim();
objUserBE.Department = txtDepartment.Text.Trim();
objUserBE.JobTitle = txtJobTitle.Text.Trim();
objUserBE.UserID = Convert.ToInt32(Session["UserID"]);
objUserDA.UpdateUserProfileRecord(objUserBE);
PresenterBE objPreBE = new PresenterBE();
txtPresenterName.Text = txtFName.Text.Trim() + " " + txtLName.Text.Trim();
txtPresenterTitle.Text = txtJobTitle.Text.Trim();
objPreBE.PresenterName = txtPresenterName.Text.Trim();
objPreBE.Title = txtPresenterTitle.Text.Trim();
objPreBE.Organization = txtPreOrgName.Text.Trim();
objPreBE.Bio = redtBio.Text;
objPreBE.UserID = Convert.ToInt32(Session["UserID"]);
objWebinarDA.UpdatePresenterDetail(objPreBE);
}
protected void btnSave_Click(object sender, EventArgs e)
{
PresenterBE objPreBE = new PresenterBE();
lblError.Text = "";
if (rcmbPresenter.Text != "")
{
if (btnSave.Text == "Add to webinar")
{
objWebDA.UpdateAdditionalPresenter(Convert.ToInt32(rcmbPresenter.SelectedValue), Convert.ToInt32(hWebinarID.Value));
}
else
{
objPreBE.PresenterID = Convert.ToInt32(hPresenterID.Value);
objPreBE.PresenterName = rcmbPresenter.Text.Trim();
objPreBE.Title = txtPresenterTitle.Text.Trim();
objPreBE.Organization = txtPreOrgName.Text.Trim();
objPreBE.Bio = redtBio.Text;
objPreBE.UserID = 0;
int presenterID = objWebDA.UpdatePresenterDetail(objPreBE, Convert.ToInt32(hWebinarID.Value));
if (presenterID != 0)
{
dvProfileImg.Visible = true;
hPresenterID.Value = presenterID.ToString();
hProfileImgID.Value = "0";
dvToggle();
}
else
lblError.Text = "Presenter already exist";
}
if (lblError.Text == "")
{
hPresenterID.Value = "0";
refreshNav2Tab2();
}
}
//hModalStatusFlg.Value = "1";
//if (!ClientScript.IsStartupScriptRegistered("alert")) { Page.ClientScript.RegisterStartupScript(this.GetType(), "alert", "CloseAndReload();", true); }
}
public int UpdatePresenterDetail(PresenterBE objPreBE, int webinarID)
{
int rtnVal = 0;
try
{
using (MySqlConnection sqlCon = new MySqlConnection(Constant.EBirdConnectionString))
{
{
using (MySqlCommand sqlCmd = new MySqlCommand("spUpdatePresenterInfo", sqlCon))
{
sqlCmd.CommandType = CommandType.StoredProcedure;
sqlCmd.Parameters.Add(new MySqlParameter("pPresenterID", objPreBE.PresenterID));
sqlCmd.Parameters.Add(new MySqlParameter("pPresenterName", objPreBE.PresenterName));
sqlCmd.Parameters.Add(new MySqlParameter("pTitle", objPreBE.Title));
sqlCmd.Parameters.Add(new MySqlParameter("pOrganization", objPreBE.Organization));
sqlCmd.Parameters.Add(new MySqlParameter("pPresenterBio", objPreBE.Bio));
sqlCmd.Parameters.Add(new MySqlParameter("pUserID", objPreBE.UserID));
sqlCmd.Parameters.Add(new MySqlParameter("pWebinarID", webinarID));
sqlCmd.Connection = sqlCon;
sqlCmd.Connection.Open();
//sqlCmd.ExecuteNonQuery();
MySqlDataReader reader = sqlCmd.ExecuteReader();
if (reader.HasRows)
{
reader.Read();
rtnVal = Convert.ToInt32(reader[0]);
}
reader.Close();
reader = null;
sqlCmd.Connection.Close();
}
}
}
}
catch (Exception ex)
{
throw ex;
}
return rtnVal;
}
public void UpdatePresenterDetail(PresenterBE objPreBE)
{
try
{
string sql1 = string.Empty;
List<PresenterBE> objP1 = GetPresenterDetail(objPreBE.UserID);
if (objP1.Count > 0)
sql1 = DBQuery.sqlUserPresenterUpdate;
else
sql1 = DBQuery.sqlUserPresenterInsert;
using (MySqlConnection sqlCon = new MySqlConnection(Constant.EBirdConnectionString))
{
{
using (MySqlCommand sqlCmd = new MySqlCommand(sql1, sqlCon))
{
sqlCmd.CommandType = CommandType.Text;
sqlCmd.Parameters.Add(new MySqlParameter("@presenterName", objPreBE.PresenterName));
sqlCmd.Parameters.Add(new MySqlParameter("@title", objPreBE.Title));
sqlCmd.Parameters.Add(new MySqlParameter("@organization", objPreBE.Organization));
sqlCmd.Parameters.Add(new MySqlParameter("@presenterBio", objPreBE.Bio));
sqlCmd.Parameters.Add(new MySqlParameter("@userID", objPreBE.UserID));
sqlCmd.Connection = sqlCon;
sqlCmd.Connection.Open();
sqlCmd.ExecuteNonQuery();
sqlCmd.Connection.Close();
}
}
}
}
catch (Exception ex)
{
throw ex;
}
}
