// DELETE api/<controller>/5 public void Delete(int id) { QuanLyTaiKhoan obj = db.QuanLyTaiKhoans.Where(o => o.Id == id).SingleOrDefault(); db.QuanLyTaiKhoans.DeleteOnSubmit(obj); db.SubmitChanges(); }
// POST api/<controller> public void Post([FromBody] string value) { QuanLyTaiKhoan newobj = (QuanLyTaiKhoan)JsonConvert.DeserializeObject(value); db.QuanLyTaiKhoans.InsertOnSubmit(newobj); db.SubmitChanges(); }
// GET api/<controller> public IEnumerable <string> Get() { string filter = HttpContext.Current.Request.Params.Get("filter"); if (string.IsNullOrEmpty(filter)) { List <QuanLyTaiKhoan> lst = (from table in db.QuanLyTaiKhoans select table).ToList(); string json = JsonConvert.SerializeObject(lst); return(new string[] { json }); } else { QuanLyTaiKhoan obj = JsonConvert.DeserializeObject <QuanLyTaiKhoan>(filter); List <QuanLyTaiKhoan> lst = (from table in db.QuanLyTaiKhoans where (obj.IdKhoHang == null || obj.IdKhoHang == table.IdKhoHang) && (obj.isFacebook == null || obj.isFacebook == table.isFacebook) && (obj.Facebook == null || obj.Facebook == table.Facebook) && (obj.Phone == null || obj.Phone == table.Phone) select table).ToList(); string json = JsonConvert.SerializeObject(lst); return(new string[] { json }); } }
public ActionResult ThongTinTaiKhoan() { if (Session["MaTKAdmin"] == null) { return(RedirectToAction("Login", "Admin")); } else { ShopEntities shop = new ShopEntities(); var dsLoaiTaiKhoan = shop.LoaiTaiKhoans.ToList(); List <SelectListItem> slLoaiTK = new List <SelectListItem>(); for (int i = 0; i < dsLoaiTaiKhoan.Count; i++) { SelectListItem sl = new SelectListItem() { Text = dsLoaiTaiKhoan[i].TenLoai, Value = dsLoaiTaiKhoan[i].MaLoai.ToString() }; slLoaiTK.Add(sl); } ViewBag.LTK = slLoaiTK; var model = new QuanLyTaiKhoan() { TaiKhoan = shop.TaiKhoans.SingleOrDefault(t => t.MaTaiKhoan == _maTk), ChiTietTaiKhoan = shop.ChiTietTaiKhoans.SingleOrDefault(c => c.MaTaiKhoan == _maTk) }; return(View(model)); } }
public ActionResult Index(string searchString, int?page) { if (Session["MaTKAdmin"] == null) { return(RedirectToAction("Login", "Admin")); } else { try { var model = new QuanLyTaiKhoan() { DanhSachTaiKhoan = KhoiTao(searchString, page) }; return(View(model)); } catch (Exception) { return(RedirectToAction("Index")); } } }
// PUT api/<controller>/5 public void Put(int id, [FromBody] string value) { QuanLyTaiKhoan obj = db.QuanLyTaiKhoans.Where(o => o.Id == id).SingleOrDefault(); QuanLyTaiKhoan newobj = JsonConvert.DeserializeObject <QuanLyTaiKhoan>(value); if (newobj.IdKhoHang != null) { obj.IdKhoHang = newobj.IdKhoHang; } if (newobj.isFacebook != null) { obj.isFacebook = newobj.isFacebook; } if (newobj.Mail != null) { obj.Mail = newobj.Mail; } if (newobj.MatKhau != null) { obj.MatKhau = newobj.MatKhau; } db.SubmitChanges(); }
public HttpResponseMessage Post([FromBody] QuanLyTaiKhoan user) { try { string TaiKhoan = user.TaiKhoan; string MatKhau = user.MatKhau; databaseDataContext db = new databaseDataContext(); //QuanLyTaiKhoan result = db.QuanLyTaiKhoans.Where(o => o.TaiKhoan == TaiKhoan).SingleOrDefault(); var result = (dynamic)null; if (TaiKhoan.Equals("admin")) { result = db.QuanLyTaiKhoans.Where(taikhoan => taikhoan.TaiKhoan == TaiKhoan).SingleOrDefault(); } else { result = db.QuanLyTaiKhoans.Where(taikhoan => taikhoan.TaiKhoan == TaiKhoan).Join(db.QuanLyKhoHangs, taikhoan => taikhoan.IdKhoHang, khohang => khohang.Id, (taikhoan, khohang) => new { taikhoan.Id, taikhoan.IdKhoHang, taikhoan.TaiKhoan, taikhoan.MatKhau, khohang.CapKho }).SingleOrDefault(); } if (result != null) { if (MatKhau.Equals(result.MatKhau)) { //Truong hop admin //Cache Session if (TaiKhoan.Equals("admin")) { HttpContext.Current.Session.Add("Role", "0"); HttpContext.Current.Session.Add("IdStore", "0"); } else { HttpContext.Current.Session.Add("IdStore", result.IdKhoHang.ToString()); HttpContext.Current.Session.Add("Role", result.CapKho.ToString()); } HttpContext.Current.Session.Add("UserName", result.TaiKhoan.ToString()); var token = JwtManager.GenerateToken(TaiKhoan); return(Request.CreateResponse(HttpStatusCode.OK, token)); } HttpError myCustomError = new HttpError("Sai mật khẩu.") { { "CustomErrorCode", 40 } }; return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, myCustomError)); } else { HttpError errTk = new HttpError("Không có tài khoản") { { "CustomErrorCode", 41 } }; return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, errTk)); } } catch (Exception) { HttpError myCustomError = new HttpError("Tai khoản và mật khẩu không được trống.") { { "CustomErrorCode", 42 } }; return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, myCustomError)); //throw; } //Console.WriteLine(objUser["TaiKhoan"]); }
public ActionResult ThemTaiKhoan(QuanLyTaiKhoan qltk, string submit, int id, HttpPostedFileBase file, string img) { if (Session["MaTKAdmin"] == null) { return(RedirectToAction("Login", "Admin")); } else { try { ShopEntities shop = new ShopEntities(); if (submit == "Thêm") { shop.TaiKhoans.Add(qltk.TaiKhoan); shop.SaveChanges(); var tkMoi = (from s in shop.TaiKhoans orderby s.MaTaiKhoan descending select s).FirstOrDefault(); file = file ?? Request.Files["file"]; if (file != null && file.ContentLength > 0) { var fileName = Path.GetFileName(file.FileName); if (fileName != null) { var path = Path.Combine(Server.MapPath("~/Images/Avatars/"), fileName); file.SaveAs(path); } ChiTietTaiKhoan ct = new ChiTietTaiKhoan(); ct.MaTaiKhoan = tkMoi.MaTaiKhoan; ct.HoTen = qltk.ChiTietTaiKhoan.HoTen; ct.DiaChi = qltk.ChiTietTaiKhoan.DiaChi; ct.SoDienThoai = qltk.ChiTietTaiKhoan.SoDienThoai; ct.AnhDaiDien = "/Images/Avatars/" + fileName; shop.ChiTietTaiKhoans.Add(ct); shop.SaveChanges(); } else { ChiTietTaiKhoan ct = new ChiTietTaiKhoan(); ct.MaTaiKhoan = tkMoi.MaTaiKhoan; ct.HoTen = qltk.ChiTietTaiKhoan.HoTen; ct.DiaChi = qltk.ChiTietTaiKhoan.DiaChi; ct.SoDienThoai = qltk.ChiTietTaiKhoan.SoDienThoai; ct.AnhDaiDien = ""; shop.ChiTietTaiKhoans.Add(ct); shop.SaveChanges(); } } if (submit == "Sửa") { TaiKhoan tk = shop.TaiKhoans.SingleOrDefault(t => t.MaTaiKhoan == id); tk.LoaiTaiKhoan = qltk.TaiKhoan.LoaiTaiKhoan; tk.TenTaiKhoan = qltk.TaiKhoan.TenTaiKhoan; tk.MatKhau = qltk.TaiKhoan.MatKhau; tk.Email = qltk.TaiKhoan.Email; file = file ?? Request.Files["file"]; if (file != null && file.ContentLength > 0) { var fileName = Path.GetFileName(file.FileName); if (fileName != null) { var path = Path.Combine(Server.MapPath("~/Images/Avatars/"), fileName); file.SaveAs(path); ChiTietTaiKhoan ct = shop.ChiTietTaiKhoans.SingleOrDefault(c => c.MaTaiKhoan == id); ct.HoTen = qltk.ChiTietTaiKhoan.HoTen; ct.DiaChi = qltk.ChiTietTaiKhoan.DiaChi; ct.AnhDaiDien = "/Images/Avatars/" + fileName; ct.SoDienThoai = qltk.ChiTietTaiKhoan.SoDienThoai; shop.SaveChanges(); } } else { ChiTietTaiKhoan ct = shop.ChiTietTaiKhoans.SingleOrDefault(c => c.MaTaiKhoan == id); ct.HoTen = qltk.ChiTietTaiKhoan.HoTen; ct.DiaChi = qltk.ChiTietTaiKhoan.DiaChi; ct.AnhDaiDien = img; ct.SoDienThoai = qltk.ChiTietTaiKhoan.SoDienThoai; shop.SaveChanges(); } } var model = new QuanLyTaiKhoan() { DanhSachTaiKhoan = KhoiTao("", 1) }; return(RedirectToAction("Index", model)); } catch (Exception) { return(RedirectToAction("Index")); } } }