public void Approve() { DataSet ds; DataSet ds1; Models.TicketingEventsNew _Events = null; int EventID = Convert.ToInt32(Request.QueryString["ID"]); if (EventID > 0) { ds = new Musika.Repository.SPRepository.SpRepository().ShiftDatetoOriginalTables(EventID); GenericRepository <TicketingEventsNew> _EventsRepo = new GenericRepository <TicketingEventsNew>(_unitOfWork); _Events = _EventsRepo.Repository.GetById(EventID); bool tourdata = new Musika.Repository.SPRepository.SpRepository().SpUpdateTourData(_Events.ArtistId, _Events.VenueName, _Events.StartDate, _Events.EventTitle, _Events.EventID); // if (ds.Tables[0].Rows.Count > 0) // { ds1 = new Musika.Repository.SPRepository.SpRepository().SpGetTicketingEventUsersToSendEmail(EventID); if (ds1.Tables[0].Rows.Count > 0) { DataRow dr = ds1.Tables[0].Rows[0]; ltMessage.Text = "Event Approved successfully."; string html = string.Empty; string Email = dr["Email"].ToString(); html = "<p>Hi " + dr["UserName"].ToString() + "," + " </p>"; html += "<p>Your Event Changes Has been approved by Admin." + "</p>"; html += "<p><br>You can view your changes in your panel" + "<p>"; // html += "<p><br>User Name : " + dr["UserName"].ToString() + "<p>"; html += "<p><br><br><strong>Thanks,<br><br>The " + WebConfigurationManager.AppSettings["AppName"] + " Team</strong></p>"; SendEmailHelper.SendMail(Email, "Event Changes Approved", html, ""); } // } else { ltMessage.Text = "Invalid Activation code."; } } }
protected void Page_Load(object sender, EventArgs e) { DataSet ds; if (!this.IsPostBack) { string activationCode = !string.IsNullOrEmpty(Request.QueryString["ActivationCode"]) ? Request.QueryString["ActivationCode"] : Guid.Empty.ToString(); ds = new Musika.Repository.SPRepository.SpRepository().UpdateUserActivationStatus(activationCode); if (ds.Tables[0].Rows.Count > 0) { DataRow dr = ds.Tables[0].Rows[0]; ltMessage.Text = "Activation successful."; #region "Mail for Activation" #region "Mail To Admin" // Mail To admin string html = string.Empty; html = "<p>Hi Administrator," + "</p>"; html += "<p>A new user is added in Musika application." + "</p>"; html += "<p><br>The details of the user is as follows :" + "<p>"; html += "<p><br>User Name : " + dr["UserName"].ToString() + "<p>"; html += "<p><br><br><strong>Thanks,<br><br>The " + WebConfigurationManager.AppSettings["AppName"] + " Team</strong></p>"; SendEmailHelper.SendMail(System.Configuration.ConfigurationManager.AppSettings["ADMIN_EMAIL"].ToString(), "New Musika User Registration", html, ""); #endregion //#region "Mail To Event Organizer" //// Mail To admin string AdminEmail = System.Configuration.ConfigurationManager.AppSettings["ADMIN_EMAIL"].ToString(); html = string.Empty; html = "<p>Hi " + dr["Email"].ToString() + "," + "</p>"; html += "<p>Thanks for using " + WebConfigurationManager.AppSettings["AppName"] + "! </p>"; html += "<p>Thanks for Registering on Musika Application." + "</p>"; html += "<p><br>As per registration your details are as follows :" + "<p>"; html += "<p><br>User Name : " + dr["UserName"].ToString() + "<p>"; html += "<p><br><br><strong>Thanks,<br><br>The " + WebConfigurationManager.AppSettings["AppName"] + " Team</strong></p>"; //#region "Send Mail Implementation" SendEmailHelper.SendMail(dr["Email"].ToString(), "New Musika User Registration", html, ""); //#endregion #endregion } else { ltMessage.Text = "Invalid Activation code."; } #region "Unused Code" //string constr = @"Data Source=23.111.138.246,2728; Initial Catalog=Musika;App=Musika; User ID=sa; Password=sdsol99!;"; //string activationCode = !string.IsNullOrEmpty(Request.QueryString["ActivationCode"]) ? Request.QueryString["ActivationCode"] : Guid.Empty.ToString(); //using (SqlConnection con = new SqlConnection(constr)) //{ // using (SqlCommand cmd = new SqlCommand("DELETE FROM UserActivation WHERE ActivationCode = @ActivationCode")) // { // using (SqlDataAdapter sda = new SqlDataAdapter()) // { // cmd.CommandType = CommandType.Text; // cmd.Parameters.AddWithValue("@ActivationCode", activationCode); // cmd.Connection = con; // con.Open(); // int rowsAffected = cmd.ExecuteNonQuery(); // con.Close(); // } // } //} #endregion } }