public List<GenericBE> GetAssessmentTypeList() { List<GenericBE> GenericList = new List<GenericBE>(); try { DbCommand objSelectCommand = objDB.GetStoredProcCommand("Get_AssessmentTypes"); IDataReader drList = objDB.ExecuteReader(objSelectCommand); while (drList.Read()) { GenericBE GenericEntity = new GenericBE(); if (!drList.IsDBNull(0)) GenericEntity.AssessmentTypeName = drList.GetString(2); if (!drList.IsDBNull(1)) GenericEntity.AssessmentTypeID = drList.GetInt32(0); GenericList.Add(GenericEntity); } if (!drList.IsClosed) drList.Close(); return GenericList; } catch (Exception ex) { return GenericList; } }
private IEnumerable<GenericBE> ConvertToEnumerableList(DataTable dataTable) { List<GenericBE> _AnswerLoad = new List<GenericBE>(); foreach (DataRow row in dataTable.Rows) { GenericBE objGenericModel = new GenericBE { CourseItemID = Convert.ToInt32(row["CourseItemID"]), CourseItemDescription = row["CourseItemDescription"].ToString(), CreateDate = Convert.ToDateTime(row["CreateDate"]).Date, ParentCourseItemID = Convert.ToInt32(row["ParentCourseItemID"]), AccountID = Convert.ToInt64(row["AccountID"]), UserName = row["FullName"].ToString(), CommentCount = Convert.ToInt32(row["CommentCount"]), VoteCount = Convert.ToInt32(row["VoteCount"]), VoteUpDisplay = Convert.ToInt32("0"), SystemObjectName = row["SystemObjectName"].ToString(), SystemObjectID = Convert.ToInt32(row["SystemObjectID"]), CourseID = Convert.ToInt32(row["CourseID"]), StarDisplay = Convert.ToInt32("0"), StarCount = Convert.ToInt32("0"), }; _AnswerLoad.Add(objGenericModel); } return (IEnumerable<GenericBE>)_AnswerLoad; }
public ActionResult LoadChildCount(int CourseItemID) { GenericBE objGenericModel = new GenericBE(); if (CourseItemID > 0) { CourseItem objCourseItem = new CourseItem(); int Childcout = objCourseItem.GetCourseItemChildCount(CourseItemID); objGenericModel.CourseItemChildCount = Childcout; } return View(objGenericModel); }
public ActionResult DiscussionByDiscussionID(int DID) { long AccountID; int SystemObjectID = (int)SystemObject.Discussion; GenericBE objGenericModel = new GenericBE(); if (Request.Cookies["ID"] != null) { AccountID = Convert.ToInt64(Request.Cookies["ID"].Value.ToString()); CourseItem objCourseItem = new CourseItem(); objGenericModel = objCourseItem.CourseItemDetails(AccountID, SystemObjectID, DID).Single(DiscussionID => DiscussionID.CourseItemID == DID); } return View(objGenericModel); }
public ActionResult QuestionByQuestionID(int QID) { long AccountID; int SystemObjectID = (int)SystemObject.Questions; CourseItem objCourseItem = new CourseItem(); GenericBE objGenericBE = new GenericBE(); if (Request.Cookies["ID"] != null) { AccountID = Convert.ToInt64(Request.Cookies["ID"].Value.ToString()); objGenericBE = objCourseItem.CourseItemDetails(AccountID, SystemObjectID, QID).Single(Question => Question.CourseItemID == QID); } return View(objGenericBE); }
public List<GenericBE> GetFiles(int CourseItemID, int CourseID, int SystemObjectID) { List<GenericBE> GenericList = new List<GenericBE>(); try { DbCommand objSelectCommand = objDB.GetStoredProcCommand("CL_GetFilesByCourseItemID"); objDB.AddInParameter(objSelectCommand, "@CourseItemID", DbType.Int32, CourseItemID); objDB.AddInParameter(objSelectCommand, "@CourseID", DbType.Int32, CourseID); objDB.AddInParameter(objSelectCommand, "@SystemObjectID", DbType.Int32, SystemObjectID); objDS = objDB.ExecuteDataSet(objSelectCommand); IDataReader drList = objDB.ExecuteReader(objSelectCommand); while (drList.Read()) { GenericBE GenericEntity = new GenericBE(); if (!drList.IsDBNull(0)) GenericEntity.FileID = drList.GetInt32(0); if (!drList.IsDBNull(1)) GenericEntity.CourseItemID = drList.GetInt32(1); if (!drList.IsDBNull(2)) GenericEntity.CourseID = drList.GetInt32(2); if (!drList.IsDBNull(3)) GenericEntity.AccountID = drList.GetInt64(3); if (!drList.IsDBNull(4)) GenericEntity.FileExtensions = drList.GetString(4); if (!drList.IsDBNull(5)) GenericEntity.FileName = drList.GetString(5); if (!drList.IsDBNull(6)) GenericEntity.SystemObjectID = drList.GetInt32(6); GenericList.Add(GenericEntity); } if (!drList.IsClosed) drList.Close(); return GenericList; } catch (Exception ex) { return GenericList; } }
public ActionResult SummaryBySummaryID(int SID) { long AccountID; int SystemObjectID = (int)SystemObject.Summary; CourseItem objCourseItem = new CourseItem(); GenericBE objGenericModel = new GenericBE(); if (Request.Cookies["ID"] != null) { AccountID = Convert.ToInt64(Request.Cookies["ID"].Value.ToString()); objGenericModel = objCourseItem.CourseItemDetails(AccountID, SystemObjectID, SID).Single(Summary => Summary.CourseItemID == SID); } return View(objGenericModel); }
public List<GenericBE> GetCourseDetail(long AccountID, int CourseID) { List<GenericBE> StudentCoursesList = new List<GenericBE>(); try { DbCommand objSelectCommand = objDB.GetStoredProcCommand("CL_GetCourseByCourseIDForCourseIntroduction"); objDB.AddInParameter(objSelectCommand, "@CourseID", DbType.Int32, CourseID); objDB.AddInParameter(objSelectCommand, "@AccountID", DbType.Int64, AccountID); objDS = objDB.ExecuteDataSet(objSelectCommand); IDataReader drList = objDB.ExecuteReader(objSelectCommand); while (drList.Read()) { GenericBE CoursesEntity = new GenericBE(); if (!drList.IsDBNull(0)) CoursesEntity.CourseID = drList.GetInt32(0); if (!drList.IsDBNull(1)) CoursesEntity.Prefix = drList.GetString(1); if (!drList.IsDBNull(2)) CoursesEntity.CourseTitle = drList.GetString(2); if (!drList.IsDBNull(3)) CoursesEntity.CourseNumber = drList.GetString(3); if (!drList.IsDBNull(4)) CoursesEntity.Course_Section = drList.GetString(4); if (!drList.IsDBNull(5)) CoursesEntity.Year = drList.GetInt32(5); if (!drList.IsDBNull(6)) CoursesEntity.IsCourseVerfiy = drList.GetBoolean(6); StudentCoursesList.Add(CoursesEntity); } if (!drList.IsClosed) drList.Close(); return StudentCoursesList; } catch (Exception ex) { return StudentCoursesList; } }
public List<GenericBE> GetFalshCardSets(int CourseID) { List<GenericBE> GenericList = new List<GenericBE>(); try { DbCommand objSelectCommand = objDB.GetStoredProcCommand("CL_GetFlashCardSets"); objDB.AddInParameter(objSelectCommand, "@CourseID", DbType.Int64, CourseID); objDS = objDB.ExecuteDataSet(objSelectCommand); IDataReader drList = objDB.ExecuteReader(objSelectCommand); while (drList.Read()) { GenericBE GenericEntity = new GenericBE(); if (!drList.IsDBNull(0)) GenericEntity.FlashCardID = drList.GetInt32(0); if (!drList.IsDBNull(1)) GenericEntity.FlashCardTitle = drList.GetString(1); if (!drList.IsDBNull(2)) GenericEntity.FlashCardSubject = drList.GetString(2); if (!drList.IsDBNull(3)) GenericEntity.FlashCardDescription = drList.GetString(3); if (!drList.IsDBNull(4)) GenericEntity.AccountID = drList.GetInt64(4); if (!drList.IsDBNull(5)) GenericEntity.TotalItems = drList.GetInt32(5); if (!drList.IsDBNull(6)) GenericEntity.FlashCardSetCreateDateTime = drList.GetDateTime(6); GenericList.Add(GenericEntity); } if (!drList.IsClosed) drList.Close(); return GenericList; } catch (Exception ex) { return GenericList; } }
public ActionResult TermByTermID(int TID) { long AccountID; int SystemObjectID = (int)(SystemObject.Terms); CourseItem objCourseItem = new CourseItem(); GenericBE objGenericBE = new GenericBE(); if (Request.Cookies["ID"] != null) { AccountID = Convert.ToInt64(Request.Cookies["ID"].Value.ToString()); objGenericBE = objCourseItem.CourseItemDetails(AccountID, SystemObjectID, TID).Single(Term => Term.CourseItemID == TID); } return View(objGenericBE); }
public ActionResult SearchCourse() { GenericBE objGenericBE = new GenericBE(); long AccountID = 0; if (Request.Cookies["ID"] != null) { AccountID = Convert.ToInt64(Request.Cookies["ID"].Value); } objGenericBE.AccountID = AccountID; objGenericBE.Prefix = ""; objGenericBE.CourseTitle = ""; objGenericBE.CourseNumber = ""; objGenericBE.SchoolID = 0; objGenericBE.Course_Section = ""; objGenericBE.TermID = 0; return View(objGenericBE); }
public List<GenericBE> GetCoursesByCourseID(int CourseID) { List<GenericBE> CourseDetailsList = new List<GenericBE>(); try { DbCommand objSelectCommand = objDB.GetStoredProcCommand("CL_GetCourseByCourseID"); objDB.AddInParameter(objSelectCommand, "@CourseID", DbType.Int32, CourseID); objDS = objDB.ExecuteDataSet(objSelectCommand); IDataReader drList = objDB.ExecuteReader(objSelectCommand); while (drList.Read()) { GenericBE CoursesEntity = new GenericBE(); if (!drList.IsDBNull(0)) CoursesEntity.CourseID = drList.GetInt32(0); if (!drList.IsDBNull(1)) CoursesEntity.Prefix = drList.GetString(1); if (!drList.IsDBNull(2)) CoursesEntity.CourseTitle = drList.GetString(2); if (!drList.IsDBNull(3)) CoursesEntity.CourseNumber = drList.GetString(3); CourseDetailsList.Add(CoursesEntity); } if (!drList.IsClosed) drList.Close(); return CourseDetailsList; } catch (Exception ex) { return CourseDetailsList; } }
public List<GenericBE> GetAllItems(int CourseID, int IsTopVoted, int PageNumber) { List<GenericBE> GenericList = new List<GenericBE>(); try { DbCommand objSelectCommand = objDB.GetStoredProcCommand("CL_Get_AllItemList"); objDB.AddInParameter(objSelectCommand, "@CourseID", DbType.Int64, CourseID); objDB.AddInParameter(objSelectCommand, "@TopVoted", DbType.Int64, IsTopVoted); objDB.AddInParameter(objSelectCommand, "@PageNumber", DbType.Int32, PageNumber); objDS = objDB.ExecuteDataSet(objSelectCommand); IDataReader drList = objDB.ExecuteReader(objSelectCommand); while (drList.Read()) { GenericBE GenericEntity = new GenericBE(); if (!drList.IsDBNull(0)) GenericEntity.CourseItemID = drList.GetInt32(0); if (!drList.IsDBNull(1)) GenericEntity.CourseItemTitle = drList.GetString(1); if (!drList.IsDBNull(2)) GenericEntity.CourseItemDescription = drList.GetString(2).Replace("&", "&"); if (!drList.IsDBNull(3)) GenericEntity.CreateDate = drList.GetDateTime(3); if (!drList.IsDBNull(4)) GenericEntity.AccountID = drList.GetInt64(4); if (!drList.IsDBNull(5)) GenericEntity.CourseID = drList.GetInt32(5); if (!drList.IsDBNull(6)) GenericEntity.IsActive = drList.GetBoolean(6); if (!drList.IsDBNull(7)) GenericEntity.UserName = drList.GetString(7); if (!drList.IsDBNull(8)) GenericEntity.CourseItemChildCount = drList.GetInt32(8); if (!drList.IsDBNull(9)) GenericEntity.StarCount = drList.GetInt32(9); if (!drList.IsDBNull(10)) GenericEntity.VoteCount = drList.GetInt32(10); if (!drList.IsDBNull(11)) GenericEntity.CommentCount = drList.GetInt32(11); if (!drList.IsDBNull(12)) GenericEntity.ProfileImage = drList.GetString(12); if (!drList.IsDBNull(13)) GenericEntity.SystemObjectID = drList.GetInt32(13); if (!drList.IsDBNull(14)) GenericEntity.SystemObjectName = drList.GetString(14); if (!drList.IsDBNull(15)) GenericEntity.ParentCourseItemID = drList.GetInt32(15); if (!drList.IsDBNull(3)) GenericEntity.PostedDate = GetTimeSpan(drList.GetDateTime(3)); if (!drList.IsDBNull(16)) GenericEntity.CourseHomePageNumber = drList.GetInt32(16); if (!drList.IsDBNull(17)) GenericEntity.TotalCourseHomeItemNumber = drList.GetInt32(17); GenericList.Add(GenericEntity); } if (!drList.IsClosed) drList.Close(); return GenericList; } catch (Exception ex) { return GenericList; } }
public List<GenericBE> SetCommentDefault(long AssociatedID, int CourseID) { List<GenericBE> _CommentList = new List<GenericBE>(); GenericBE objGenericModel = new GenericBE { CourseItemID = 0, ParentCourseItemID = Convert.ToInt32(AssociatedID), CourseID = CourseID, }; _CommentList.Add(objGenericModel); return _CommentList; }
public List<GenericBE> Search_CoursesList(int StudentAccountID, string Prefix, string CourseNumber, string CourseTitle, string CourseSection, int SchoolID, int TermID, int Year, int PageNumber) { List<GenericBE> CourseDetailsList = new List<GenericBE>(); try { DbCommand objSelectCommand = objDB.GetStoredProcCommand("CL_Search_CoursesList"); objDB.AddInParameter(objSelectCommand, "@StudentAccountID", DbType.Int64, StudentAccountID); objDB.AddInParameter(objSelectCommand, "@SearchText", DbType.String, CourseTitle); objDB.AddInParameter(objSelectCommand, "@Section", DbType.String, CourseSection); objDB.AddInParameter(objSelectCommand, "@Number", DbType.String, CourseNumber); objDB.AddInParameter(objSelectCommand, "@Prefix", DbType.String, Prefix); objDB.AddInParameter(objSelectCommand, "@PageNumber", DbType.Int32, PageNumber); objDB.AddInParameter(objSelectCommand, "@SchoolID", DbType.Int32, SchoolID); objDB.AddInParameter(objSelectCommand, "@TermID", DbType.Int32, TermID); objDB.AddInParameter(objSelectCommand, "@Year", DbType.Int32, Year); objDS = objDB.ExecuteDataSet(objSelectCommand); IDataReader drList = objDB.ExecuteReader(objSelectCommand); while (drList.Read()) { GenericBE CoursesEntity = new GenericBE(); if (!drList.IsDBNull(0)) CoursesEntity.CourseID = drList.GetInt32(0); if (!drList.IsDBNull(1)) CoursesEntity.CourseTitle = drList.GetString(1); if (!drList.IsDBNull(2)) CoursesEntity.Course_Section = drList.GetString(2); if (!drList.IsDBNull(3)) CoursesEntity.CourseNumber = drList.GetString(3); if (!drList.IsDBNull(4)) CoursesEntity.Prefix = drList.GetString(4); if (!drList.IsDBNull(5)) CoursesEntity.TermName = drList.GetString(5); if (!drList.IsDBNull(6)) CoursesEntity.SchoolName = drList.GetString(6); if (!drList.IsDBNull(7)) CoursesEntity.Year = drList.GetInt32(7); if (!drList.IsDBNull(8)) CoursesEntity.SearchCoursePageNumber = drList.GetInt32(8); if (!drList.IsDBNull(9)) CoursesEntity.TotalCourses = drList.GetInt32(9); CourseDetailsList.Add(CoursesEntity); } if (!drList.IsClosed) drList.Close(); return CourseDetailsList; } catch (Exception ex) { return CourseDetailsList; } }
public List<GenericBE> Get_Courses() { List<GenericBE> CourseDetailsList = new List<GenericBE>(); try { DbCommand objSelectCommand = objDB.GetStoredProcCommand("CL_Get_Courses"); objDS = objDB.ExecuteDataSet(objSelectCommand); IDataReader drList = objDB.ExecuteReader(objSelectCommand); while (drList.Read()) { GenericBE CoursesEntity = new GenericBE(); if (!drList.IsDBNull(0)) CoursesEntity.CourseID = drList.GetInt32(0); if (!drList.IsDBNull(1)) CoursesEntity.CourseTitle = drList.GetString(1); if (!drList.IsDBNull(2)) CoursesEntity.Course_Section = drList.GetString(2); if (!drList.IsDBNull(3)) CoursesEntity.CourseNumber = drList.GetString(3); if (!drList.IsDBNull(4)) CoursesEntity.Prefix = drList.GetString(4); if (!drList.IsDBNull(5)) CoursesEntity.TermName = drList.GetString(5); if (!drList.IsDBNull(6)) CoursesEntity.SchoolName = drList.GetString(6); if (!drList.IsDBNull(7)) CoursesEntity.Year = drList.GetInt32(7); CourseDetailsList.Add(CoursesEntity); } if (!drList.IsClosed) drList.Close(); return CourseDetailsList; } catch (Exception ex) { return CourseDetailsList; } }
public List<GenericBE> TempPlay(int FlashCard) { List<GenericBE> GenericList = new List<GenericBE>(); try { DbCommand objSelectCommand = objDB.GetStoredProcCommand("CL_Get_All_FlashCardSetItem"); objDB.AddInParameter(objSelectCommand, "@FlashCardID", DbType.Int32, FlashCard); objDS = objDB.ExecuteDataSet(objSelectCommand); IDataReader drList = objDB.ExecuteReader(objSelectCommand); while (drList.Read()) { GenericBE GenericEntity = new GenericBE(); if (!drList.IsDBNull(0)) GenericEntity.FlashCardSetID = drList.GetInt32(0); if (!drList.IsDBNull(1)) GenericEntity.FlashCardID = drList.GetInt32(1); if (!drList.IsDBNull(2)) GenericEntity.CourseItemID = drList.GetInt32(2); if (!drList.IsDBNull(3)) GenericEntity.SystemObjectID = drList.GetInt32(3); if (!drList.IsDBNull(4)) GenericEntity.CourseID = drList.GetInt32(4); if (!drList.IsDBNull(5)) GenericEntity.PageFlag = drList.GetInt32(5); if (!drList.IsDBNull(6)) GenericEntity.CourseItemTitle = drList.GetString(6); if ((drList.GetInt32(3) == 4) || (drList.GetInt32(3) == 8)) { if(!drList.IsDBNull(7)) GenericEntity.CourseItemDescription = drList.GetString(7); } else { if (!drList.IsDBNull(8)) GenericEntity.CourseItemDescription = drList.GetString(8); } GenericList.Add(GenericEntity); } if (!drList.IsClosed) drList.Close(); return GenericList; } catch (Exception ex) { return GenericList; } }
public ActionResult LoadAddItem(GenericBE model) { //return View(model); return RedirectToAction("LoadAddItem", new { CourseItemID = model.CourseItemID, CourseID = model.CourseID, SystemObjectName = model.SystemObjectName }); }
public List<GenericBE> GetItemList(int CourseID, int SystemObjectID, long AccountID) { List<GenericBE> GenericList = new List<GenericBE>(); try { DbCommand objSelectCommand = objDB.GetStoredProcCommand("CL_Get_ItemList"); objDB.AddInParameter(objSelectCommand, "@CourseID", DbType.Int32, CourseID); objDB.AddInParameter(objSelectCommand, "@SystemObjectID", DbType.Int32, SystemObjectID); objDB.AddInParameter(objSelectCommand, "@AccountID", DbType.Int64, AccountID); IDataReader drList = objDB.ExecuteReader(objSelectCommand); while (drList.Read()) { GenericBE GenericEntity = new GenericBE(); if (!drList.IsDBNull(0)) GenericEntity.CourseItemID = drList.GetInt32(0); if (!drList.IsDBNull(1)) GenericEntity.CourseItemTitle = drList.GetString(1); if (!drList.IsDBNull(2)) GenericEntity.CourseItemDescription = drList.GetString(2); if (!drList.IsDBNull(3)) GenericEntity.CreateDate = drList.GetDateTime(3); if (!drList.IsDBNull(4)) GenericEntity.AccountID = drList.GetInt64(4); if (!drList.IsDBNull(5)) GenericEntity.CourseID = drList.GetInt32(5); if (!drList.IsDBNull(6)) GenericEntity.IsActive = drList.GetBoolean(6); if (!drList.IsDBNull(7)) GenericEntity.UserName = drList.GetString(7); if (!drList.IsDBNull(8)) GenericEntity.CourseItemChildCount = drList.GetInt32(8); if (!drList.IsDBNull(9)) GenericEntity.StarCount = drList.GetInt32(9); if (!drList.IsDBNull(10)) GenericEntity.VoteCount = drList.GetInt32(10); if (!drList.IsDBNull(11)) GenericEntity.CommentCount = drList.GetInt32(11); if (!drList.IsDBNull(12)) GenericEntity.ProfileImage = drList.GetString(12); if (!drList.IsDBNull(3)) GenericEntity.PostedDate = GetTimeSpan(drList.GetDateTime(3)); GenericList.Add(GenericEntity); } if (!drList.IsClosed) drList.Close(); return GenericList; } catch (Exception ex) { return GenericList; } }
public GenericBE CommentByCommentID(int CID, string SystemObjectName, long AccountID) { //GenericBE GenericList = new GenericBE(); GenericBE GenericEntity = new GenericBE(); try { DbCommand objInsertCommand = objDB.GetStoredProcCommand("CL_Get_CommentsByCommentID"); objDB.AddInParameter(objInsertCommand, "@SystemObjectName", DbType.String, SystemObjectName); objDB.AddInParameter(objInsertCommand, "@AssociatedID", DbType.Int32, CID); objDB.AddInParameter(objInsertCommand, "@AccountID", DbType.Int64, AccountID); // objDS = objDB.ExecuteDataSet(objInsertCommand); IDataReader drList = objDB.ExecuteReader(objInsertCommand); while (drList.Read()) { if (!drList.IsDBNull(0)) GenericEntity.CourseItemID = drList.GetInt32(0); if (!drList.IsDBNull(1)) GenericEntity.CourseItemDescription = drList.GetString(1).Replace("#||#", "\'"); ; if (!drList.IsDBNull(2)) GenericEntity.CreateDate = drList.GetDateTime(2); if (!drList.IsDBNull(3)) GenericEntity.ParentCourseItemID = drList.GetInt32(3); if (!drList.IsDBNull(4)) GenericEntity.AccountID = drList.GetInt64(4); if (!drList.IsDBNull(5)) GenericEntity.UserName = drList.GetString(5); if (!drList.IsDBNull(6)) GenericEntity.CommentCount = drList.GetInt32(6); if (!drList.IsDBNull(7)) GenericEntity.VoteCount = drList.GetInt32(7); if (!drList.IsDBNull(8)) GenericEntity.VoteUpDisplay = drList.GetInt32(8); if (!drList.IsDBNull(9)) GenericEntity.SystemObjectName = drList.GetString(9); if (!drList.IsDBNull(10)) GenericEntity.CourseID = drList.GetInt32(10); if (!drList.IsDBNull(11)) GenericEntity.SystemObjectID = drList.GetInt32(11); if (!drList.IsDBNull(12)) GenericEntity.StarCount = drList.GetInt32(12); if (!drList.IsDBNull(13)) GenericEntity.ProfileImage = drList.GetString(13); } if (!drList.IsClosed) drList.Close(); return GenericEntity; } catch (Exception ex) { return GenericEntity; } }
public ActionResult LoadAddItem(int CourseItemID, int CourseID, string SystemObjectName, string IsCourseHomePage) { GenericBE objGenericModel = new GenericBE(); int SystemObjectID = (int)Enum.Parse(typeof(SystemObject), SystemObjectName); if (CourseItemID <= 0) { // load default answer new answer //objGenericModel.ParentCourseItemID = ParentCID; objGenericModel.CourseID = CourseID; objGenericModel.SystemObjectName = SystemObjectName; objGenericModel.CourseID = CourseID; objGenericModel.IsAddItem = true; objGenericModel.IsCourseHomePage = Convert.ToInt32(IsCourseHomePage); //return View(objGenericModel); } else if (CourseItemID > 0) { // Call Database and get value long AccountID; CourseItem objCourseItem = new CourseItem(); if (Request.Cookies["ID"] != null) { AccountID = Convert.ToInt64(Request.Cookies["ID"].Value.ToString()); objGenericModel = objCourseItem.CourseItemDetails(AccountID, SystemObjectID, CourseItemID).Single(); } objGenericModel.IsAddItem = false; objGenericModel.IsCourseHomePage = Convert.ToInt32(IsCourseHomePage); } using (CuteWebUI.MvcUploader uploader = new CuteWebUI.MvcUploader(System.Web.HttpContext.Current)) { uploader.UploadUrl = Response.ApplyAppPathModifier("~/UploadHandler.ashx"); //the data of the uploader will render as <input type='hidden' name='myuploader'> uploader.Name = "myuploader"; uploader.AllowedFileExtensions = "*.jpg,*.gif,*.png,*.bmp,*.doc,*.docx,*.pdf,*.xls,*.xlsx,*.ppt,*.ppsx"; //allow select multiple files uploader.MultipleFilesUpload = true; uploader.ManualStartUpload = true; //tell uploader attach a button uploader.InsertButtonID = "uploadbutton"; //prepair html code for the view ViewData["uploaderhtml"] = uploader.Render(); } return View(objGenericModel); }
public List<GenericBE> GetDiscussionListingCourseHome(int CourseID, int AccountID, int SystemobjectID, int PageNumber, int TopVoted, int MyAdded) { List<GenericBE> GenericList = new List<GenericBE>(); try { DbCommand objSelectCommand = objDB.GetStoredProcCommand("CL_GetItem_By_ItemType"); objDB.AddInParameter(objSelectCommand, "@CourseID", DbType.Int64, CourseID); objDB.AddInParameter(objSelectCommand, "@TopVoted", DbType.Int64, TopVoted); objDB.AddInParameter(objSelectCommand, "@MyAdded", DbType.Int32, MyAdded); objDB.AddInParameter(objSelectCommand, "@AccountID", DbType.Int32, AccountID); objDB.AddInParameter(objSelectCommand, "@PageNumber", DbType.Int32, PageNumber); objDB.AddInParameter(objSelectCommand, "@sysID", DbType.Int32, SystemobjectID); objDS = objDB.ExecuteDataSet(objSelectCommand); IDataReader drList = objDB.ExecuteReader(objSelectCommand); while (drList.Read()) { GenericBE GenericEntity = new GenericBE(); if (!drList.IsDBNull(0)) GenericEntity.CourseItemID = drList.GetInt32(0); if (!drList.IsDBNull(1)) GenericEntity.CourseItemTitle = drList.GetString(1); if (!drList.IsDBNull(2)) GenericEntity.CourseItemDescription = drList.GetString(2).Replace("&", "&"); if (!drList.IsDBNull(3)) GenericEntity.CreateDate = drList.GetDateTime(3); if (!drList.IsDBNull(4)) GenericEntity.AccountID = drList.GetInt64(4); if (!drList.IsDBNull(5)) GenericEntity.CourseID = drList.GetInt32(5); if (!drList.IsDBNull(6)) GenericEntity.IsActive = drList.GetBoolean(6); if (!drList.IsDBNull(7)) GenericEntity.UserName = drList.GetString(7); if (!drList.IsDBNull(8)) GenericEntity.ProfileImage = drList.GetString(8); if (!drList.IsDBNull(9)) GenericEntity.SystemObjectID = drList.GetInt32(9); if (!drList.IsDBNull(10)) GenericEntity.SystemObjectName = drList.GetString(10); if (!drList.IsDBNull(11)) GenericEntity.ParentCourseItemID = drList.GetInt32(11); if (!drList.IsDBNull(12)) GenericEntity.VoteCount = drList.GetInt32(12); if (!drList.IsDBNull(13)) GenericEntity.CommentCount = drList.GetInt32(13); if (!drList.IsDBNull(14)) GenericEntity.PageNumber = drList.GetInt32(14); if (!drList.IsDBNull(15)) GenericEntity.Section = drList.GetInt32(15); if (!drList.IsDBNull(16)) GenericEntity.Chapter = drList.GetInt32(16); if (!drList.IsDBNull(17)) GenericEntity.StarDisplay = drList.GetInt32(17); if (!drList.IsDBNull(18)) GenericEntity.CourseHomePageNumber = drList.GetInt32(18); if (!drList.IsDBNull(19)) GenericEntity.Discussion_Rank = drList.GetString(19); if (!drList.IsDBNull(20)) GenericEntity.PageFlag = drList.GetInt32(20); if (!drList.IsDBNull(3)) GenericEntity.PostedDate = GetTimeSpan(drList.GetDateTime(3)); if (MyAdded == 1) GenericEntity.IsMyAdded = true; GenericList.Add(GenericEntity); } if (!drList.IsClosed) drList.Close(); return GenericList; } catch (Exception ex) { return GenericList; } }
public List<GenericBE> GetFlashCardByFlashCardID(int CourseID, int AccountID, int FlashCardID) { List<GenericBE> GenericList = new List<GenericBE>(); try { DbCommand objSelectCommand = objDB.GetStoredProcCommand("CL_GetFlashCardByFlashCardID"); objDB.AddInParameter(objSelectCommand, "@CourseID", DbType.Int64, CourseID); objDB.AddInParameter(objSelectCommand, "@AccountID", DbType.Int64, AccountID); objDB.AddInParameter(objSelectCommand, "@FlashCardID", DbType.Int32, FlashCardID); objDS = objDB.ExecuteDataSet(objSelectCommand); IDataReader drList = objDB.ExecuteReader(objSelectCommand); while (drList.Read()) { GenericBE GenericEntity = new GenericBE(); if (!drList.IsDBNull(0)) GenericEntity.FlashCardID = drList.GetInt32(0); if (!drList.IsDBNull(1)) GenericEntity.FlashCardTitle = drList.GetString(1); if (!drList.IsDBNull(2)) GenericEntity.FlashCardSubject = drList.GetString(2); if (!drList.IsDBNull(3)) GenericEntity.FlashCardDescription = drList.GetString(3); if (!drList.IsDBNull(4)) GenericEntity.AccountID = drList.GetInt64(4); if (!drList.IsDBNull(5)) GenericEntity.TotalItems = drList.GetInt32(5); if (!drList.IsDBNull(6)) GenericEntity.CourseID = drList.GetInt32(6); if (!drList.IsDBNull(7)) GenericEntity.IsQuestion = drList.GetBoolean(7); if (!drList.IsDBNull(8)) GenericEntity.IsNotes = drList.GetBoolean(8); if (!drList.IsDBNull(9)) GenericEntity.IsTerms = drList.GetBoolean(9); if (!drList.IsDBNull(10)) GenericEntity.IsSummary = drList.GetBoolean(10); if (!drList.IsDBNull(11)) GenericEntity.IsChapter = drList.GetBoolean(11); if (!drList.IsDBNull(12)) GenericEntity.CommonSeperatedChapter = drList.GetString(12); if (!drList.IsDBNull(13)) GenericEntity.IsYourAdded = drList.GetBoolean(13); if (!drList.IsDBNull(14)) GenericEntity.IsVotedUp = drList.GetBoolean(14); if (!drList.IsDBNull(15)) GenericEntity.IsFavourted = drList.GetBoolean(15); if (!drList.IsDBNull(16)) GenericEntity.IsAssessment = drList.GetBoolean(16); if (!drList.IsDBNull(17)) GenericEntity.CreateDate = drList.GetDateTime(17); GenericList.Add(GenericEntity); } if (!drList.IsClosed) drList.Close(); return GenericList; } catch (Exception ex) { return GenericList; } }
public List<GenericBE> LoadComments(long AssociatedID, string SystemObjectName, long AccountID, Boolean IsLoadTwoComments) { List<GenericBE> GenericList = new List<GenericBE>(); try { DbCommand objInsertCommand = objDB.GetStoredProcCommand("CL_Get_CommentsByAssociatedID"); objDB.AddInParameter(objInsertCommand, "@SystemObjectName", DbType.String, SystemObjectName); objDB.AddInParameter(objInsertCommand, "@AssociatedID", DbType.Int32, AssociatedID); objDB.AddInParameter(objInsertCommand, "@AccountID", DbType.Int64, AccountID); objDB.AddInParameter(objInsertCommand, "@IsLoadTwoComment", DbType.Boolean, IsLoadTwoComments); // objDS = objDB.ExecuteDataSet(objInsertCommand); IDataReader drList = objDB.ExecuteReader(objInsertCommand); while (drList.Read()) { GenericBE GenericEntity = new GenericBE(); if (!drList.IsDBNull(0)) GenericEntity.CourseItemID = drList.GetInt32(0); if (!drList.IsDBNull(1)) GenericEntity.CourseItemDescription = drList.GetString(1).Replace("#||#", "\'"); if (!drList.IsDBNull(2)) GenericEntity.CreateDate = drList.GetDateTime(2); if (!drList.IsDBNull(3)) GenericEntity.ParentCourseItemID = drList.GetInt32(3); if (!drList.IsDBNull(4)) GenericEntity.AccountID = drList.GetInt64(4); if (!drList.IsDBNull(5)) GenericEntity.UserName = drList.GetString(5); if (!drList.IsDBNull(6)) GenericEntity.CommentCount = drList.GetInt32(6); if (!drList.IsDBNull(7)) GenericEntity.VoteCount = drList.GetInt32(7); if (!drList.IsDBNull(8)) GenericEntity.VoteUpDisplay = drList.GetInt32(8); if (!drList.IsDBNull(9)) GenericEntity.SystemObjectName = drList.GetString(9); if (!drList.IsDBNull(10)) GenericEntity.CourseID = drList.GetInt32(10); if (!drList.IsDBNull(11)) GenericEntity.SystemObjectID = drList.GetInt32(11); if (!drList.IsDBNull(12)) GenericEntity.StarCount = drList.GetInt32(12); if (!drList.IsDBNull(13)) GenericEntity.ProfileImage = drList.GetString(13); if (!drList.IsDBNull(14)) GenericEntity.Discussion_Rank = drList.GetString(14); if (!drList.IsDBNull(2)) GenericEntity.PostedDate = GetTimeSpan(drList.GetDateTime(2)); GenericList.Add(GenericEntity); } if (!drList.IsClosed) drList.Close(); return GenericList; } catch (Exception ex) { return GenericList; } }
public List<GenericBE> GetFlashCardSetSelectionItem(int CourseID, int AccountID, bool VotedUp, bool Favorite, bool YouAdded, bool Assessment, bool IsChapter, string CommaSeperatedChapters, bool IsNotesSelected, bool IsQuestionSelected, bool IsTermSelected, bool IsSummarySelected) { List<GenericBE> GenericList = new List<GenericBE>(); try { DbCommand objSelectCommand = objDB.GetStoredProcCommand("CL_GetItemsForFlashCardSet"); objDB.AddInParameter(objSelectCommand, "@CourseID", DbType.Int32, CourseID); objDB.AddInParameter(objSelectCommand, "@AccountID", DbType.Int64, AccountID); objDB.AddInParameter(objSelectCommand, "@IsVotedUpSelected", DbType.Boolean, VotedUp); objDB.AddInParameter(objSelectCommand, "@IsFavoriteSelected", DbType.Boolean, Favorite); objDB.AddInParameter(objSelectCommand, "@IsYouAddedSelected", DbType.Boolean, YouAdded); objDB.AddInParameter(objSelectCommand, "@IsAssessmentSelected", DbType.Boolean, Assessment); objDB.AddInParameter(objSelectCommand, "@IsChapterSelected", DbType.Boolean, IsChapter); objDB.AddInParameter(objSelectCommand, "@CommaSeperatedChapters", DbType.String, CommaSeperatedChapters); objDB.AddInParameter(objSelectCommand, "@IsNotesSelected", DbType.Boolean, IsNotesSelected); objDB.AddInParameter(objSelectCommand, "@IsQuestionSelected", DbType.Boolean, IsQuestionSelected); objDB.AddInParameter(objSelectCommand, "@IsTermSelected", DbType.Boolean, IsTermSelected); objDB.AddInParameter(objSelectCommand, "@IsSummarySelected", DbType.Boolean, IsSummarySelected); objDS = objDB.ExecuteDataSet(objSelectCommand); IDataReader drList = objDB.ExecuteReader(objSelectCommand); while (drList.Read()) { GenericBE GenericEntity = new GenericBE(); if (!drList.IsDBNull(0)) GenericEntity.CourseItemID = drList.GetInt32(0); if (!drList.IsDBNull(1)) GenericEntity.CourseID = drList.GetInt32(1); if (!drList.IsDBNull(2)) GenericEntity.AccountID = drList.GetInt64(2); if (!drList.IsDBNull(3)) GenericEntity.CourseItemTitle = drList.GetString(3); if (!drList.IsDBNull(4)) GenericEntity.SystemObjectID = drList.GetInt32(4); if (!drList.IsDBNull(5)) GenericEntity.SystemObjectName = drList.GetString(5); GenericList.Add(GenericEntity); } if (!drList.IsClosed) drList.Close(); return GenericList; } catch (Exception ex) { return GenericList; } }