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