public IQueryable <tbl_kho> TimKiemNhomHang(string nhomHang)
{
LinQBaseDataContext data = new LinQBaseDataContext(connection);
var linq = from product in data.tbl_khos
where product.MANHOM == nhomHang
select product;
return(linq);
}
//FORM MAIN
///Danh Sach Kho
public IQueryable <tbl_kho> Load_Kho()
{
LinQBaseDataContext data = new LinQBaseDataContext(connection);
var linq = from product in data.tbl_khos
select product;
//var list = linq.ToList();
return(linq);
}
public bool KiemTraTonTai(dto tv)
{
try
{
LinQBaseDataContext context = new LinQBaseDataContext(connection);
var linq = from person in context.tbl_users
where person.user_name == tv.User
select person;
var list = linq.ToList();
if (list.Count > 0)
{
return(true);
}
}
catch (Exception)
{
}
return(false);
}
public bool KtTaiKhoan(dto tv)
{
try
{
LinQBaseDataContext context = new LinQBaseDataContext(connection);
var linq = from person in context.tbl_users
where person.user_name == tv.User && person.pass == tv.Psw
select person;
var list = linq.ToList();
if (list.Count > 0)
{
return(true);
}
}
catch
{
}
return(false);
}
public bool addNewUser(dto tv)
{
LinQBaseDataContext context = new LinQBaseDataContext(connection);
tbl_user course = new tbl_user
{
name_user = tv.Name,
user_name = tv.User,
pass = tv.Psw,
};
context.tbl_users.InsertOnSubmit(course);
try {
context.SubmitChanges();
return(true);
}
catch
{
}
return(false);
}
public bool UpdatePassword(dto tv)
{
LinQBaseDataContext context = new LinQBaseDataContext();
var linq = from person in context.tbl_users
where person.user_name == tv.User
select person;
foreach (var user in linq)
{
user.pass = tv.Psw;
}
try
{
context.SubmitChanges();
return(true);
}
catch (Exception)
{
}
return(false);
}
