public static SinhVien CheckLoginUser(String TenDangNhap, String MatKhau)
{
SinhVien sv = new AppG4Context().sinhViens.Where(e => e.TenDangNhap.Equals(TenDangNhap) && e.MatKhau.Equals(MatKhau)).FirstOrDefault();
if (sv != null)
{
return(sv);
}
return(null);
}
public static void DeleteContactDB(string idContact)
{
var db = new AppG4Context();
var itemToRemove = db.Contacts.SingleOrDefault(x => x.idContact.Equals(idContact));
if (itemToRemove != null)
{
db.Contacts.Remove(itemToRemove);
db.SaveChanges();
}
}
public static void EditContactDB(string IDContact, string name, string phone, string email)
{
var db = new AppG4Context();
var result = db.Contacts.SingleOrDefault(a => a.idContact.Equals(IDContact));
if (result != null)
{
result.nameContact = name;
result.phoneContact = phone;
result.emailContact = email;
db.SaveChanges();
}
}
public static void AddContactDB(string name, string phone, string email, string userName)
{
var db = new AppG4Context();
var cre = db.Contacts.Create();
cre.idContact = Guid.NewGuid().ToString();
cre.nameContact = name;
cre.phoneContact = phone;
cre.emailContact = email;
cre.userName = userName;
db.Contacts.Add(cre);
db.SaveChanges();
}
public static User checkLogin(string userName, string password)
{
var db = new AppG4Context();
return(db.Users.Where(e => (e.userName == userName && e.pasword == password)).FirstOrDefault());
}
public static List <Contact> GetSearchContactDB(string search, string username)
{
var db = new AppG4Context();
return(db.Contacts.Where(e => (e.nameContact.ToLower().Contains(search.ToLower()) && e.userName == username)).ToList());
}
public static List <Contact> GetContactDB(string userName)
{
var db = new AppG4Context();
return(db.Contacts.Where(e => e.userName.ToLower().CompareTo(userName) == 0).ToList());
}
