// 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"));
}
}
}
