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; }