public DataTable GetShortCourseList() { DataTable courselist = null; int depcode = 0; SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@depcode", depcode) }; using (DataTable table = SqlDBHelper_ShortCourcse.ExecuteParamerizedSelectCommand("[dbo].[SP_Get_AllProfessor]", CommandType.StoredProcedure, parameters)) { if (table.Rows.Count > 0) { courselist = table.Copy(); } } return(courselist); }
public List <Course> GetShortTermByProfId(int profId) { List <Course> courselist = null; SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@depId", profId) }; //need sp to fetch course list by teacher id using (DataTable table = SqlDBHelper_ShortCourcse.ExecuteParamerizedSelectCommand("[Resource_Control].[SP_GetListOfThisTermClassOfOstad]", CommandType.StoredProcedure, parameters)) { if (table.Rows.Count > 0) { courselist = new List <Course>(); foreach (DataRow row in table.Rows) { Course course = new Course(); course.DID = Convert.ToInt32(row["did"]); string kstime = ""; if (row["saatklass"] != System.DBNull.Value) { kstime = (row["saatklass"] as string).Replace("شماره کلاس کلاس آنلاينعادي", ""); kstime = kstime.Replace("شماره کلاسکلاس آنلاينعادي", ""); } course.Name = row["namedars"] as string + " - " + kstime; course.Capacity = Convert.ToInt32(row["zarfporm"]); course.saatklass = row["saatklass"] as string; course.DaneshID = Convert.ToInt32(row["iddanesh"]); courselist.Add(course); } } } return(courselist); }