public ActionResult Index()
{
if (ValidateUser.IsUserLogin())
{
return(View());
}
return(RedirectToAction("Login", "User"));
}
// GET: City/Create
public ActionResult Create()
{
if (ValidateUser.IsUserLogin())
{
ViewBag.countries = db.countries.ToList();
return(View());
}
return(RedirectToAction("Login", "User"));
}
// GET: Color
public ActionResult Index(int?page)
{
if (ValidateUser.IsUserLogin())
{
int pageNumber = (page ?? 1);
return(View(db.colors.OrderBy(u => u.id).ToPagedList(pageNumber, Const.Const.PAGE_SIZE)));
}
return(RedirectToAction("Login", "User"));
}
// GET: Product/Create
public ActionResult Create()
{
if (ValidateUser.IsUserLogin())
{
ViewBag.categorylist = db.categories.ToList();
ViewBag.sizes = db.sizes.ToList();
ViewBag.colors = db.colors.ToList();
return(View());
}
return(RedirectToAction("Login", "User"));
}
public ActionResult DeleteConfirmed(long id)
{
if (ValidateUser.IsUserLogin())
{
category category = db.categories.Find(id);
db.categories.Remove(category);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(RedirectToAction("Login", "User"));
}
public ActionResult DeleteConfirmed(long id)
{
if (ValidateUser.IsUserLogin())
{
district district = db.districts.Find(id);
db.districts.Remove(district);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(RedirectToAction("Login", "User"));
}
public ActionResult DeleteConfirmed(long id)
{
if (ValidateUser.IsUserLogin())
{
order order = db.orders.Find(id);
db.orders.Remove(order);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(RedirectToAction("Login", "User"));
}
// GET: User/Create
public ActionResult Create()
{
if (ValidateUser.IsUserLogin())
{
ViewBag.roles = new List <Object> {
new { value = 1, role_name = "Admin" },
new { value = 2, role_name = "User" }
};
return(View());
}
return(RedirectToAction("Login", "User"));
}
public ActionResult Edit([Bind(Include = "id,category_name, image_url")] category category)
{
if (ValidateUser.IsUserLogin())
{
if (ModelState.IsValid)
{
db.Entry(category).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(category));
}
return(RedirectToAction("Login", "User"));
}
public ActionResult Create([Bind(Include = "id,category_name, image_url")] category category)
{
if (ValidateUser.IsUserLogin())
{
if (ModelState.IsValid)
{
db.categories.Add(category);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(category));
}
return(RedirectToAction("Login", "User"));
}
public ActionResult Edit([Bind(Include = "id,country_id,city_name")] city city)
{
if (ValidateUser.IsUserLogin())
{
ViewBag.countries = db.countries.ToList();
if (ModelState.IsValid)
{
db.Entry(city).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(city));
}
return(RedirectToAction("Login", "User"));
}
// GET: orders/Delete/5
public ActionResult Delete(long?id)
{
if (ValidateUser.IsUserLogin())
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
order order = db.orders.Find(id);
if (order == null)
{
return(HttpNotFound());
}
return(View(order));
}
return(RedirectToAction("Login", "User"));
}
public ActionResult Create([Bind(Include = "id,country_id,city_id,district_name")] district district)
{
if (ValidateUser.IsUserLogin())
{
ViewBag.countries = db.countries.ToList();
ViewBag.cities = db.cities.ToList();
if (ModelState.IsValid)
{
db.districts.Add(district);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(district));
}
return(RedirectToAction("Login", "User"));
}
// GET: Ward/Details/5
public ActionResult Details(long?id)
{
if (ValidateUser.IsUserLogin())
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
ward ward = db.wards.Find(id);
if (ward == null)
{
return(HttpNotFound());
}
return(View(ward));
}
return(RedirectToAction("Login", "User"));
}
// GET: categories/Edit/5
public ActionResult Edit(long?id)
{
if (ValidateUser.IsUserLogin())
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
category category = db.categories.Find(id);
if (category == null)
{
return(HttpNotFound());
}
return(View(category));
}
return(RedirectToAction("Login", "User"));
}
// GET: City
public ActionResult Index(int?page)
{
if (ValidateUser.IsUserLogin())
{
ViewBag.CurrentSort = "asc";
var sqlStr = "";
sqlStr += "SELECT city.id, country.country_name, city_name ";
sqlStr += "FROM city ";
sqlStr += "LEFT JOIN country ON city.country_id = country.id ";
var cities = db.Database.SqlQuery <CityResponseDTO>(sqlStr).OrderByDescending(o => o.city_name);
int pageNumber = (page ?? 1);
return(View(cities.ToPagedList(pageNumber, Const.Const.PAGE_SIZE)));
}
return(RedirectToAction("Login", "User"));
//return View(db.cities.ToList());
}
public ActionResult Edit([Bind(Include = "id,product_name,category,price,image_url,description, origin_price, isPopular, size_id, color_id")] product product)
{
if (ValidateUser.IsUserLogin())
{
ViewBag.categorylist = db.categories.ToList();
ViewBag.sizes = db.sizes.ToList();
ViewBag.colors = db.colors.ToList();
if (ModelState.IsValid)
{
db.Entry(product).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(product));
}
return(RedirectToAction("Login", "User"));
}
public ActionResult Create([Bind(Include = "id,user_name,password,user_role")] user user)
{
if (ValidateUser.IsUserLogin())
{
if (ModelState.IsValid)
{
db.users.Add(user);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.roles = new List <Object> {
new { value = 1, role_name = "Admin" },
new { value = 2, role_name = "User" }
};
return(View(user));
}
return(RedirectToAction("Login", "User"));
}
// GET: Product
public ActionResult Index(int?page)
{
if (ValidateUser.IsUserLogin())
{
ViewBag.CurrentSort = "asc";
var sqlStr = "";
sqlStr += "SELECT products.*, category_name, size_name, color_name ";
sqlStr += "FROM products ";
sqlStr += "LEFT JOIN category ON products.category = category.id ";
sqlStr += "LEFT JOIN colors ON products.color_id = colors.id ";
sqlStr += "LEFT JOIN sizes ON products.size_id = sizes.id ";
var products = db.Database.SqlQuery <ProductResponseDTO>(sqlStr).OrderByDescending(o => o.product_name);
int pageNumber = (page ?? 1);
return(View(products.ToPagedList(pageNumber, Const.Const.PAGE_SIZE)));
}
return(RedirectToAction("Login", "User"));
}
// GET: City/Edit/5
public ActionResult Edit(long?id)
{
if (ValidateUser.IsUserLogin())
{
ViewBag.countries = db.countries.ToList();
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
city city = db.cities.Find(id);
if (city == null)
{
return(HttpNotFound());
}
return(View(city));
}
return(RedirectToAction("Login", "User"));
}
// GET: Product/Edit/5
public ActionResult Edit(long?id)
{
if (ValidateUser.IsUserLogin())
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
product product = db.products.Find(id);
if (product == null)
{
return(HttpNotFound());
}
ViewBag.categorylist = db.categories.ToList();
ViewBag.sizes = db.sizes.ToList();
ViewBag.colors = db.colors.ToList();
return(View(product));
}
return(RedirectToAction("Login", "User"));
}
// GET: orders
public ActionResult Index(int?page)
{
if (ValidateUser.IsUserLogin())
{
ViewBag.CurrentSort = "asc";
var sqlStr = "";
sqlStr += "SELECT orders.*, country_name, city_name, district_name,ward_name ";
sqlStr += "FROM orders ";
sqlStr += "LEFT JOIN country ON orders.country_id = country.id ";
sqlStr += "LEFT JOIN city ON orders.city_id = city.id ";
sqlStr += "LEFT JOIN district ON orders.district_id = district.id ";
sqlStr += "LEFT JOIN ward ON orders.ward_id = ward.id ";
var cities = db.Database.SqlQuery <OrderResponseDTO>(sqlStr).OrderByDescending(o => o.id);
int pageNumber = (page ?? 1);
return(View(cities.ToPagedList(pageNumber, Const.Const.PAGE_SIZE)));
//return View(db.orders.OrderBy(u => u.id).ToPagedList(pageNumber, Const.Const.PAGE_SIZE));
}
return(RedirectToAction("Login", "User"));
}
// GET: User/Edit/5
public ActionResult Edit(long?id)
{
if (ValidateUser.IsUserLogin())
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
user user = db.users.Find(id);
if (user == null)
{
return(HttpNotFound());
}
ViewBag.roles = new List <Object> {
new { value = 1, role_name = "Admin" },
new { value = 2, role_name = "User" }
};
return(View(user));
}
return(RedirectToAction("Login", "User"));
}
// GET: orders/Details/5
public ActionResult Details(long?id)
{
if (ValidateUser.IsUserLogin())
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
var sqlStr = "";
sqlStr += "SELECT orders_item.id, orders_item.order_id, orders_item.book_id as product_id, products.product_name, orders_item.quantity, orders_item.price, size_name, color_name ";
sqlStr += "FROM orders_item ";
sqlStr += "LEFT JOIN products ON orders_item.book_id = products.id ";
sqlStr += "LEFT JOIN sizes ON products.size_id = sizes.id ";
sqlStr += "LEFT JOIN colors ON products.color_id = colors.id ";
sqlStr += "WHERE orders_item.order_id = @id ";
var orderItems = db.Database.SqlQuery <OrderItemDetail>(sqlStr, new SqlParameter("@id", id));
//List<orders_item> items = db.orders_item.Where(item => item.order_id == id).ToList();
return(View(orderItems.ToList()));
}
return(RedirectToAction("Login", "User"));
}
