public KhachHang FindById(int id)
{
var item = db.KhachHangs.Where(x => x.MaKhachHang == id).FirstOrDefault();
KhachHang kh = new KhachHang()
{
Ten = item.Ten,
TenDangNhap = item.TenDangNhap,
MatKhau = item.MatKhau,
SoDienThoai = item.SoDienThoai,
DiaChi = item.DiaChi,
Email = item.Email,
};
return kh;
}
public bool AddUserForFacebook(KhachHang kh)
{
if (db.KhachHangs.Count(x => x.TenDangNhap.Equals(kh.TenDangNhap)) == 0)
{
KhachHang khachhang = new KhachHang()
{
Ten = kh.Ten,
TenDangNhap = kh.TenDangNhap,
MatKhau = Helper.Encryptor.MD5Hash(kh.MatKhau),
SoDienThoai = kh.SoDienThoai,
DiaChi = kh.DiaChi,
Email = kh.Email,
PerId = 1
};
db.KhachHangs.Add(khachhang);
db.SaveChanges();
return true;
}
else
{
return false;
}
}
public bool AddUser(KhachHang kh)
{
try
{
KhachHang khachhang = new KhachHang()
{
Ten = kh.Ten,
TenDangNhap = kh.TenDangNhap,
MatKhau = Helper.Encryptor.MD5Hash(kh.MatKhau),
SoDienThoai = kh.SoDienThoai,
DiaChi = kh.DiaChi,
Email = kh.Email,
PerId = 1
};
db.KhachHangs.Add(khachhang);
db.SaveChanges();
return true;
}
catch
{
return false;
}
}
public List<KhachHang> FindByName(string name)
{
var khachHang = db.Database.SqlQuery<KhachHang>("Select * from KhachHang where Ten like N'%" + name + "%'").ToList();
List<KhachHang> list = new List<KhachHang>();
foreach (var item in khachHang)
{
KhachHang kh = new KhachHang()
{
Ten = item.Ten,
TenDangNhap = item.TenDangNhap,
MatKhau = item.MatKhau,
SoDienThoai = item.SoDienThoai,
DiaChi = item.DiaChi,
Email = item.Email,
PerId = item.PerId
};
list.Add(kh);
}
return list;
}
public bool UpdateUser(int id, KhachHang kh)
{
try
{
var item = db.KhachHangs.Find(id);
item.Ten = kh.Ten;
item.TenDangNhap = kh.TenDangNhap;
if (item.MatKhau.Equals(kh.MatKhau))
{
item.MatKhau = kh.MatKhau;
}
else
{
item.MatKhau = Helper.Encryptor.MD5Hash(kh.MatKhau);
}
item.SoDienThoai = kh.SoDienThoai;
item.DiaChi = kh.DiaChi;
item.Email = kh.Email;
item.PerId = kh.PerId;
db.SaveChanges();
return true;
}
catch
{
return false;
}
}
public List<KhachHang> ListUser()
{
List<KhachHang> list = new List<KhachHang>();
var khachhang = db.Database.SqlQuery<KhachHang>("Select * from KhachHang").ToList();
foreach (var item in khachhang)
{
KhachHang kh = new KhachHang()
{
MaKhachHang=item.MaKhachHang,
Ten = item.Ten,
TenDangNhap = item.TenDangNhap,
MatKhau = item.MatKhau,
SoDienThoai = item.SoDienThoai,
DiaChi = item.DiaChi,
Email = item.Email,
PerId = item.PerId
};
list.Add(kh);
}
return list;
}
public KhachHang FindByUsername(string username)
{
var item = db.Database.SqlQuery<KhachHang>("Select * from KhachHang where TenDangNhap like N'%" + username + "%'").First();
KhachHang kh = new KhachHang()
{
MaKhachHang = item.MaKhachHang,
Ten = item.Ten,
TenDangNhap = item.TenDangNhap,
MatKhau = item.MatKhau,
SoDienThoai = item.SoDienThoai,
DiaChi = item.DiaChi,
Email = item.Email,
PerId = item.PerId
};
return kh;
}