protected void btnConfirm_Click(object sender, EventArgs e)
{
var info = new CustomerInfo();
info.Items = d.Items;
info.City = string.Format("{0} {1}", txtCity.Text, txtCity0.Text);
info.Address = string.Format("{0} {1}", txtAddres1.Text, txtAddres2.Text);
info.Name = string.Format("{0} {1}", txtFirstName.Text, txtLastName.Text);
info.State = txtState.Text;
info.Telephone = txtTelephone.Text;
info.Zip = txtPostcode.Text;
info.email = txtEmail.Text;
info.CCNumber = long.Parse(txtCreditCard.Text);
info.CCType = ddlCreditType.SelectedValue;
info.ExpDate = string.Format("{0}/{1}", DropDownList2.SelectedValue, DropDownList3.SelectedValue);
info.CardVerNum = int.Parse(txtCardVer.Text);
MembershipSystemContext cont = new MembershipSystemContext();
Order newOrder = new Order { Date = DateTime.Now, ProductInfo = info.setProductInfo(), Prices = d.ShoppingCartTotal.ToString(), UserId = (int?)HttpContext.Current.Session["UserId"] };
cont.Orders.Add(newOrder);
cont.SaveChanges();
var id = newOrder.OrderId;
MailMessage message = new MailMessage();
message.To.Add(info.email);
message.From = new MailAddress("*****@*****.**");
message.Subject = "Your order has been processed";
message.Body = info.getEmailContent(id);
SmtpClient smtp = new SmtpClient("localhost");
smtp.Send(message);
message.Body = info.getEmailContent(id);
Response.Redirect(@"/OrderConfirmation.aspx");
}
protected void btnAddProduct_Click(object sender, EventArgs e)
{
MembershipSystemContext dbContext = new MembershipSystemContext();
Product d = new Product { Name = txtName.Text, Details = txtDetails.Text, Price = decimal.Parse(txtPrice.Text) };
dbContext.Products.Add(d);
dbContext.SaveChanges();
ClearPageTextboxes();
}
public User getUserByuserName(string userName)
{
User returnedUser = null;
using (cont = new MembershipSystemContext())
{
returnedUser = (from a in cont.Users
where a.UserName == userName
select a).FirstOrDefault();
}
return returnedUser;
}
public User getUserByEmail(string email)
{
User returnedUser = null;
using (cont = new MembershipSystemContext())
{
returnedUser = (from a in cont.Users
where a.Email == email
select a).FirstOrDefault();
}
return returnedUser;
}
private object CreateDataSource()
{
DataTable dt = new DataTable();
DataRow dr;
MembershipSystemContext DBConn = new MembershipSystemContext();
IEnumerable<Product> Products = DBConn.Products.ToList<Product>();
// Define the columns of the table.
dt.Columns.Add(new DataColumn("ProductId", typeof(Int32)));
dt.Columns.Add(new DataColumn("Name", typeof(String)));
dt.Columns.Add(new DataColumn("Details", typeof(String)));
dt.Columns.Add(new DataColumn("AmtVoted", typeof(Int32)));
dt.Columns.Add(new DataColumn("Price", typeof(decimal)));
dt.Columns.Add(new DataColumn("Score", typeof(Int32)));
dt.Columns.Add(new DataColumn("Rating", typeof(decimal)));
// Populate the table with sample values.
foreach (Product x in Products)
{
dr = dt.NewRow();
dr[0] = x.ProductId;
dr[1] = x.Name;
dr[2] = x.Details;
dr[3] = x.AmtVoted;
dr[4] = x.Price;
dr[5] = x.Score;
dr[6] = x.Rating;
dt.Rows.Add(dr);
}
DataView dv = new DataView(dt);
return dv;
}
