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