public void setVisibility()
{
if (Session["ID"] == null)
{
pnlCheckout.Visible = false;
}
else
{
int id = Convert.ToInt32(Session["ID"]);
using (AABZContext context = new AABZContext())
{
User ui = (from info in context.Users
where info.Id == id
select info).FirstOrDefault();
foreach (UserInfo info in ui.UserInfoes)
{
if (info.isBilling)
{
pnlBillingAddress.Visible = false;
return;
}
}
}
}
}
public void btn_login(Object sender, EventArgs e)
{
var email = txtUserName.Text;
var Pass = SecurePass.GenerateHash(txtPwd.Text);
using (AABZContext context = new AABZContext())
{
try
{
var s = (from c in context.Users
where c.email == email && c.password == Pass
select c).FirstOrDefault();
//if valid create session and session cookie
if (s != null)
{
Session["ID"] = s.Id.ToString();
panelLogin.Visible = false;
Response.Redirect("Default.aspx");
}
else
{
lblResults.Text = "User Name or Password are incorrect.";
}
}
catch (Exception ex)
{
lblResults.Text = ex.ToString();
}
}
}
public double getPrice()
{
if (Session["ID"] != null)
{
int id = Convert.ToInt32(Session["ID"]);
using (AABZContext context = new AABZContext())
{
Order order = (from o in context.Orders
where o.user_id == id
orderby o.Id descending
select o).FirstOrDefault();
double result = 0;
foreach (ProductsOrder po in order.ProductsOrders)
{
result += po.price;
}
return(result);
}
}
else
{
return(0);
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["ID"] != null)
{
using (AABZContext context = new AABZContext())
{
var user = context.Users.Find(Convert.ToInt32(Session["ID"]));
if (user != null)
{
linkLogIn.Visible = false;
linkLogout.Visible = true;
linkSignUp.Text = "<span class='glyphicon glyphicon-user'></span> " + user.first_name + " " + user.last_name;
linkSignUp.NavigateUrl = "~/OrderHistory.aspx";
}
else
{
linkLogIn.Visible = true;
linkLogout.Visible = false;
linkLogIn.NavigateUrl = "~/Login.aspx";
linkSignUp.Text = "<span class='glyphicon glyphicon-user'></span> Sign Up";
linkSignUp.NavigateUrl = "~/Register.aspx";
}
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
using (AABZContext context = new AABZContext())
{
int id = GetId();
ProductsListDataSource.Where = "it.id == " + id.ToString();
ProductsListDataSource.DataBind();
}
}
protected void ResetModel()
{
// Use this method to recreate the database.
// For some reason it doesn't drop the data base, so before doing this:
// - Remove the database file from App_Data
// - Remove the Connection from Server Explorer
Database.SetInitializer(new AABZContextInitializer());
using (AABZContext entities = new AABZContext())
{
var c = entities.Categories.Find("Accessories");
Response.Write(c.Name);
}
}
public void refreshCart()
{
if (Session["ID"] != null)
{
int id = Convert.ToInt32(Session["ID"]);
using (AABZContext context = new AABZContext())
{
Model.Cart cart = (from c in context.Carts
where c.user_id == id
select c).FirstOrDefault();
rptCart.DataSource = cart.products_cart.ToList();
rptCart.DataBind();
}
}
}
protected void btnDelete_Command(object sender, CommandEventArgs e)
{
if (Session["ID"] != null)
{
int id = Convert.ToInt32(e.CommandArgument);
using (AABZContext context = new AABZContext())
{
ProductsCart pc = (from p in context.ProductsCarts
where p.Id == id
select p).FirstOrDefault();
context.ProductsCarts.Remove(pc);
context.SaveChanges();
refreshCart();
}
}
}
public void RedirectUser()
{
if (Session["ID"] != null)
{
int id = Convert.ToInt32(Session["ID"]);
int orderId;
double price;
using (AABZContext context = new AABZContext())
{
//This ensures that order is the most recent order the user has made.
Order order = (from o in context.Orders
where o.user_id == id
orderby o.Id descending
select o).FirstOrDefault();
orderId = order.Id;
int userId = Convert.ToInt32(Session["ID"].ToString());
Model.Cart cart = (from c in context.Carts
where c.user_id == userId
select c).FirstOrDefault();
context.ProductsCarts.RemoveRange(context.ProductsCarts.Where(x => x.cart_id == cart.user_id));
context.SaveChanges();
price = getTotalOrderCost(order);
}
//Assign the values for the properties we need to pass to the service
String AppId = System.Configuration.ConfigurationManager.AppSettings["CreditAppId"];
String SharedKey = System.Configuration.ConfigurationManager.AppSettings["CreditAppSharedKey"];
String AppTransId = orderId.ToString();
String AppTransAmount = price.ToString();
// Hash the values so the server can verify the values are original
String hash = HttpUtility.UrlEncode(CreditAuthorizationClient.GenerateClientRequestHash(SharedKey, AppId, AppTransId, AppTransAmount));
//Create the URL and concatenate the Query String values
String url = "http://ectweb2.cs.depaul.edu/ECTCreditGateway/Authorize.aspx";
url = url + "?AppId=" + AppId;
url = url + "&TransId=" + AppTransId;
url = url + "&AppTransAmount=" + AppTransAmount;
url = url + "&AppHash=" + hash;
//Redirect the User to the Service
//Response.Redirect(url);
Response.Redirect("~/OrderHistory.aspx");
}
}
public ICollection <UserInfo> getUserInfo()
{
if (Session["ID"] != null)
{
int id = Convert.ToInt32(Session["ID"]);
using (AABZContext context = new AABZContext())
{
User result = (from ui in context.Users
where ui.Id == id
select ui).FirstOrDefault();
return(result.UserInfoes);
}
}
else
{
return(null);
}
}
protected void removeItem(object sender, CommandEventArgs e)
{
if (Session["ID"] != null)
{
int id = Convert.ToInt32(e.CommandArgument);
using (AABZContext context = new AABZContext())
{
int userId = Convert.ToInt32(Session["ID"]);
Model.Cart cart = (from c in context.Carts
where c.user_id == userId
select c).FirstOrDefault();
ProductsCart pc = (from p in context.ProductsCarts
where p.Id == id
select p).FirstOrDefault();
cart.products_cart.Remove(pc);
context.ProductsCarts.Remove(pc);
context.SaveChanges();
}
}
}
public double getTotalPrice()
{
if (Session["ID"] != null)
{
int id = Convert.ToInt32(Session["ID"]);
using (AABZContext context = new AABZContext())
{
Model.Cart cart = (from c in context.Carts
where c.user_id == id
select c).FirstOrDefault();
double cost = 0;
foreach (ProductsCart pc in cart.products_cart)
{
cost += (pc.quantity * pc.Product.price);
}
return(cost);
}
}
return(0);
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["ID"] == null)
{
Response.Redirect("Default.aspx");
}
if (!IsPostBack)
{
var id = Int32.Parse(Session["ID"].ToString());
using (AABZContext context = new AABZContext())
{
try
{
var history = (from o in context.Orders
where o.user_id == id
select o).ToList();
foreach (var entry in history)
{
TableRow row = new TableRow();
TableCell cell;
cell = new TableCell();
cell.Text = entry.Id.ToString();
row.Cells.Add(cell);
cell = new TableCell();
cell.Text = entry.ShippingAddress.address_1 + "<br/>" + entry.ShippingAddress.address_2;
row.Cells.Add(cell);
cell = new TableCell();
cell.Text = entry.BillingAddress.address_1 + "<br/>" + entry.BillingAddress.address_2;
row.Cells.Add(cell);
cell = new TableCell();
String products = "";
double total = 0;
foreach (ProductsOrder p in entry.ProductsOrders)
{
total += p.price * p.quantity;
products += "#" + p.Id + " " + p.Product.name + "<br/>";
}
cell.Text = products;
row.Cells.Add(cell);
cell = new TableCell();
products = "";
foreach (ProductsOrder p in entry.ProductsOrders)
{
total += p.price * p.quantity;
products += p.quantity + " X " + p.price + " = " + (p.quantity * p.price) + "<br/>";
}
products += "Total: $" + total;
cell.Text = products;
row.Cells.Add(cell);
tblData.Rows.Add(row);
}
}
catch (Exception)
{
}
}
}
}
protected void btnAddCart_Click(object sender, CommandEventArgs e)
{
//Do Something to add product to cart.
//To get the product it use e.CommandArgument
if (Session["ID"] != null)
{
int userID = Convert.ToInt32(Session["ID"]);
int productID = Convert.ToInt32(e.CommandArgument);
using (AABZContext entities = new AABZContext())
{
var cart = entities.Carts.Find(userID);
if (cart == null)
{
cart = entities.Carts.Create();
cart.user_id = userID;
cart.creation = DateTime.Now;
cart.expiration = DateTime.Now.AddDays(7);
entities.Carts.Add(cart);
entities.SaveChanges();
}
else
{
cart.creation = DateTime.Now;
cart.expiration = DateTime.Now.AddDays(7);
entities.SaveChanges();
}
ProductsCart cartItem;
try
{
cartItem = (from productInCart in entities.ProductsCarts
where productInCart.cart_id == userID && productInCart.product_id == productID
select productInCart).First();
}
catch (Exception)
{
cartItem = null;
}
if (cartItem == null)
{
cartItem = entities.ProductsCarts.Create();
cartItem.cart_id = cart.user_id;
cartItem.product_id = productID;
cartItem.quantity = 1;
entities.ProductsCarts.Add(cartItem);
entities.SaveChanges();
}
else
{
cartItem.quantity += 1;
entities.SaveChanges();
}
}
}
else
{
Response.Redirect("~/Login.aspx");
}
}
protected void BtnSubmit(Object sender, EventArgs e)
{
if (Page.IsValid)
{
using (AABZContext entities = new AABZContext())
{
//try to add user to database, return error if fails
try
{
var isValid = (from c in entities.Users
where c.email == txtEmail.Text
select c).FirstOrDefault();
if (isValid != null && isValid.Equals(txtEmail.Text))
{
error.Text = "Username is not valid!";
return;
}
var user = entities.Users.Create();
user.first_name = txtFname.Text;
user.last_name = txtLastName.Text;
user.email = txtEmail.Text;
var Pass = SecurePass.GenerateHash(txtPass.Text);
user.password = Pass;
var info = entities.UserInfoes.Create();
info.user_id = user.Id;//LINK TO USER
info.address_1 = txtAdd.Text;
info.address_2 = txtAdd2.Text;
info.city = txtCity.Text;
info.state = txtState.Text;
info.zipcode = txtZip.Text;
info.phone = txtPhone.Text;
if (!chkBill.Checked)
{
info.isBilling = false;
var billingInfo = entities.UserInfoes.Create();
billingInfo.address_1 = txtBill1.Text;
billingInfo.address_2 = txtBill2.Text;
billingInfo.user_id = user.Id;//LINK TO USER
billingInfo.city = billcity.Text;
billingInfo.state = billstate.Text;
billingInfo.zipcode = billzip.Text;
billingInfo.isBilling = true;
user.UserInfoes.Add(billingInfo);
}
else
{
info.isBilling = true;
}
user.UserInfoes.Add(info);
entities.Users.Add(user);
entities.UserInfoes.Add(info);
entities.SaveChanges();
Response.Redirect("Login.aspx");
//load information to panel
//show panel and hide form
}
catch (Exception ex)
{
error.Text = "Error Occured. Error Info: " + ex.Message;
}
}
}
}
protected Order createOrder()
{
if (Session["ID"] != null)
{
try
{
int userId = Convert.ToInt32(Session["ID"].ToString());
using (AABZContext context = new AABZContext())
{
Order order = new Order();//build order
//get user cart
Model.Cart cart = (from c in context.Carts
where c.user_id == userId
select c).FirstOrDefault();
//get user
User usr = (from u in context.Users
where u.Id == userId
select u).First();
order.User = usr;//set order user
List <UserInfo> ui = (from info in context.UserInfoes
where info.user_id == userId
select info).ToList();
if (ui.Count == 1 && ui.ElementAt(0).isBilling)//if one address and is billing
{
UserInfo usrinfo = ui.ElementAt(0);
order.BillingAddress = usrinfo;
order.billing_address = usrinfo.Id;
order.ShippingAddress = usrinfo;
order.shipping_address = usrinfo.Id;
}
else
{
foreach (UserInfo info in ui)//for each address assign apropriately
{
if (info.isBilling)
{
order.BillingAddress = info;
order.billing_address = info.Id;
}
else
{
order.ShippingAddress = info;
order.shipping_address = info.Id;
}
}
}
context.Orders.Add(order);
context.SaveChanges();
ProductsOrder po = new ProductsOrder();
//for each product in cart create product order and add to order
List <ProductsOrder> orders = new List <ProductsOrder>();
foreach (ProductsCart pc in cart.products_cart)
{
po = new ProductsOrder();
po.order_id = order.Id;
po.Product = pc.Product;
po.product_id = pc.product_id;
po.quantity = pc.quantity;
po.price = pc.Product.price * pc.quantity;
po.Order = order;
context.PoductsOrders.Add(po);
orders.Add(po);
}
order.ProductsOrders = orders;
//create payment
Payment payment = new Payment();
payment.cc_name = txtCcName.Text;
payment.cc_number = txtCcNumber.Text;
payment.cc_month = Convert.ToInt32(drpCcMonth.SelectedValue);
payment.cc_year = Convert.ToInt32(drpCcYear.SelectedValue);
payment.cc_ccv = Convert.ToInt32(txtCcCvv.Text);
order.Payments = payment;//set payment
payment.Order = order;
/*
* if (ui.isBilling)
* {
* order.BillingAddress = ui;
* }
* else
* {
* UserInfo ui2 = new UserInfo();
* ui2.User = ui.User;
* ui2.address_1 = txtAddress1.Text;
* ui2.address_2 = txtAddress2.Text;
* ui2.city = txtCity.Text;
* ui2.state = txtState.Text;
* ui2.zipcode = txtZipCode.Text;
* ui2.phone = ui.phone;
* order.BillingAddress = ui2;
* }
*/
payment.order_id = order.Id;
context.Payments.Add(payment);
context.SaveChanges();
return(order);
}
}catch (DbEntityValidationException e)
{
return(null);
}
}
else
{
return(null);
}
}
