/* -----------------------------------user----------------------------------- */
public User SelectByUsername_User(string username)
{
User user;
using (OnlineShoppingDataClassesDataContext osdb = new OnlineShoppingDataClassesDataContext())
{
user = (from u in osdb.users
where u.username.Equals(username)
select new User()
{
FirstName = u.name
,
LastName = u.surname
,
Address = u.address
,
District = u.district
,
SubDistrict = u.subdistrict
,
Province = u.province
,
Zipcode = u.zipcode
,
Email = u.email
,
Telephone = u.telephone
}).SingleOrDefault();
}
return(user);
}
public static List<Item> SelectAll_Item()
{
using (OnlineShoppingDataClassesDataContext osdb = new OnlineShoppingDataClassesDataContext())
{
List<Item> Items = new List<Item>();
Items = (from i in osdb.items
join c in osdb.companies on i.companyID equals c.companyID
join p in osdb.platforms on i.platformID equals p.platformID
join r in osdb.ratings on i.ratingID equals r.ratingID
join it in osdb.itemgenres on i.itemID equals it.itemID
join g in osdb.genres on it.genreID equals g.genreID
orderby i.datemodified
select new Item()
{
ItemID = i.itemID,
ImageProfile = string.Format("data:image/png;base64,{0}", i.imageprofile),
Name = i.name,
Description = i.description,
CompanyName = c.companyname,
Genre = g.genrename,
Platform = p.platformname,
Cost = i.cost,
SellingPrice = i.sellingprice,
Quantity = i.quantity,
Rating = r.ratingname,
DateModified = i.datemodified
}).ToList();
return Items;
}
}
public ActionResult profile()
{
statusLogin();
User username_check = new User();
using (OnlineShoppingDataClassesDataContext osdb = new OnlineShoppingDataClassesDataContext())
{
string username = Convert.ToString(Session["userName"]);
username_check = (from u in osdb.users
where u.username == username
select new User()
{
Username = u.username,
Password = u.password,
Gender = u.gender,
FirstName = u.name,
LastName = u.surname,
Address = u.address,
District = u.district,
Birthday = u.dateofbirth + "",
Email = u.email,
Province = u.province,
SubDistrict = u.subdistrict,
Telephone = u.telephone,
Zipcode = u.zipcode
}).FirstOrDefault();
}
return(View("profile", username_check));
}
public static List <Item> SelectAll_Item()
{
using (OnlineShoppingDataClassesDataContext osdb = new OnlineShoppingDataClassesDataContext())
{
List <Item> Items = new List <Item>();
Items = (from i in osdb.items
join c in osdb.companies on i.companyID equals c.companyID
join p in osdb.platforms on i.platformID equals p.platformID
join r in osdb.ratings on i.ratingID equals r.ratingID
join it in osdb.itemgenres on i.itemID equals it.itemID
join g in osdb.genres on it.genreID equals g.genreID
orderby i.datemodified
select new Item()
{
ItemID = i.itemID,
ImageProfile = string.Format("data:image/png;base64,{0}", i.imageprofile),
Name = i.name,
Description = i.description,
CompanyName = c.companyname,
Genre = g.genrename,
Platform = p.platformname,
Cost = i.cost,
SellingPrice = i.sellingprice,
Quantity = i.quantity,
Rating = r.ratingname,
DateModified = i.datemodified
}).ToList();
return(Items);
}
}
public List <ItemOrder> SelectByOrderID_ItemOrder(int orderID)
{
List <ItemOrder> itemorders;
using (OnlineShoppingDataClassesDataContext osdb = new OnlineShoppingDataClassesDataContext())
{
itemorders = (from io in osdb.itemorders
join i in osdb.items on io.itemID equals i.itemID
where io.orderID == orderID
select new ItemOrder()
{
ItemID = io.itemID
,
Name = i.name
,
ImageProfile = string.Format("data:image/png;base64,{0}", i.imageprofile)
,
Amount = io.amount
,
Price = io.price
,
Total = (io.price * io.amount)
}).ToList();
}
return(itemorders);
}
/* -----------------------------------order----------------------------------- */
public List <Order> SelectAll_Order()
{
List <Order> orders;
using (OnlineShoppingDataClassesDataContext osdb = new OnlineShoppingDataClassesDataContext())
{
orders = (from o in osdb.orders
join u in osdb.users on o.username equals u.username
join d in osdb.deliverymethods on o.deliverymethodID equals d.deliverymethodID
join s in osdb.orderstatus on o.orderstatusID equals s.orderstatusID
select new Order()
{
OrderID = o.orderID
,
Username = o.username
,
FirstName = u.name
,
LastName = u.surname
,
DeliveryMethod = d.deliverymethodname
,
Fee = d.fee
,
OrderStatus = s.orderstatusname
,
DateAdded = o.date
,
Total = o.total
}).ToList();
}
return(orders);
}
public List <Order> GetOrderList(string username)
{
List <Order> orders;
using (OnlineShoppingDataClassesDataContext osdb = new OnlineShoppingDataClassesDataContext())
{
orders = (from o in osdb.orders
join u in osdb.users on o.username equals u.username
join d in osdb.deliverymethods on o.deliverymethodID equals d.deliverymethodID
join s in osdb.orderstatus on o.orderstatusID equals s.orderstatusID
where u.username == username
select new Order()
{
OrderID = o.orderID
,
OrderStatus = s.orderstatusname
,
DeliveryMethod = d.deliverymethodname
,
DateAdded = o.date
,
Total = o.total
}).ToList();
}
return(orders);
}
public string loginStudentID(string username, string password)
{
//Session.Clear();
var resultLogin = "";
resultLogin = null;
using (OnlineShoppingDataClassesDataContext onlineShoppingDB = new OnlineShoppingDataClassesDataContext())
{
resultLogin = (from user in onlineShoppingDB.users
where user.username == username && user.password == password
select user.name).FirstOrDefault();
}
if (resultLogin != null)
{
Session["statusLogin"] = true;
Session["userName"] = username;
Session["password"] = password;
Session["Name"] = resultLogin;
return("True");
}
else
{
Session.Clear();
return("Not Found");
}
}
public Int64 AddItem(item i)
{
using (OnlineShoppingDataClassesDataContext osdb = new OnlineShoppingDataClassesDataContext())
{
osdb.items.InsertOnSubmit(i);
osdb.SubmitChanges();
return(i.itemID);
}
}
public Int64 SearchCompany(string companyname)
{
using (OnlineShoppingDataClassesDataContext osdb = new OnlineShoppingDataClassesDataContext())
{
company company = (from c in osdb.companies
where c.companyname.Equals(companyname.Trim(), StringComparison.InvariantCultureIgnoreCase)
select c).SingleOrDefault();
return((company == null) ? -1 : company.companyID);
}
}
public List <platform> SelectAll_Platform()
{
List <platform> platforms = new List <platform>();
using (OnlineShoppingDataClassesDataContext osdb = new OnlineShoppingDataClassesDataContext())
{
platforms = osdb.platforms.ToList();
}
return(platforms);
}
public Int64 SearchGenre(string genrename)
{
using (OnlineShoppingDataClassesDataContext osdb = new OnlineShoppingDataClassesDataContext())
{
genre genre = (from g in osdb.genres
where g.genrename.Equals(genrename.Trim(), StringComparison.InvariantCultureIgnoreCase)
select g).SingleOrDefault();
return((genre == null) ? -1 : genre.genreID);
}
}
public List <genre> SelectAll_Genre()
{
List <genre> genres = new List <genre>();
using (OnlineShoppingDataClassesDataContext osdb = new OnlineShoppingDataClassesDataContext())
{
genres = osdb.genres.ToList();
}
return(genres);
}
public List <rating> SelectAll_Rating()
{
List <rating> ratings;
using (OnlineShoppingDataClassesDataContext osdb = new OnlineShoppingDataClassesDataContext())
{
ratings = osdb.ratings.ToList();
}
return(ratings);
}
public List <company> SelectAll_Company()
{
List <company> companies = new List <company>();
using (OnlineShoppingDataClassesDataContext osdb = new OnlineShoppingDataClassesDataContext())
{
companies = osdb.companies.ToList();
}
return(companies);
}
public Int64 SearchPlatform(string platformname)
{
using (OnlineShoppingDataClassesDataContext osdb = new OnlineShoppingDataClassesDataContext())
{
platform platform = (from p in osdb.platforms
where p.platformname.Equals(platformname.Trim(), StringComparison.InvariantCultureIgnoreCase)
select p).SingleOrDefault();
return((platform == null) ? -1 : platform.platformID);
}
}
public List <orderstatus> SelectAll_OrderStatus()
{
List <orderstatus> os;
using (OnlineShoppingDataClassesDataContext osdb = new OnlineShoppingDataClassesDataContext())
{
os = (from record in osdb.orderstatus
select record).ToList();
}
return(os);
}
/* -----------------------------------product----------------------------------- */
public void AddItemGenre(Int64 itemID, Int64 genreID)
{
using (OnlineShoppingDataClassesDataContext osdb = new OnlineShoppingDataClassesDataContext())
{
osdb.itemgenres.InsertOnSubmit(new itemgenre
{
itemID = itemID,
genreID = genreID
});
osdb.SubmitChanges();
}
}
public Int64 AddGenre(string genrename)
{
using (OnlineShoppingDataClassesDataContext osdb = new OnlineShoppingDataClassesDataContext())
{
genre g = new genre
{
genrename = genrename
};
osdb.genres.InsertOnSubmit(g);
osdb.SubmitChanges();
return(g.genreID);
}
}
public Int64 AddCompany(string companyname)
{
using (OnlineShoppingDataClassesDataContext osdb = new OnlineShoppingDataClassesDataContext())
{
company c = new company
{
companyname = companyname
};
osdb.companies.InsertOnSubmit(c);
osdb.SubmitChanges();
return(c.companyID);
}
}
public Int64 AddPlatform(string platformname)
{
using (OnlineShoppingDataClassesDataContext osdb = new OnlineShoppingDataClassesDataContext())
{
platform p = new platform
{
platformname = platformname
};
osdb.platforms.InsertOnSubmit(p);
osdb.SubmitChanges();
return(p.platformID);
}
}
public ActionResult Register(FormCollection collection)
{
statusLogin();
using (OnlineShoppingDataClassesDataContext osdb = new OnlineShoppingDataClassesDataContext())
{
string username = collection["username"];
string username_check = (from u in osdb.users
where u.username == username
select u.username).SingleOrDefault();
if (username_check == null)
{
string password = collection["password"];
string fname = collection["fname"];
string lname = collection["lname"];
string gender = collection["gender"];
DateTime dob = Convert.ToDateTime(collection["dob"]);
string phone = collection["phone"];
string email = collection["email"];
string address = collection["address"];
string province = collection["province"];
string district = collection["district"];
string sdistrict = collection["subdistrict"];
string zcode = collection["zcode"];
user u = new user()
{
username = username,
password = password,
name = fname,
surname = lname,
gender = gender,
dateofbirth = dob,
telephone = phone,
email = email,
address = address,
province = province,
district = district,
subdistrict = sdistrict,
zipcode = zcode
};
osdb.users.InsertOnSubmit(u);
osdb.SubmitChanges();
return(View("Login"));
}
else
{
return(View());
}
}
}
public ActionResult profile(FormCollection collection)
{
statusLogin();
using (OnlineShoppingDataClassesDataContext osdb = new OnlineShoppingDataClassesDataContext())
{
string username = collection["username"];
user user = (from u in osdb.users
where u.username == username
select u).SingleOrDefault();
if (user != null)
{
string password = collection["password"];
string fname = collection["fname"];
string lname = collection["lname"];
string gender = collection["gender"];
DateTime dob = Convert.ToDateTime(collection["dob"]);
string phone = collection["phone"];
string email = collection["email"];
string address = collection["address"];
string province = collection["province"];
string district = collection["district"];
string sdistrict = collection["subdistrict"];
string zcode = collection["zcode"];
user.password = (user.password == password) ? user.password : password;
user.name = (user.name == fname) ? user.name : fname;
user.surname = (user.surname == lname) ? user.surname : lname;
user.gender = (user.gender == gender) ? user.gender : gender;
user.dateofbirth = (user.dateofbirth == dob) ? user.dateofbirth : dob;
user.telephone = (user.telephone == phone) ? user.telephone : phone;
user.email = (user.email == email) ? user.email : email;
user.address = (user.address == address) ? user.address : address;
user.province = (user.province == province) ? user.province : province;
user.district = (user.district == district) ? user.district : district;
user.subdistrict = (user.subdistrict == sdistrict) ? user.subdistrict : sdistrict;
user.zipcode = (user.zipcode == zcode) ? user.zipcode : zcode;
osdb.SubmitChanges();
return(View("Index"));
}
else
{
return(View());
}
}
}
// GET: Manager
public ActionResult Index()
{
using (OnlineShoppingDataClassesDataContext osdb = new OnlineShoppingDataClassesDataContext())
{
List <Item> itemList = new List <Item>();
itemList = (from i in osdb.items
join io in osdb.itemorders on i.itemID equals io.itemID into g
orderby g.Sum(x => x.amount) descending
select new Item()
{
ItemID = i.itemID,
ImageProfile = string.Format("data:image/png;base64,{0}", i.imageprofile),
Name = i.name
}).Take(6).ToList <Item>();
ViewData["NewProduct"] = itemList;
}
return(View());
}
public ActionResult UpdateOrderStatus(int id, FormCollection collection)
{
try
{
// TODO: Add update logic here
using (OnlineShoppingDataClassesDataContext osdb = new OnlineShoppingDataClassesDataContext())
{
order order = osdb.orders.Where(o => o.orderID == id).SingleOrDefault();
Int64 osid = Int64.Parse(collection["osID"]);
order.orderstatusID = osid;
osdb.SubmitChanges();
}
return(RedirectToAction("OrdersIndex"));
}
catch
{
return(View());
}
}
public void EditUserDetail(string username, string fname, string lname, DateTime dob, string gender, string address, string sdistrict, string district, string province, string zcode, string phone, string email)
{
using (OnlineShoppingDataClassesDataContext osdb = new OnlineShoppingDataClassesDataContext())
{
user user = (from u in osdb.users
where u.username == username
select u).SingleOrDefault();
user.name = (user.name.Equals(fname)) ? user.name : fname;
user.surname = (user.surname.Equals(lname)) ? user.surname : lname;
user.dateofbirth = (user.dateofbirth.Equals(dob)) ? user.dateofbirth : dob;
user.gender = (user.gender.Equals(gender)) ? user.gender : gender;
user.address = (user.address.Equals(address)) ? user.address : address;
user.subdistrict = (user.subdistrict.Equals(sdistrict)) ? user.subdistrict : sdistrict;
user.district = (user.district.Equals(district)) ? user.district : district;
user.province = (user.province.Equals(province)) ? user.province : province;
user.zipcode = (user.zipcode.Equals(zcode)) ? user.zipcode : zcode;
user.telephone = (user.telephone.Equals(phone)) ? user.telephone : phone;
user.email = (user.email.Equals(email)) ? user.email : email;
osdb.SubmitChanges();
}
}
public ActionResult Index()
{
statusLogin();
using (OnlineShoppingDataClassesDataContext osdb = new OnlineShoppingDataClassesDataContext())
{
BestSeller();
List<Item> itemList = new List<Item>();
itemList = (from i in osdb.items
join c in osdb.companies on i.companyID equals c.companyID
join p in osdb.platforms on i.platformID equals p.platformID
join r in osdb.ratings on i.ratingID equals r.ratingID
join it in osdb.itemgenres on i.itemID equals it.itemID
join g in osdb.genres on it.genreID equals g.genreID
where i.quantity != 0
orderby i.datemodified
select new Item()
{
ItemID = i.itemID,
ImageProfile = string.Format("data:image/png;base64,{0}", i.imageprofile),
Name = i.name,
Description = i.description,
CompanyName = c.companyname,
Genre = g.genrename,
Platform = p.platformname,
Cost = i.cost,
SellingPrice = i.sellingprice,
Quantity = i.quantity,
Rating = r.ratingname,
DateModified = i.datemodified
}).Take(8).ToList<Item>();
ViewData["NewProduct"] = itemList;
ViewData["BestSellerProduct"] = BestSeller();
}
return View();
}
public ActionResult Index()
{
statusLogin();
using (OnlineShoppingDataClassesDataContext osdb = new OnlineShoppingDataClassesDataContext())
{
BestSeller();
List <Item> itemList = new List <Item>();
itemList = (from i in osdb.items
join c in osdb.companies on i.companyID equals c.companyID
join p in osdb.platforms on i.platformID equals p.platformID
join r in osdb.ratings on i.ratingID equals r.ratingID
join it in osdb.itemgenres on i.itemID equals it.itemID
join g in osdb.genres on it.genreID equals g.genreID
where i.quantity != 0
orderby i.datemodified
select new Item()
{
ItemID = i.itemID,
ImageProfile = string.Format("data:image/png;base64,{0}", i.imageprofile),
Name = i.name,
Description = i.description,
CompanyName = c.companyname,
Genre = g.genrename,
Platform = p.platformname,
Cost = i.cost,
SellingPrice = i.sellingprice,
Quantity = i.quantity,
Rating = r.ratingname,
DateModified = i.datemodified
}).Take(8).ToList <Item>();
ViewData["NewProduct"] = itemList;
ViewData["BestSellerProduct"] = BestSeller();
}
return(View());
}
public List <Item> BestSeller()
{
List <Item> items = new List <Item>();
using (OnlineShoppingDataClassesDataContext osdb = new OnlineShoppingDataClassesDataContext())
{
List <Int64> obj = (from i in osdb.itemorders.Take(8)
group i by i.itemID into g
orderby g.Sum(x => x.amount) descending
select g.Key).ToList();
items = (from i in osdb.items
join c in osdb.companies on i.companyID equals c.companyID
join p in osdb.platforms on i.platformID equals p.platformID
join r in osdb.ratings on i.ratingID equals r.ratingID
join it in osdb.itemgenres on i.itemID equals it.itemID
join g in osdb.genres on it.genreID equals g.genreID
where obj.Contains(i.itemID)
select new Item()
{
ItemID = i.itemID,
ImageProfile = string.Format("data:image/png;base64,{0}", i.imageprofile),
Name = i.name,
Description = i.description,
CompanyName = c.companyname,
Genre = g.genrename,
Platform = p.platformname,
Cost = i.cost,
SellingPrice = i.sellingprice,
Quantity = i.quantity,
Rating = r.ratingname,
DateModified = i.datemodified
}).ToList();
}
return(items);
}
public List<rating> SelectAll_Rating()
{
List<rating> ratings;
using(OnlineShoppingDataClassesDataContext osdb = new OnlineShoppingDataClassesDataContext())
{
ratings = osdb.ratings.ToList();
}
return ratings;
}
public List<orderstatus> SelectAll_OrderStatus()
{
List<orderstatus> os;
using (OnlineShoppingDataClassesDataContext osdb = new OnlineShoppingDataClassesDataContext())
{
os = (from record in osdb.orderstatus
select record).ToList();
}
return os;
}
public List<genre> SelectAll_Genre()
{
List<genre> genres = new List<genre>();
using (OnlineShoppingDataClassesDataContext osdb = new OnlineShoppingDataClassesDataContext())
{
genres = osdb.genres.ToList();
}
return genres;
}
public Int64 SearchPlatform(string platformname)
{
using (OnlineShoppingDataClassesDataContext osdb = new OnlineShoppingDataClassesDataContext())
{
platform platform = (from p in osdb.platforms
where p.platformname.Equals(platformname.Trim(), StringComparison.InvariantCultureIgnoreCase)
select p).SingleOrDefault();
return (platform == null) ? -1 : platform.platformID;
}
}
public Int64 SearchCompany(string companyname)
{
using (OnlineShoppingDataClassesDataContext osdb = new OnlineShoppingDataClassesDataContext())
{
company company = (from c in osdb.companies
where c.companyname.Equals(companyname.Trim(), StringComparison.InvariantCultureIgnoreCase)
select c).SingleOrDefault();
return (company == null) ? -1 : company.companyID;
}
}
public Int64 AddPlatform(string platformname)
{
using (OnlineShoppingDataClassesDataContext osdb = new OnlineShoppingDataClassesDataContext())
{
platform p = new platform
{
platformname = platformname
};
osdb.platforms.InsertOnSubmit(p);
osdb.SubmitChanges();
return p.platformID;
}
}
public Int64 AddItem(item i)
{
using (OnlineShoppingDataClassesDataContext osdb = new OnlineShoppingDataClassesDataContext())
{
osdb.items.InsertOnSubmit(i);
osdb.SubmitChanges();
return i.itemID;
}
}
public ActionResult ProductList(int type, string valueQuery)
{
statusLogin();
using (OnlineShoppingDataClassesDataContext osdb = new OnlineShoppingDataClassesDataContext())
{
List<Item> itemList = new List<Item>();
if (type == 1)
{
itemList = AdminController.SelectByName_Item(valueQuery);
}
else if (type == 2) // 1 -> NameProduct 2 -> Company 3 -> Platform 4 -> Genre
{
itemList = AdminController.SelectByCompanyName_Item(valueQuery);
}
else if (type == 3) // platformID
{
itemList = AdminController.SelectByPlatform_Item(valueQuery);
}
else if (type == 4) // genreID
{
itemList = AdminController.SelectByGenre_Item(valueQuery);
}
else
{
itemList = (from i in osdb.items
join c in osdb.companies on i.companyID equals c.companyID
join p in osdb.platforms on i.platformID equals p.platformID
join r in osdb.ratings on i.ratingID equals r.ratingID
join it in osdb.itemgenres on i.itemID equals it.itemID
join g in osdb.genres on it.genreID equals g.genreID
orderby i.datemodified
select new Item()
{
ItemID = i.itemID,
ImageProfile = string.Format("data:image/png;base64,{0}", i.imageprofile),
Name = i.name,
Description = i.description,
CompanyName = c.companyname,
Genre = g.genrename,
Platform = p.platformname,
Cost = i.cost,
SellingPrice = i.sellingprice,
Quantity = i.quantity,
Rating = r.ratingname,
DateModified = i.datemodified
}).ToList<Item>();
}
List<Company> companyList = (from Table in osdb.companies
select new Company()
{
companyID = Table.companyID,
companyname = Table.companyname
}).ToList<Company>();
List<Genre> genreList = (from Table in osdb.genres
select new Genre()
{
genreID = Table.genreID,
genrename = Table.genrename
}).ToList<Genre>();
List<Platform> platformList = (from Table in osdb.platforms
select new Platform()
{
platformID = Table.platformID,
platformname = Table.platformname
}).ToList<Platform>();
ViewData["CompanyList"] = companyList;
ViewData["GenreList"] = genreList;
ViewData["PlatformList"] = platformList;
ViewData["ProductList"] = itemList;
}
return View();
}
public void EditUserDetail(string username, string fname, string lname, DateTime dob, string gender, string address, string sdistrict, string district, string province, string zcode, string phone, string email)
{
using (OnlineShoppingDataClassesDataContext osdb = new OnlineShoppingDataClassesDataContext())
{
user user = (from u in osdb.users
where u.username == username
select u).SingleOrDefault();
user.name = (user.name.Equals(fname)) ? user.name : fname;
user.surname = (user.surname.Equals(lname)) ? user.surname : lname;
user.dateofbirth = (user.dateofbirth.Equals(dob)) ? user.dateofbirth : dob;
user.gender = (user.gender.Equals(gender)) ? user.gender : gender;
user.address = (user.address.Equals(address)) ? user.address : address;
user.subdistrict = (user.subdistrict.Equals(sdistrict)) ? user.subdistrict : sdistrict;
user.district = (user.district.Equals(district)) ? user.district : district;
user.province = (user.province.Equals(province)) ? user.province : province;
user.zipcode = (user.zipcode.Equals(zcode)) ? user.zipcode : zcode;
user.telephone = (user.telephone.Equals(phone)) ? user.telephone : phone;
user.email = (user.email.Equals(email)) ? user.email : email;
osdb.SubmitChanges();
}
}
//public ActionResult ShoppingCartEnd()
//{
// statusLogin();
// return View();
//}
//[HttpPost]
public ActionResult ShoppingCartEnd(int deliveryMethodID, int totalCost)
{
statusLogin();
string userName = Convert.ToString(Session["Username"]);
//userName = "******";
string momery_Cart = Convert.ToString(Session["memoryCart"]);
string[] momery_Cart_Array;
momery_Cart_Array = momery_Cart.Split(';'); //[2][3][5][7][8]
int memory_Cart_Size = momery_Cart_Array.Length;
order order = new order();
using (OnlineShoppingDataClassesDataContext OnlineShoppingDB = new OnlineShoppingDataClassesDataContext())
{
order = new order()
{
username = userName,
orderstatusID = 2,
deliverymethodID = deliveryMethodID,
date = DateTime.Now,
total = totalCost
};
OnlineShoppingDB.orders.InsertOnSubmit(order);
OnlineShoppingDB.SubmitChanges();
var orderID = (from o in OnlineShoppingDB.orders
where o.username == userName
orderby o.orderID descending
select o.orderID).FirstOrDefault();
for (int j = 0; j < memory_Cart_Size; j++)
{
int counterSameTime = 0;
for (int k = 0; k < memory_Cart_Size; k++) // count Same item
{
if (momery_Cart_Array[j] == momery_Cart_Array[k])
{
counterSameTime++;
}
}
bool repeatItem = false;
for (int p = 0; p < j; p++) // find print already
{
if (momery_Cart_Array[j] == momery_Cart_Array[p])
{
repeatItem = true;
break;
}
}
if (!repeatItem)
{
int currentItemID = Convert.ToInt16(momery_Cart_Array[j]);
Item currentItem = AdminController.SelectByID_Item(currentItemID);
itemorder itemOrder = new itemorder()
{
orderID = orderID,
itemID = currentItemID,
price = currentItem.SellingPrice,
amount = counterSameTime,
cost = currentItem.Cost
};
OnlineShoppingDB.itemorders.InsertOnSubmit(itemOrder);
OnlineShoppingDB.SubmitChanges();
}
}
order = new order();
order.orderID = orderID;
}
return(View("ShoppingCartEnd", order));
}
//public ActionResult ShoppingCartEnd()
//{
// statusLogin();
// return View();
//}
//[HttpPost]
public ActionResult ShoppingCartEnd(int deliveryMethodID, int totalCost)
{
statusLogin();
string userName = Convert.ToString(Session["Username"]);
//userName = "******";
string momery_Cart = Convert.ToString(Session["memoryCart"]);
string[] momery_Cart_Array;
momery_Cart_Array = momery_Cart.Split(';'); //[2][3][5][7][8]
int memory_Cart_Size = momery_Cart_Array.Length;
order order = new order();
using (OnlineShoppingDataClassesDataContext OnlineShoppingDB = new OnlineShoppingDataClassesDataContext())
{
order = new order()
{
username = userName,
orderstatusID = 2,
deliverymethodID = deliveryMethodID,
date = DateTime.Now,
total = totalCost
};
OnlineShoppingDB.orders.InsertOnSubmit(order);
OnlineShoppingDB.SubmitChanges();
var orderID = (from o in OnlineShoppingDB.orders
where o.username == userName
orderby o.orderID descending
select o.orderID).FirstOrDefault();
for (int j = 0; j < memory_Cart_Size; j++)
{
int counterSameTime = 0;
for (int k = 0; k < memory_Cart_Size; k++) // count Same item
{
if (momery_Cart_Array[j] == momery_Cart_Array[k])
{
counterSameTime++;
}
}
bool repeatItem = false;
for (int p = 0; p < j; p++) // find print already
{
if (momery_Cart_Array[j] == momery_Cart_Array[p])
{
repeatItem = true;
break;
}
}
if (!repeatItem)
{
int currentItemID = Convert.ToInt16(momery_Cart_Array[j]);
Item currentItem = AdminController.SelectByID_Item(currentItemID);
itemorder itemOrder = new itemorder()
{
orderID = orderID,
itemID = currentItemID,
price = currentItem.SellingPrice,
amount = counterSameTime,
cost = currentItem.Cost
};
OnlineShoppingDB.itemorders.InsertOnSubmit(itemOrder);
OnlineShoppingDB.SubmitChanges();
}
}
order = new order();
order.orderID = orderID;
}
return View("ShoppingCartEnd", order);
}
/* -----------------------------------user----------------------------------- */
public User SelectByUsername_User(string username)
{
User user;
using (OnlineShoppingDataClassesDataContext osdb = new OnlineShoppingDataClassesDataContext())
{
user = (from u in osdb.users
where u.username.Equals(username)
select new User()
{
FirstName = u.name
,
LastName = u.surname
,
Address = u.address
,
District = u.district
,
SubDistrict = u.subdistrict
,
Province = u.province
,
Zipcode = u.zipcode
,
Email = u.email
,
Telephone = u.telephone
}).SingleOrDefault();
}
return user;
}
public List<Order> GetOrderList(string username)
{
List<Order> orders;
using (OnlineShoppingDataClassesDataContext osdb = new OnlineShoppingDataClassesDataContext())
{
orders = (from o in osdb.orders
join u in osdb.users on o.username equals u.username
join d in osdb.deliverymethods on o.deliverymethodID equals d.deliverymethodID
join s in osdb.orderstatus on o.orderstatusID equals s.orderstatusID
where u.username == username
select new Order()
{
OrderID = o.orderID
,
OrderStatus = s.orderstatusname
,
DeliveryMethod = d.deliverymethodname
,
DateAdded = o.date
,
Total = o.total
}).ToList();
}
return orders;
}
public ActionResult ProductList(int type, string valueQuery)
{
statusLogin();
using (OnlineShoppingDataClassesDataContext osdb = new OnlineShoppingDataClassesDataContext())
{
List <Item> itemList = new List <Item>();
if (type == 1)
{
itemList = AdminController.SelectByName_Item(valueQuery);
}
else if (type == 2) // 1 -> NameProduct 2 -> Company 3 -> Platform 4 -> Genre
{
itemList = AdminController.SelectByCompanyName_Item(valueQuery);
}
else if (type == 3) // platformID
{
itemList = AdminController.SelectByPlatform_Item(valueQuery);
}
else if (type == 4) // genreID
{
itemList = AdminController.SelectByGenre_Item(valueQuery);
}
else
{
itemList = (from i in osdb.items
join c in osdb.companies on i.companyID equals c.companyID
join p in osdb.platforms on i.platformID equals p.platformID
join r in osdb.ratings on i.ratingID equals r.ratingID
join it in osdb.itemgenres on i.itemID equals it.itemID
join g in osdb.genres on it.genreID equals g.genreID
orderby i.datemodified
select new Item()
{
ItemID = i.itemID,
ImageProfile = string.Format("data:image/png;base64,{0}", i.imageprofile),
Name = i.name,
Description = i.description,
CompanyName = c.companyname,
Genre = g.genrename,
Platform = p.platformname,
Cost = i.cost,
SellingPrice = i.sellingprice,
Quantity = i.quantity,
Rating = r.ratingname,
DateModified = i.datemodified
}).ToList <Item>();
}
List <Company> companyList = (from Table in osdb.companies
select new Company()
{
companyID = Table.companyID,
companyname = Table.companyname
}).ToList <Company>();
List <Genre> genreList = (from Table in osdb.genres
select new Genre()
{
genreID = Table.genreID,
genrename = Table.genrename
}).ToList <Genre>();
List <Platform> platformList = (from Table in osdb.platforms
select new Platform()
{
platformID = Table.platformID,
platformname = Table.platformname
}).ToList <Platform>();
ViewData["CompanyList"] = companyList;
ViewData["GenreList"] = genreList;
ViewData["PlatformList"] = platformList;
ViewData["ProductList"] = itemList;
}
return(View());
}
public List<Item> BestSeller()
{
List<Item> items = new List<Item>();
using (OnlineShoppingDataClassesDataContext osdb = new OnlineShoppingDataClassesDataContext())
{
List<Int64> obj = (from i in osdb.itemorders.Take(8)
group i by i.itemID into g
orderby g.Sum(x => x.amount) descending
select g.Key).ToList();
items = (from i in osdb.items
join c in osdb.companies on i.companyID equals c.companyID
join p in osdb.platforms on i.platformID equals p.platformID
join r in osdb.ratings on i.ratingID equals r.ratingID
join it in osdb.itemgenres on i.itemID equals it.itemID
join g in osdb.genres on it.genreID equals g.genreID
where obj.Contains(i.itemID)
select new Item()
{
ItemID = i.itemID,
ImageProfile = string.Format("data:image/png;base64,{0}", i.imageprofile),
Name = i.name,
Description = i.description,
CompanyName = c.companyname,
Genre = g.genrename,
Platform = p.platformname,
Cost = i.cost,
SellingPrice = i.sellingprice,
Quantity = i.quantity,
Rating = r.ratingname,
DateModified = i.datemodified
}).ToList();
}
return items;
}
/* -----------------------------------product----------------------------------- */
public void AddItemGenre(Int64 itemID, Int64 genreID)
{
using(OnlineShoppingDataClassesDataContext osdb = new OnlineShoppingDataClassesDataContext())
{
osdb.itemgenres.InsertOnSubmit(new itemgenre
{
itemID = itemID,
genreID = genreID
});
osdb.SubmitChanges();
}
}
public ActionResult Register(FormCollection collection)
{
statusLogin();
using (OnlineShoppingDataClassesDataContext osdb = new OnlineShoppingDataClassesDataContext())
{
string username = collection["username"];
string username_check = (from u in osdb.users
where u.username == username
select u.username).SingleOrDefault();
if (username_check == null)
{
string password = collection["password"];
string fname = collection["fname"];
string lname = collection["lname"];
string gender = collection["gender"];
DateTime dob = Convert.ToDateTime(collection["dob"]);
string phone = collection["phone"];
string email = collection["email"];
string address = collection["address"];
string province = collection["province"];
string district = collection["district"];
string sdistrict = collection["subdistrict"];
string zcode = collection["zcode"];
user u = new user()
{
username = username,
password = password,
name = fname,
surname = lname,
gender = gender,
dateofbirth = dob,
telephone = phone,
email = email,
address = address,
province = province,
district = district,
subdistrict = sdistrict,
zipcode = zcode
};
osdb.users.InsertOnSubmit(u);
osdb.SubmitChanges();
return View("Login");
}
else
{
return View();
}
}
}
public ActionResult EditItem(int id, FormCollection collection)
{
try
{
// TODO: Add update logic here
var Image = Request.Files["imageprofile"];
string Name = collection["name"].TrimEnd(',');
string Company = collection["company"].TrimEnd(',');
string Genre = collection["genre"].TrimEnd(',');
string Platform = collection["platform"].TrimEnd(',');
Int64 RatingID = Int64.Parse(collection["rating"]);
decimal Cost = Decimal.Parse(collection["cost"]);
decimal SellingPrice = Decimal.Parse(collection["sellingprice"]);
Int64 Quantity = Int64.Parse(collection["quantity"]);
string Description = collection["description"];
string Path = @"C:\DB_Picture\";
if (Image.ContentLength != 0)
{
Path += Image.FileName;
}
else
{
Path += "default-image.jpg";
}
Image Img = System.Drawing.Image.FromFile(Path, true);
string ImageProfile = ImageToBase64(Img, System.Drawing.Imaging.ImageFormat.Jpeg);
using(OnlineShoppingDataClassesDataContext osdb = new OnlineShoppingDataClassesDataContext())
{
item Item = osdb.items.Where(i => i.itemID == id).SingleOrDefault();
Item.imageprofile = (Item.imageprofile.Equals(ImageProfile)) ? Item.imageprofile : ImageProfile;
Item.name = (Item.name.Equals(Name)) ? Item.name : Name;
Item.ratingID = (Item.ratingID == RatingID) ? Item.ratingID : RatingID;
Item.cost = (Item.cost == Cost) ? Item.cost : Cost;
Item.sellingprice = (Item.sellingprice == SellingPrice) ? Item.sellingprice : SellingPrice;
Item.quantity = (Item.quantity == Quantity) ? Item.quantity : Quantity;
Item.description = (Item.description.Equals(Description)) ? Item.description : Description;
Int64 CompanyID;
if (!Int64.TryParse(Company, out CompanyID))
{
CompanyID = AddCompany(Company);
}
Item.companyID = (Item.companyID == CompanyID) ? Item.companyID : CompanyID;
Int64 PlatformID;
if (!Int64.TryParse(Platform, out PlatformID))
{
PlatformID = AddPlatform(Platform);
}
Item.platformID = (Item.platformID == PlatformID) ? Item.platformID : PlatformID;
osdb.SubmitChanges();
Int64 GenreID;
if (!Int64.TryParse(Genre, out GenreID))
{
GenreID = AddGenre(Genre);
}
itemgenre ig = osdb.itemgenres.Where(i => i.itemID == Item.itemID).SingleOrDefault();
ig.genreID = (ig.genreID == GenreID) ? ig.genreID : GenreID;
osdb.SubmitChanges();
}
return RedirectToAction("ItemsIndex");
}
catch
{
return View();
}
}
public ActionResult profile(FormCollection collection)
{
statusLogin();
using (OnlineShoppingDataClassesDataContext osdb = new OnlineShoppingDataClassesDataContext())
{
string username = collection["username"];
user user = (from u in osdb.users
where u.username == username
select u).SingleOrDefault();
if (user != null)
{
string password = collection["password"];
string fname = collection["fname"];
string lname = collection["lname"];
string gender = collection["gender"];
DateTime dob = Convert.ToDateTime(collection["dob"]);
string phone = collection["phone"];
string email = collection["email"];
string address = collection["address"];
string province = collection["province"];
string district = collection["district"];
string sdistrict = collection["subdistrict"];
string zcode = collection["zcode"];
user.password = (user.password == password) ? user.password : password;
user.name = (user.name == fname) ? user.name : fname;
user.surname = (user.surname == lname) ? user.surname : lname;
user.gender = (user.gender == gender) ? user.gender : gender;
user.dateofbirth = (user.dateofbirth == dob) ? user.dateofbirth : dob;
user.telephone = (user.telephone == phone) ? user.telephone : phone;
user.email = (user.email == email) ? user.email : email;
user.address = (user.address == address) ? user.address : address;
user.province = (user.province == province) ? user.province : province;
user.district = (user.district == district) ? user.district : district;
user.subdistrict = (user.subdistrict == sdistrict) ? user.subdistrict : sdistrict;
user.zipcode = (user.zipcode == zcode) ? user.zipcode : zcode;
osdb.SubmitChanges();
return View("Index");
}
else
{
return View();
}
}
}
public Int64 SearchGenre(string genrename)
{
using (OnlineShoppingDataClassesDataContext osdb = new OnlineShoppingDataClassesDataContext())
{
genre genre = (from g in osdb.genres
where g.genrename.Equals(genrename.Trim(), StringComparison.InvariantCultureIgnoreCase)
select g).SingleOrDefault();
return (genre == null) ? -1 : genre.genreID;
}
}
public ActionResult profile()
{
statusLogin();
User username_check = new User();
using (OnlineShoppingDataClassesDataContext osdb = new OnlineShoppingDataClassesDataContext())
{
string username = Convert.ToString(Session["userName"]);
username_check = (from u in osdb.users
where u.username == username
select new User()
{
Username = u.username,
Password = u.password,
Gender = u.gender,
FirstName = u.name,
LastName = u.surname,
Address = u.address,
District = u.district,
Birthday = u.dateofbirth + "",
Email = u.email,
Province = u.province,
SubDistrict = u.subdistrict,
Telephone = u.telephone,
Zipcode = u.zipcode
}).FirstOrDefault();
}
return View("profile", username_check);
}
public List<company> SelectAll_Company()
{
List<company> companies = new List<company>();
using (OnlineShoppingDataClassesDataContext osdb = new OnlineShoppingDataClassesDataContext())
{
companies = osdb.companies.ToList();
}
return companies;
}
// GET: Manager
public ActionResult Index()
{
using (OnlineShoppingDataClassesDataContext osdb = new OnlineShoppingDataClassesDataContext())
{
List<Item> itemList = new List<Item>();
itemList = (from i in osdb.items
join io in osdb.itemorders on i.itemID equals io.itemID into g
orderby g.Sum(x => x.amount) descending
select new Item()
{
ItemID = i.itemID,
ImageProfile = string.Format("data:image/png;base64,{0}", i.imageprofile),
Name = i.name
}).Take(6).ToList<Item>();
ViewData["NewProduct"] = itemList;
}
return View();
}
/* -----------------------------------order----------------------------------- */
public List<Order> SelectAll_Order()
{
List<Order> orders;
using (OnlineShoppingDataClassesDataContext osdb = new OnlineShoppingDataClassesDataContext())
{
orders = (from o in osdb.orders
join u in osdb.users on o.username equals u.username
join d in osdb.deliverymethods on o.deliverymethodID equals d.deliverymethodID
join s in osdb.orderstatus on o.orderstatusID equals s.orderstatusID
select new Order()
{
OrderID = o.orderID
,
Username = o.username
,
FirstName = u.name
,
LastName = u.surname
,
DeliveryMethod = d.deliverymethodname
,
Fee = d.fee
,
OrderStatus = s.orderstatusname
,
DateAdded = o.date
,
Total = o.total
}).ToList();
}
return orders;
}
public Int64 AddCompany(string companyname)
{
using (OnlineShoppingDataClassesDataContext osdb = new OnlineShoppingDataClassesDataContext())
{
company c = new company
{
companyname = companyname
};
osdb.companies.InsertOnSubmit(c);
osdb.SubmitChanges();
return c.companyID;
}
}
public List<platform> SelectAll_Platform()
{
List<platform> platforms = new List<platform>();
using (OnlineShoppingDataClassesDataContext osdb = new OnlineShoppingDataClassesDataContext())
{
platforms = osdb.platforms.ToList();
}
return platforms;
}
public string loginStudentID(string username, string password)
{
//Session.Clear();
var resultLogin = "";
resultLogin = null;
using (OnlineShoppingDataClassesDataContext onlineShoppingDB = new OnlineShoppingDataClassesDataContext())
{
resultLogin = (from user in onlineShoppingDB.users
where user.username == username && user.password == password
select user.name).FirstOrDefault();
}
if (resultLogin != null)
{
Session["statusLogin"] = true;
Session["userName"] = username;
Session["password"] = password;
Session["Name"] = resultLogin;
return "True";
}
else
{
Session.Clear();
return "Not Found";
}
}
public List<ItemOrder> SelectByOrderID_ItemOrder(int orderID)
{
List<ItemOrder> itemorders;
using (OnlineShoppingDataClassesDataContext osdb = new OnlineShoppingDataClassesDataContext())
{
itemorders = (from io in osdb.itemorders
join i in osdb.items on io.itemID equals i.itemID
where io.orderID == orderID
select new ItemOrder()
{
ItemID = io.itemID
,
Name = i.name
,
ImageProfile = string.Format("data:image/png;base64,{0}", i.imageprofile)
,
Amount = io.amount
,
Price = io.price
,
Total = (io.price * io.amount)
}).ToList();
}
return itemorders;
}
public Int64 AddGenre(string genrename)
{
using (OnlineShoppingDataClassesDataContext osdb = new OnlineShoppingDataClassesDataContext())
{
genre g = new genre
{
genrename = genrename
};
osdb.genres.InsertOnSubmit(g);
osdb.SubmitChanges();
return g.genreID;
}
}
public ActionResult UpdateOrderStatus(int id, FormCollection collection)
{
try
{
// TODO: Add update logic here
using(OnlineShoppingDataClassesDataContext osdb = new OnlineShoppingDataClassesDataContext())
{
order order = osdb.orders.Where(o => o.orderID == id).SingleOrDefault();
Int64 osid = Int64.Parse(collection["osID"]);
order.orderstatusID = osid;
osdb.SubmitChanges();
}
return RedirectToAction("OrdersIndex");
}
catch
{
return View();
}
}
public ActionResult EditItem(int id, FormCollection collection)
{
try
{
// TODO: Add update logic here
var Image = Request.Files["imageprofile"];
string Name = collection["name"].TrimEnd(',');
string Company = collection["company"].TrimEnd(',');
string Genre = collection["genre"].TrimEnd(',');
string Platform = collection["platform"].TrimEnd(',');
Int64 RatingID = Int64.Parse(collection["rating"]);
decimal Cost = Decimal.Parse(collection["cost"]);
decimal SellingPrice = Decimal.Parse(collection["sellingprice"]);
Int64 Quantity = Int64.Parse(collection["quantity"]);
string Description = collection["description"];
string Path = @"C:\DB_Picture\";
if (Image.ContentLength != 0)
{
Path += Image.FileName;
}
else
{
Path += "default-image.jpg";
}
Image Img = System.Drawing.Image.FromFile(Path, true);
string ImageProfile = ImageToBase64(Img, System.Drawing.Imaging.ImageFormat.Jpeg);
using (OnlineShoppingDataClassesDataContext osdb = new OnlineShoppingDataClassesDataContext())
{
item Item = osdb.items.Where(i => i.itemID == id).SingleOrDefault();
Item.imageprofile = (Item.imageprofile.Equals(ImageProfile)) ? Item.imageprofile : ImageProfile;
Item.name = (Item.name.Equals(Name)) ? Item.name : Name;
Item.ratingID = (Item.ratingID == RatingID) ? Item.ratingID : RatingID;
Item.cost = (Item.cost == Cost) ? Item.cost : Cost;
Item.sellingprice = (Item.sellingprice == SellingPrice) ? Item.sellingprice : SellingPrice;
Item.quantity = (Item.quantity == Quantity) ? Item.quantity : Quantity;
Item.description = (Item.description.Equals(Description)) ? Item.description : Description;
Int64 CompanyID;
if (!Int64.TryParse(Company, out CompanyID))
{
CompanyID = AddCompany(Company);
}
Item.companyID = (Item.companyID == CompanyID) ? Item.companyID : CompanyID;
Int64 PlatformID;
if (!Int64.TryParse(Platform, out PlatformID))
{
PlatformID = AddPlatform(Platform);
}
Item.platformID = (Item.platformID == PlatformID) ? Item.platformID : PlatformID;
osdb.SubmitChanges();
Int64 GenreID;
if (!Int64.TryParse(Genre, out GenreID))
{
GenreID = AddGenre(Genre);
}
itemgenre ig = osdb.itemgenres.Where(i => i.itemID == Item.itemID).SingleOrDefault();
ig.genreID = (ig.genreID == GenreID) ? ig.genreID : GenreID;
osdb.SubmitChanges();
}
return(RedirectToAction("ItemsIndex"));
}
catch
{
return(View());
}
}
