public static List <String> DSMaNL() { List <string> str = new List <string>(); string QueryString = "Select MaNL From NguyenLieu"; conn = DataProvider.OpenConnection(); DataTable dt = DataProvider.LayDataTable(QueryString, conn); if (dt.Rows.Count == 0) { return(null); } for (int i = 0; i < dt.Rows.Count; i++) { str.Add(dt.Rows[i]["MaNL"].ToString()); } DataProvider.CloseConnection(conn); return(str); }
public static List <StudentDTO> searchStudentNotInClass(string textToSearch, string schoolYear) { string sCommand = @"select distinct S.* from Student S, Student_Class SC where S.IDStudent in (select IDStudent from Student) and S.IDStudent not in (select IDStudent from Student_Class) and SC.schoolYear ='" + schoolYear + "' and ((S.IDStudent like '%" + textToSearch + "%') or (S.Name like N'%" + textToSearch + "%'))"; con = DataProvider.OpenConnection(); DataTable dt = DataProvider.GetDataTable(sCommand, con); if (dt.Rows.Count <= 0) { DataProvider.CloseConnection(con); return(null); } int n = dt.Rows.Count; List <StudentDTO> result = new List <StudentDTO>(); for (int i = 0; i < n; i++) { StudentDTO student = new StudentDTO(); student.Id = dt.Rows[i]["IDStudent"].ToString(); student.Name = dt.Rows[i]["Name"].ToString(); student.Gender = dt.Rows[i]["Gender"].ToString(); student.Email = dt.Rows[i]["Email"].ToString(); student.Phone = dt.Rows[i]["Phone"].ToString(); student.DateofBith = dt.Rows[i]["BirthDay"].ToString(); if (dt.Rows[i]["isActive"].ToString() == "T") { student.Status = "Active"; } else { student.Status = "Deactive"; } result.Add(student); } DataProvider.CloseConnection(con); return(result); }