public MyStatusDTO GetMyStatus(string user_id, string class_id) { MyStatusDTO dto = new MyStatusDTO(); try { string query = string.Empty; query = string.Format("execute UP_MY_STATUS N'{0}', {1}", user_id, class_id); DataSet ds = null; SqlParameter[] param = null; ds = db.GetDataSet(query, CommandType.Text, param); if (ds != null) { if (ds.Tables.Count > 0) { foreach (DataRow dr in ds.Tables[0].Rows) { dto.ClassID = int.Parse(dr["ClassID"].ToString()); dto.UserID = dr["UserID"].ToString(); dto.UserName = dr["UserName"].ToString(); dto.NickName = dr["NickName"].ToString(); dto.SkypeID = dr["SkypeID"].ToString(); dto.TeacherID = dr["TeacherID"].ToString(); dto.TeacherName = dr["TeacherName"].ToString(); dto.StartDate = int.Parse(dr["StartDate"].ToString()); dto.EndDate = int.Parse(dr["EndDate"].ToString()); dto.ClassTime = dr["ClassTime"].ToString(); dto.Minutes = int.Parse(dr["Minutes"].ToString()); dto.BookCode = dr["BookCode"].ToString(); dto.BookName = dr["BookName"].ToString(); dto.Complete = int.Parse(dr["Complete"].ToString()); dto.Present = int.Parse(dr["Present"].ToString()); dto.Absent = int.Parse(dr["Absent"].ToString()); dto.Postpone = int.Parse(dr["Postpone"].ToString()); dto.Vacation = int.Parse(dr["Vacation"].ToString()); dto.Cancel = int.Parse(dr["Cancel"].ToString()); dto.TotalDays = int.Parse(dr["TotalDays"].ToString()); dto.RemainingDays = int.Parse(dr["RemainingDays"].ToString()); dto.Progress = int.Parse(dr["Progress"].ToString()); } } else { dto = null; } } } catch (Exception ex) { dto = null; } return dto; }
public Dictionary<string, List<MyStatusDTO>> GetAllMyStatus(string user_id) { Dictionary<string, List<MyStatusDTO>> dic = new Dictionary<string, List<MyStatusDTO>>(); try { string query = string.Empty; query = string.Format("execute UP_MY_LECTURE_HISTORY N'{0}'", user_id); DataSet ds = null; SqlParameter[] param = null; ds = db.GetDataSet(query, CommandType.Text, param); if (ds != null) { if (ds.Tables.Count < 2) { dic = null; } else { if (ds.Tables[0].Rows.Count == 0) { dic.Add("current", null); } else { List<MyStatusDTO> lstDto = new List<MyStatusDTO>(); foreach (DataRow dr in ds.Tables[0].Rows) { MyStatusDTO dto = new MyStatusDTO(); dto.ClassID = int.Parse(dr["ClassID"].ToString()); dto.UserID = dr["UserID"].ToString(); dto.UserName = dr["UserName"].ToString(); dto.NickName = dr["NickName"].ToString(); dto.SkypeID = dr["SkypeID"].ToString(); dto.TeacherID = dr["TeacherID"].ToString(); dto.TeacherName = dr["TeacherName"].ToString(); dto.StartDate = int.Parse(dr["StartDate"].ToString()); dto.EndDate = int.Parse(dr["EndDate"].ToString()); dto.ClassTime = dr["ClassTime"].ToString(); dto.Minutes = int.Parse(dr["Minutes"].ToString()); dto.BookCode = dr["BookCode"].ToString(); dto.BookName = dr["BookName"].ToString(); dto.Complete = int.Parse(dr["Complete"].ToString()); dto.Present = int.Parse(dr["Present"].ToString()); dto.Absent = int.Parse(dr["Absent"].ToString()); dto.Postpone = int.Parse(dr["Postpone"].ToString()); dto.Vacation = int.Parse(dr["Vacation"].ToString()); dto.Cancel = int.Parse(dr["Cancel"].ToString()); dto.TotalDays = int.Parse(dr["TotalDays"].ToString()); dto.RemainingDays = int.Parse(dr["RemainingDays"].ToString()); dto.Progress = int.Parse(dr["Progress"].ToString()); lstDto.Add(dto); } dic.Add("current", lstDto); } if (ds.Tables[1].Rows.Count == 0) { dic.Add("history", null); } else { List<MyStatusDTO> lstDto = new List<MyStatusDTO>(); foreach (DataRow dr in ds.Tables[1].Rows) { MyStatusDTO dto = new MyStatusDTO(); dto.ClassID = int.Parse(dr["ClassID"].ToString()); dto.UserID = dr["UserID"].ToString(); dto.UserName = dr["UserName"].ToString(); dto.NickName = dr["NickName"].ToString(); dto.SkypeID = dr["SkypeID"].ToString(); dto.TeacherID = dr["TeacherID"].ToString(); dto.TeacherName = dr["TeacherName"].ToString(); dto.StartDate = int.Parse(dr["StartDate"].ToString()); dto.EndDate = int.Parse(dr["EndDate"].ToString()); dto.ClassTime = dr["ClassTime"].ToString(); dto.Minutes = int.Parse(dr["Minutes"].ToString()); dto.BookCode = dr["BookCode"].ToString(); dto.BookName = dr["BookName"].ToString(); dto.Complete = int.Parse(dr["Complete"].ToString()); dto.Present = int.Parse(dr["Present"].ToString()); dto.Absent = int.Parse(dr["Absent"].ToString()); dto.Postpone = int.Parse(dr["Postpone"].ToString()); dto.Vacation = int.Parse(dr["Vacation"].ToString()); dto.Cancel = int.Parse(dr["Cancel"].ToString()); dto.TotalDays = int.Parse(dr["TotalDays"].ToString()); dto.RemainingDays = int.Parse(dr["RemainingDays"].ToString()); dto.Progress = int.Parse(dr["Progress"].ToString()); lstDto.Add(dto); } dic.Add("history", lstDto); } } } } catch (Exception ex) { dic = null; } return dic; }