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