protected void btnReferCollegue_Click(object sender, EventArgs e) { List<WebinarReferCollegue> objRef = objWebinarDA.GetWebinarReferedCollegueDetail(Convert.ToInt32(hWebinarID.Value), txtCEmail.Text.Trim(), txtEmail.Text.Trim()); if (objRef.Count > 0) { dvRAFForm.Visible = false; dvRefExist.Visible = true; TemplateMgmt objTemplateMgmt = new TemplateMgmt(); ltrRefExist.Text = objTemplateMgmt.GetReferedCollegueExist(objRef[0].EmailedOn, objRef[0].ReferInitiatedIP, Constant.DocTemplate + "referExist.tpl"); } else { WebinarReferCollegue objRefData = new WebinarReferCollegue(); objRefData.RefererFirstName = txtFName.Text.Trim(); objRefData.RefererLastName = txtLName.Text.Trim(); objRefData.RefererEmail = txtEmail.Text.Trim(); objRefData.CollegueFirstName = txtCFName.Text.Trim(); objRefData.CollegueLastName = txtCLName.Text.Trim(); objRefData.CollegueEmail = txtCEmail.Text.Trim(); objRefData.WebinarID = Convert.ToInt32(hWebinarID.Value); objRefData.ReferInitiatedIP = Request.UserHostAddress; int eventRefID = objWebinarDA.SaveWebinarReferCollegue(objRefData); phRegFormColleague.Visible = false; if (hphReg.Value == "1") phAll.Visible = true; else phOpt1.Visible = true; //btnRefCol1.Visible = true; //TemplateMgmt objTemplateMgmt = new TemplateMgmt(); //ltrRefConf.Text = objTemplateMgmt.GetReferedCollegueConfirm(Constant.DocTemplate + "refConfirm.tpl"); } }
public int SaveWebinarReferCollegue(WebinarReferCollegue objRefData) { int webEventRefID = 0; try { using (MySqlConnection sqlCon = new MySqlConnection(Constant.EBirdConnectionString)) { MySqlCommand sqlCmd = new MySqlCommand(DBQuery.sqlInsertReferColleque, sqlCon); sqlCon.Open(); sqlCmd.CommandType = CommandType.Text; sqlCmd.Parameters.Add(new MySqlParameter("@webinarID", objRefData.WebinarID)); sqlCmd.Parameters.Add(new MySqlParameter("@colleaguefirstname", objRefData.CollegueFirstName)); sqlCmd.Parameters.Add(new MySqlParameter("@colleaguelastname", objRefData.CollegueLastName)); sqlCmd.Parameters.Add(new MySqlParameter("@colleagueemailID", objRefData.CollegueEmail)); sqlCmd.Parameters.Add(new MySqlParameter("@refererfirstname", objRefData.RefererFirstName)); sqlCmd.Parameters.Add(new MySqlParameter("@refererlastname", objRefData.RefererLastName)); sqlCmd.Parameters.Add(new MySqlParameter("@refereremailID", objRefData.RefererEmail)); sqlCmd.Parameters.Add(new MySqlParameter("@referInitiatedIP", objRefData.ReferInitiatedIP)); sqlCmd.ExecuteNonQuery(); sqlCmd = new MySqlCommand("SELECT LAST_INSERT_ID()", sqlCon); sqlCmd.CommandType = CommandType.Text; MySqlDataReader reader = sqlCmd.ExecuteReader(); if (reader.HasRows) { reader.Read(); webEventRefID = Convert.ToInt32(reader.GetValue(0)); } reader.Close(); reader = null; sqlCon.Close(); } } catch (Exception ex) { throw; } return webEventRefID; }