private void sendReceipt()
{
var message = new StringBuilder();
email.RenderControl(new HtmlTextWriter(new StringWriter(message)));
string s = message.ToString();
EmailAlert alerter = new EmailAlert();
alerter.sendEmail(GenericQuery.getUserEmail(User.Identity.Name), "Web Shop Receipt", s);
}
protected void Page_Load(object sender, EventArgs e)
{
EmailAlert instance = new EmailAlert();
bool test = instance.sendEmail("*****@*****.**", "Very Important thing", "DO IT NOW");
if (test == true)
{
ShowPopUpMsg("True");
}
else
{
ShowPopUpMsg("False");
}
}
protected void EnableButton_Click(object sender, EventArgs e)
{
MembershipUser user = Membership.GetUser(UserName.Text.Trim());
if (user != null)
{
user.IsApproved = true;
Membership.UpdateUser(user);
string connectionString = "AsiaWebShopDBConnectionString";
string query = "UPDATE [Member]"+ "SET [active]="+ 1 +"WHERE ([username] =N'" + UserName.Text.Trim() + "')";
// Create the connection and the SQL command.
using (SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings[connectionString].ConnectionString))
using (SqlCommand command = new SqlCommand(query, connection))
{
// Open the connection, execute the INSERT query and close the connection.
command.Connection.Open();
command.ExecuteNonQuery();
command.Connection.Close();
}
MemberGridView.DataBind();
using (SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["AsiaWebShopDBConnectionString"].ConnectionString))
{
// start to connect sql server
connection.Open();
Int32 count = 0;
int emailSentNum = 0;
do
{
SqlCommand command = new SqlCommand("SELECT COUNT(*) FROM [WishListItem] WHERE (([userName]= N'" + UserName.Text.Trim() + "') AND ([emailSent] = N'" + false + "') AND ([isAlert] = N'" + true + "') AND ([userName] in (SELECT userName FROM [member] WHERE [active] = N'" + true + "')))", connection);
count = (Int32)command.ExecuteScalar();
if (count != 0)
{
SqlCommand test = new SqlCommand("SELECT upc FROM [WishListItem] WHERE (([userName]= N'" + UserName.Text.Trim() + "') AND ([emailSent] = N'" + false + "') AND ([isAlert] = N'" + true + "') AND ([userName] in (SELECT userName FROM [member] WHERE [active] = N'" + true + "')))", connection);
String upcNum = test.ExecuteScalar().ToString().Trim();
SqlCommand name = new SqlCommand("SELECT name FROM [Item] WHERE (([upc] = N'" + upcNum + "'))", connection);
String itemName = name.ExecuteScalar().ToString().Trim();
SqlCommand userEmail = new SqlCommand("SELECT email FROM [member] WHERE (([userName] = N'" + UserName.Text.Trim() + "'))", connection);
String email = userEmail.ExecuteScalar().ToString().Trim();
EmailAlert instance = new EmailAlert();
bool isEmailSent = instance.sendEmail(email, itemName + " is now availiable. Come to AisaWebShop.", "Dear customer " + UserName.Text.Trim() + ":\n\n "
+ itemName + " is now on stock. Visit our website and You will find products you want are all in our shop.\n\nBest wishes, \nASiaWebShop");
if (isEmailSent == true)
{
SqlCommand alertEmailSent = new SqlCommand("UPDATE [WishListItem] SET [isAlert]=N'" + false + "', [emailSent]= N'" + true + "' WHERE (([upc] = N'" + upcNum + "') AND ([userName] = N'" + UserName.Text.Trim() + "'))", connection);
alertEmailSent.ExecuteScalar();
emailSentNum++;
}
else
{
ShowPopUpMsg("Email can't be sent");
}
}
} while (count != 0);
if (emailSentNum != 0)
ShowPopUpMsg(emailSentNum + " email(s) are sent");
connection.Close();
}
}
}
protected bool sendEmail(string upc)
{
using (SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["AsiaWebShopDBConnectionString"].ConnectionString))
{
// start to connect sql server
connection.Open();
Int32 count = 0;
int emailSentNum = 0;
do
{
SqlCommand command = new SqlCommand("SELECT COUNT(*) FROM [WishListItem] WHERE (([upc] = N'" + upc + "') AND ([emailSent] = N'" + false + "') AND ([isAlert] = N'" + true + "') AND ([userName] in (SELECT userName FROM [member] WHERE [active] = N'" + true + "')))", connection);
count = (Int32)command.ExecuteScalar();
if (count != 0)
{
SqlCommand test = new SqlCommand("SELECT userName FROM [WishListItem] WHERE (([upc] = N'" + upc + "') AND ([emailSent] = N'" + false + "') AND ([isAlert] = N'" + true + "') AND ([userName] in (SELECT userName FROM [member] WHERE [active] = N'" + true + "')))", connection);
String customerName = test.ExecuteScalar().ToString().Trim();
SqlCommand name = new SqlCommand("SELECT name FROM [Item] WHERE (([upc] = N'" + upc + "'))", connection);
String itemName = name.ExecuteScalar().ToString().Trim();
SqlCommand userEmail = new SqlCommand("SELECT email FROM [member] WHERE (([userName] = N'" + customerName + "'))", connection);
String email = userEmail.ExecuteScalar().ToString().Trim();
EmailAlert instance = new EmailAlert();
bool isEmailSent = instance.sendEmail(email, itemName + " is now availiable. Come to AisaWebShop.", "Dear customer " + customerName + ":\n\n "
+ itemName + " is now on stock. Visit our website and You will find products you want are all in our shop.\n\nBest wishes, \nASiaWebShop");
if (isEmailSent == true)
{
SqlCommand alertEmailSent = new SqlCommand("UPDATE [WishListItem] SET [isAlert]= N'" + false + "', [emailSent]= N'" + true + "' WHERE (([upc] = N'" + upc + "') AND ([userName] = N'" + customerName + "'))", connection);
alertEmailSent.ExecuteScalar();
emailSentNum++;
}
else
{
ShowPopUpMsg("Email can't be sent");
}
}
} while (count != 0);
if (emailSentNum != 0)
ShowPopUpMsg(emailSentNum + " email(s) are sent");
connection.Close();
}
return true;
}