예제 #1
0
 private void sendconfirmation(Esubscribtion sub)
 {
     EmailContent cnt = new EmailContent();
     cnt.Subject = $"Welcome {sub.FirstName} {sub.LastName}";
     cnt.To = sub.Email;
     cnt.message = $"Welcome {sub.FirstName} {sub.LastName}! You have successfully subscribed! You will recieve a notification every time the admin posts a new game. Sorry, no way to unsubscribe yet..:P";
     EmailManager mngr = new EmailManager();
     mngr.SendNotification(cnt);
 }
예제 #2
0
        public int AddEsubscribtion(Esubscribtion sub)
        {

            SqlConnection Con = new SqlConnection(_connectionstring);
            SqlCommand cmd = Con.CreateCommand();
            cmd.CommandText = @"insert into Enotification
                                Values(@FN,@LN,@email)
                                select SCOPE_IDENTITY()";
            cmd.Parameters.AddWithValue("@Fn", sub.FirstName);
            cmd.Parameters.AddWithValue("@LN", sub.LastName);
            cmd.Parameters.AddWithValue("@Email", sub.Email);
            Con.Open();
            int SI = (int)(decimal)cmd.ExecuteScalar();
            sendconfirmation(sub);
            return SI;
        }