public JsonResult SaveData(khach_hang model)
{
string r = "fail";//result
using (BikeStoreShoppingEntities db = new BikeStoreShoppingEntities())
{
khach_hang kh = db.khach_hang.FirstOrDefault(x => x.Email == model.Email);
if (kh != null)
{
r = "fail";
}
else
{
db.Database.ExecuteSqlCommand("insert_customer @ten_khach_hang,@SDT,@dia_chi,@email,@password,@username",
new SqlParameter("@ten_khach_hang", model.ten_khach_hang),
new SqlParameter("@SDT", model.SDT),
new SqlParameter("@dia_chi", model.dia_chi),
new SqlParameter("@email", model.Email),
new SqlParameter("@password", model.Password),
new SqlParameter("@username", model.UserName)
);
r = "success";
}
}
return(Json(r, JsonRequestBehavior.AllowGet));
}
public ActionResult InsertOrderIntoDatabase()
{
using (BikeStoreShoppingEntities db = new BikeStoreShoppingEntities())
{
khach_hang cus = (khach_hang)Session["user"];
List <Items> li_items = (List <Items>)Session["cart"];
db.Database.ExecuteSqlCommand("insert_dh @id_khach_hang,@ngay_dat_hang,@tien_ship,@is_dang_giao_hang,@is_da_giao_hang,@is_huy_don_hang",
new SqlParameter("@id_khach_hang", cus.id_khach_hang),
new SqlParameter("@ngay_dat_hang", DateTime.Now),
new SqlParameter("@tien_ship", 20),
new SqlParameter("@is_dang_giao_hang", true),
new SqlParameter("@is_da_giao_hang", false),
new SqlParameter("@is_huy_don_hang", false)
);
string orderId = (from s in db.dat_hang where s.id_khach_hang == cus.id_khach_hang orderby s.ngay_dat_hang descending select s.id_don_dat_hang).FirstOrDefault();
for (int i = 0; i < li_items.Count; ++i)
{
db.Database.ExecuteSqlCommand("insert_ctddh @id_don_dat_hang,@id_muc,@id_xe,@so_luong",
new SqlParameter("@id_don_dat_hang", orderId),
new SqlParameter("@id_muc", i + 1),
new SqlParameter("@id_xe", li_items[i].product.id_xe),
new SqlParameter("@so_luong", li_items[i].quantity)
);
}
Session["cart"] = null;
return(RedirectToAction("OrderHistory"));
}
}
public ActionResult DeleteConfirmed(int id)
{
khach_hang khach_hang = db.khach_hang.Find(id);
db.khach_hang.Remove(khach_hang);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult MyInformation()
{
if (Session["user"] != null)
{
khach_hang kh = (khach_hang)Session["user"];
return(View(kh));
}
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "ma_khach_hang,ten_khach_hang,phai,dia_chi,dien_thoai,email,ghi_chu")] khach_hang khach_hang)
{
if (ModelState.IsValid)
{
db.Entry(khach_hang).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(khach_hang));
}
public ActionResult OrderHistory()
{
using (BikeStoreShoppingEntities db = new BikeStoreShoppingEntities())
{
khach_hang cus = (khach_hang)Session["user"];
//List<chi_tiet_don_dat_hang> order_items = db.Database.SqlQuery<chi_tiet_don_dat_hang>("find_order @id_khach_hang", new SqlParameter("@id_khach_hang", cus.id_khach_hang)).ToList();
List <dat_hang> orders = (from s in db.dat_hang where s.id_khach_hang == cus.id_khach_hang orderby s.ngay_dat_hang descending select s).ToList();
return(View(orders));
}
}
public ActionResult Create([Bind(Include = "ma_khach_hang,ten_khach_hang,phai,dia_chi,dien_thoai,email,ghi_chu")] khach_hang khach_hang)
{
if (ModelState.IsValid)
{
db.khach_hang.Add(khach_hang);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(khach_hang));
}
public ActionResult Login(khach_hang khachHang)
{
var currentUser = database.khach_hang.Where(user => user.email == khachHang.email && user.mat_khau == khachHang.mat_khau).FirstOrDefault();
if (currentUser != null)
{
Session["Username"] = currentUser.ho_ten.ToString();
Session["Id"] = currentUser.id.ToString();
return(RedirectToAction("Index"));
}
return(View(khachHang));
}
public JsonResult Login(khach_hang model)
{
using (BikeStoreShoppingEntities db = new BikeStoreShoppingEntities())
{
string result = "fail";
khach_hang data_match = db.khach_hang.FirstOrDefault(x => x.Email == model.Email && x.Password == model.Password);
if (data_match != null)
{
Session["user"] = data_match;
result = "succcess";
}
return(Json(result, JsonRequestBehavior.AllowGet));
}
}
public ActionResult Register(khach_hang khachHang)
{
try
{
database.khach_hang.Add(khachHang);
khachHang.ngay_dang_ky = DateTime.Today;
database.SaveChanges();
return(RedirectToAction("Index"));
}
catch (Exception e)
{
return(Content(e.ToString()));
}
}
// GET: /c_khach_hang/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
khach_hang khach_hang = db.khach_hang.Find(id);
if (khach_hang == null)
{
return(HttpNotFound());
}
return(View(khach_hang));
}
public JsonResult EditInfor(khach_hang kh)
{
using (BikeStoreShoppingEntities db = new BikeStoreShoppingEntities())
{
khach_hang k = (khach_hang)Session["user"];
db.Database.ExecuteSqlCommand("edit_information @id_khach_hang,@ten_khach_hang,@sdt,@dia_chi,@username",
new SqlParameter("@id_khach_hang", k.id_khach_hang),
new SqlParameter("@ten_khach_hang", kh.ten_khach_hang),
new SqlParameter("@sdt", kh.SDT),
new SqlParameter("@dia_chi", kh.dia_chi),
new SqlParameter("@username", kh.UserName)
);
Session["user"] = db.khach_hang.FirstOrDefault(x => x.id_khach_hang == k.id_khach_hang);
return(Json("success", JsonRequestBehavior.AllowGet));
}
}
public ActionResult ConfirmOrder()
{
khach_hang cus = (khach_hang)Session["user"];
return(View(cus));
}
