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