public string[] SearchExternalTeacherDataBaseCount(SearchExternal SearchStaffCondition) { SalaryManagement smDB = new SalaryManagement(); if (int.Parse(smDB._StaffhaveRoles[3]) == 1) { return smDB.SearchExternalTeacherDataBaseCount(SearchStaffCondition); } else { return new string[2] { _noRole, _errorMsg }; } }
public List<SearchExternalResult> SearchExternalTeacherDataBase(int index, SearchExternal SearchStaffCondition) { SalaryManagement smDB = new SalaryManagement(); return smDB.SearchExternalTeacherDataBase(index, SearchStaffCondition); }
public List<SearchExternalResult> SearchExternalTeacherDataBase(int indexpage, SearchExternal SearchStaffConditionData) { List<SearchExternalResult> returnValue = new List<SearchExternalResult>(); DataBase Base = new DataBase(); string SearchStaffCondition = this.SearchExternalTeacherDataBaseConditionReturn(SearchStaffConditionData); using (SqlConnection Sqlconn = new SqlConnection(Base.GetConnString())) { try { Sqlconn.Open(); string sql = "SELECT * FROM (SELECT ROW_NUMBER() OVER (ORDER BY ID DESC) " + "AS RowNum, * " + "FROM ExternalTeacherDatabase WHERE isDeleted=0 " + SearchStaffCondition + " ) " + "AS NewTable " + "WHERE RowNum >= (@indexpage-" + PageMinNumFunction() + ") AND RowNum <= (@indexpage)"; SqlCommand cmd = new SqlCommand(sql, Sqlconn); cmd.Parameters.Add("@indexpage", SqlDbType.Int).Value = indexpage; cmd.Parameters.Add("@StaffName", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(SearchStaffConditionData.txtstaffName) + "%"; SqlDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { SearchExternalResult addValue = new SearchExternalResult(); addValue.ID = dr["ID"].ToString(); addValue.sName = dr["TeachName"].ToString(); addValue.sEmail = dr["Email"].ToString(); addValue.Phone = dr["Phone"].ToString(); addValue.Phone2 = dr["Phone2"].ToString(); returnValue.Add(addValue); } dr.Close(); Sqlconn.Close(); } catch (Exception e) { SearchExternalResult addValue = new SearchExternalResult(); addValue.checkNo = "-1"; addValue.errorMsg = e.Message; returnValue.Add(addValue); } } return returnValue; }
public string[] SearchExternalTeacherDataBaseCount(SearchExternal SearchStaffConditionData) { string[] returnValue = new string[2]; returnValue[0] = "0"; returnValue[1] = "0"; DataBase Base = new DataBase(); string SearchStaffCondition = this.SearchExternalTeacherDataBaseConditionReturn(SearchStaffConditionData); using (SqlConnection Sqlconn = new SqlConnection(Base.GetConnString())) { try { Sqlconn.Open(); string sql = "SELECT COUNT(*) AS QCOUNT FROM ExternalTeacherDatabase WHERE isDeleted=0 " + SearchStaffCondition; SqlCommand cmd = new SqlCommand(sql, Sqlconn); cmd.Parameters.Add("@StaffName", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(SearchStaffConditionData.txtstaffName) + "%"; returnValue[0] = cmd.ExecuteScalar().ToString(); Sqlconn.Close(); } catch (Exception e) { returnValue[0] = "-1"; returnValue[1] = e.Message.ToString(); } } return returnValue; }
private string SearchExternalTeacherDataBaseConditionReturn(SearchExternal SearchStaffConditionData) { string ConditionReturn = ""; if (SearchStaffConditionData.txtstaffName != null) { ConditionReturn = " AND TeachName like (@StaffName)"; } StaffDataBase sDB = new StaffDataBase(); List<string> UserFile = sDB.getStaffDataName(HttpContext.Current.User.Identity.Name); if (int.Parse(_StaffhaveRoles[4]) == 0 && UserFile[1].Length > 0) { ConditionReturn += " AND Unit =" + UserFile[2] + " "; } return ConditionReturn; }