// handle manipulations public Result<List<SinhVien_ett>> select_all_sinhvien() { Result<List<SinhVien_ett>> rs = new Result<List<SinhVien_ett>>(); try { List<SinhVien_ett> lst = new List<SinhVien_ett>(); // remember : linq select all table "tbl_sinhvien" var dt = db.tbl_sinhviens; if (dt.Count() > 0) { foreach (tbl_sinhvien item in dt) { SinhVien_ett temp = new SinhVien_ett(item); lst.Add(temp); } rs.data = lst; rs.errorCode = ErrorCode.Sucess; } else { rs.data = null; rs.errorCode = ErrorCode.NaN; rs.errorInfor = Constants.empty_data; } return rs; } catch (Exception ex) { rs.data = null; rs.errorInfor = ex.ToString(); rs.errorCode = ErrorCode.False; return rs; } }
public Result<List<SinhVien_ett>> select_by_fields(string nameInput, string how_to_search) { Result<List<SinhVien_ett>> rs = new Result<List<SinhVien_ett>>(); try { IQueryable<tbl_sinhvien> dt = null; List<SinhVien_ett> lst = new List<SinhVien_ett>(); switch (how_to_search) { case "masv": dt = db.tbl_sinhviens.Where(o => o.masv.Contains(nameInput)); break; case "hoten": dt = db.tbl_sinhviens.Where(o => o.hoten.Contains(nameInput)); break; case "noisinh": dt = db.tbl_sinhviens.Where(o => o.noisinh.Contains(nameInput)); break; case "makhoa": dt = db.tbl_sinhviens.Where(o => o.makhoa.Contains(nameInput)); break; default: break; } if (dt.Count() > 0) { foreach (tbl_sinhvien item in dt) { SinhVien_ett temp = new SinhVien_ett(item); lst.Add(temp); } rs.errorCode = ErrorCode.Sucess; rs.data = lst; } else { rs.errorCode = ErrorCode.NaN; rs.data = null; } return rs; } catch (Exception e) { rs.data = null; rs.errorCode = ErrorCode.False; rs.errorInfor = e.ToString(); return rs; } }
public Result<bool> insert_sinhvien(SinhVien_ett sinhvien) { Result<bool> rs = new Result<bool>(); try { // create new tbl_khoa to insert to datacontext tbl_sinhvien temp = new tbl_sinhvien(); temp.masv = sinhvien.masv; temp.hoten = sinhvien.hoten; temp.noisinh = sinhvien.noisinh; temp.makhoa = sinhvien.makhoa; // remember : linq insert data db.tbl_sinhviens.InsertOnSubmit(temp); // remember : all manipulations such as insert, update, delete have to use this command db.SubmitChanges(); rs.data = true; rs.errorCode = ErrorCode.Sucess; return rs; } catch (Exception e) { rs.data = false; rs.errorCode = ErrorCode.False; rs.errorInfor = e.ToString(); return rs; } }