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