public long getProfessorSalary(int year, Int64 professorCode)
{
ProfessorPresentDAO pd = new ProfessorPresentDAO();
DataTable dt = pd.getProfessorSalary(year, professorCode);
if (dt.Rows.Count > 0)
{
return(Convert.ToInt64(dt.Rows[0]["salary"]));
}
return(0);
}
public string getActiveGroupOfGroupManagers(int year, Int64 codeOstad)
{
ProfessorPresentDAO pd = new ProfessorPresentDAO();
DataTable dt = pd.getActiveGroupOfGroupManagers(year, codeOstad);
if (dt.Rows.Count > 0 && dt.Rows[0][0] != DBNull.Value && dt.Rows[0][0].ToString() != "")
{
string groups = dt.Rows[0][0].ToString();
return(groups.Substring(0, groups.LastIndexOf(',')));
}
return("");
}
public DataTable getActiveGroupManager(int year, Int64 professorCode)
{
ProfessorPresentDAO pd = new ProfessorPresentDAO();
DataTable dt = pd.getActiveGroupManager(year);
if (dt.Rows.Count > 0)
{
DataRow[] dr = dt.Select("professorCode=" + professorCode);
if (dr.Length > 0)
{
return(dr.CopyToDataTable());
}
else
{
return(new DataTable());
}
}
return(dt);
}
public DataTable GetMGUsers(string term)
{
ProfessorPresentDAO pd = new ProfessorPresentDAO();
return(pd.GetMGUsers(term));
}
public DataTable GetMGTimeByUserName_Term(string username, string term)
{
ProfessorPresentDAO pd = new ProfessorPresentDAO();
return(pd.GetMGTimeByUserName_Term(username, term));
}
