public SectionBO Create(SectionBO section) { using (var uow = _facade.UnitOfWork) { // TODO check if entity is valid, and throw errors if not var sectionCreated = uow.SectionRepo.Create(_sectionConv.Convert(section)); uow.Complete(); return(_sectionConv.Convert(sectionCreated)); } }
private DataTable FetchSection(int intSchoolID) { // DataTable dtStudent = new DataTable(); SectionBL objSectionBL = new SectionBL(); SectionBO objSectionBO = new SectionBO(); ApplicationResult objResults = new ApplicationResult(); objResults = objSectionBL.Section_SelectAll_ForDropDown(intSchoolID); if (objResults.status == ApplicationResult.CommonStatusType.SUCCESS && objResults.resultDT.Rows.Count > 0) { } return(objResults.resultDT); }
public SectionBO Update(SectionBO section) { using (var uow = _facade.UnitOfWork) { var sectionFromDb = uow.SectionRepo.Get(section.Id); if (sectionFromDb == null) { return(null); } sectionFromDb.Title = section.Title; sectionFromDb.CourseId = section.CourseId; uow.Complete(); return(_sectionConv.Convert(sectionFromDb)); } }
/// <summary> /// To Insert details of Section in tbl_Section_M table /// Created By : NafisaMulla, 4/7/2014 /// Modified By : /// </summary> /// <param name="objSectionBO"></param> /// <returns></returns> public ApplicationResult Section_Insert(SectionBO objSectionBO) { try { pSqlParameter = new SqlParameter[6]; pSqlParameter[0] = new SqlParameter("@SectionName", SqlDbType.VarChar); pSqlParameter[0].Direction = ParameterDirection.Input; pSqlParameter[0].Value = objSectionBO.SectionName; pSqlParameter[1] = new SqlParameter("@SectionAvbbreviation", SqlDbType.VarChar); pSqlParameter[1].Direction = ParameterDirection.Input; pSqlParameter[1].Value = objSectionBO.SectionAvbbreviation; pSqlParameter[2] = new SqlParameter("@Description", SqlDbType.VarChar); pSqlParameter[2].Direction = ParameterDirection.Input; pSqlParameter[2].Value = objSectionBO.Description; pSqlParameter[3] = new SqlParameter("@LastModifiedUserID", SqlDbType.Int); pSqlParameter[3].Direction = ParameterDirection.Input; pSqlParameter[3].Value = objSectionBO.LastModifiedUserID; pSqlParameter[4] = new SqlParameter("@LastModifiedDate", SqlDbType.VarChar); pSqlParameter[4].Direction = ParameterDirection.Input; pSqlParameter[4].Value = objSectionBO.LastModifiedDate; pSqlParameter[5] = new SqlParameter("@IsDeleted", SqlDbType.Int); pSqlParameter[5].Direction = ParameterDirection.Input; pSqlParameter[5].Value = objSectionBO.IsDeleted; sSql = "usp_tbl_Section_M_Insert"; DataTable dtResult = new DataTable(); dtResult = DatabaseTransaction.ExecuteDataTable(CommandType.StoredProcedure, sSql, pSqlParameter); ApplicationResult objResults = new ApplicationResult(dtResult); objResults.status = ApplicationResult.CommonStatusType.SUCCESS; return(objResults); } catch (Exception ex) { throw ex; } finally { objSectionBO = null; } }
public SectionBO Get(int id) { using (var uow = _facade.UnitOfWork) { SectionBO section = null; var secFromDb = uow.SectionRepo.Get(id); if (secFromDb != null) { var convCourse = _crsConv.Convert(secFromDb.Course); var convLessons = secFromDb.Lessons?.Select(l => _lesConv.Convert(l)).ToList(); section = _sectionConv.Convert(secFromDb); section.Course = convCourse; section.Lessons = convLessons; /*section.Lessons = uow.LessonRepo.GetAllById(section.LessonIds) * .Select(l => _lesConv.Convert(l)) * .ToList();*/ } uow.Complete(); return(section); } }
public void SeedData() { #region User creation var user = new UserRegisterDto() { Username = "******", Password = "******" }; var userCreated = _authService.Register(user); var educator = new UserRegisterDto() { Username = "******", Password = "******" }; var educatorCreated = _authService.Register(educator); _userService.Promote(educatorCreated.Id); var admin = new UserRegisterDto() { Username = "******", Password = "******" }; _userService.Promote(_userService.Promote(_userService.Promote(_authService.Register(admin).Id).Id).Id); List <int> userIds = new List <int>(); userIds.Add(userCreated.Id); var category = new CategoryBO() { Name = "Math" }; #endregion var favCategory = _catService.Create(category); #region Building course var lessons = new List <LessonBO>(); for (int i = 0; i < 20; i++) { var lesson = new LessonBO() { Title = "Hello" + i, VideoId = "dogs.mp4" }; lessons.Add(lesson); } var section = new SectionBO() { Title = "Everyone likes dogs", Lessons = lessons }; var lesson1ForSection2 = new LessonBO() { Title = "Lesson 2 title", VideoId = "long.mp4" }; var otherlessons = new List <LessonBO>(); otherlessons.Add(lesson1ForSection2); var section2 = new SectionBO() { Title = "Long video", Lessons = otherlessons }; var lesson1ForSection3 = new LessonBO() { Title = "Lesson 1 title", VideoId = "dogs.mp4" }; var section3Lessons = new List <LessonBO>(); section3Lessons.Add(lesson1ForSection3); var section3 = new SectionBO() { Title = "Section 3", Lessons = section3Lessons }; var sections = new List <SectionBO>(); sections.Add(section); sections.Add(section2); //sections.Add(section3); var material = new List <LessonBO>(); material.Add(new LessonBO() { VideoId = "dogs.mp4", Title = "Dogs" }); material.Add(new LessonBO() { VideoId = "long.mp4", Title = "Long" }); var course = new CourseBO() { Name = " Building Course", UserIds = userIds, CategoryId = favCategory.Id, Sections = sections, CreatorId = educatorCreated.Id, Published = true, Description = "Your body can’t digest corn. So if you ate literally nothing but corn every day you’d reach the point where you’re s******g out pure corn and then you’ve got an infinite food source.", Lessons = material }; _courseService.Create(course); #endregion #region filler courses for (int i = 0; i < 50; i++) { bool published = true; if (i % 10 == 0) { published = false; // crsUserIds.Add(userCreated.Id); } List <int> crsUserIds = new List <int>(); if ((i + 1) % 2 == 0) { crsUserIds.Add(userCreated.Id); } if ((i + 1) % 13 == 0) { crsUserIds.Add(educatorCreated.Id); } string flower = "flower"; if (i > 1 || i < 1) { flower += "s"; } var crs = new CourseBO() { Name = " Course" + i, CreatorId = educatorCreated.Id, UserIds = crsUserIds, CategoryId = favCategory.Id, Description = i + " " + flower + " in the garden", Published = published }; _courseService.Create(crs); } #endregion #region categories var cat_1 = new CategoryBO() { Name = "Electronics" }; var cat_2 = new CategoryBO() { Name = "Business " }; var cat_3 = new CategoryBO() { Name = "Robotics" }; var cat_4 = new CategoryBO() { Name = "Graphic Design" }; var cat_5 = new CategoryBO() { Name = "Information Technology" }; var cat_6 = new CategoryBO() { Name = "English" }; var cat_7 = new CategoryBO() { Name = "Spanish" }; var cat_8 = new CategoryBO() { Name = "Visual Arts" }; var cat_9 = new CategoryBO() { Name = "Marketing" }; var cat_10 = new CategoryBO() { Name = "Productivity" }; var cat_11 = new CategoryBO() { Name = "Leadership" }; var cat1 = _catService.Create(cat_1); var cat2 = _catService.Create(cat_2); var cat3 = _catService.Create(cat_3); var cat4 = _catService.Create(cat_4); var cat5 = _catService.Create(cat_5); var cat6 = _catService.Create(cat_6); var cat7 = _catService.Create(cat_7); var cat8 = _catService.Create(cat_8); var cat9 = _catService.Create(cat_9); var cat10 = _catService.Create(cat_10); var cat11 = _catService.Create(cat_11); #endregion }
/// <summary> /// To Update details of Section in tbl_Section_M table /// Created By : NafisaMulla, 4/7/2014 /// Modified By : /// </summary> /// <param name="objSectionBO"></param> /// <returns></returns> public ApplicationResult Section_Update(SectionBO objSectionBO) { try { pSqlParameter = new SqlParameter[7]; pSqlParameter[0] = new SqlParameter("@SectionMID", SqlDbType.Int); pSqlParameter[0].Direction = ParameterDirection.Input; pSqlParameter[0].Value = objSectionBO.SectionMID; pSqlParameter[1] = new SqlParameter("@SectionName", SqlDbType.VarChar); pSqlParameter[1].Direction = ParameterDirection.Input; pSqlParameter[1].Value = objSectionBO.SectionName; pSqlParameter[2] = new SqlParameter("@SectionAvbbreviation", SqlDbType.VarChar); pSqlParameter[2].Direction = ParameterDirection.Input; pSqlParameter[2].Value = objSectionBO.SectionAvbbreviation; pSqlParameter[3] = new SqlParameter("@Description", SqlDbType.VarChar); pSqlParameter[3].Direction = ParameterDirection.Input; pSqlParameter[3].Value = objSectionBO.Description; pSqlParameter[4] = new SqlParameter("@LastModifiedUserID", SqlDbType.Int); pSqlParameter[4].Direction = ParameterDirection.Input; pSqlParameter[4].Value = objSectionBO.LastModifiedUserID; pSqlParameter[5] = new SqlParameter("@LastModifiedDate", SqlDbType.VarChar); pSqlParameter[5].Direction = ParameterDirection.Input; pSqlParameter[5].Value = objSectionBO.LastModifiedDate; pSqlParameter[6] = new SqlParameter("@IsDeleted", SqlDbType.Int); pSqlParameter[6].Direction = ParameterDirection.Input; pSqlParameter[6].Value = objSectionBO.IsDeleted; sSql = "usp_tbl_Section_M_Update"; int iResult = DatabaseTransaction.ExecuteNonQuery(CommandType.StoredProcedure, sSql, pSqlParameter); if (iResult > 0) { ApplicationResult objResults = new ApplicationResult(); objResults.status = ApplicationResult.CommonStatusType.SUCCESS; return(objResults); } else { ApplicationResult objResults = new ApplicationResult(); objResults.status = ApplicationResult.CommonStatusType.FAILURE; return(objResults); } } catch (Exception ex) { throw ex; } finally { objSectionBO = null; } }
protected void btnSave_Click(object sender, EventArgs e) { try { ApplicationResult objResults = new ApplicationResult(); SectionBO objSectionBO = new SectionBO(); SectionBL objSectionBL = new SectionBL(); SectionTBO objSectionTBO = new SectionTBO(); objSectionBO.SectionName = txtSectionName.Text; objSectionBO.SectionAvbbreviation = txtAbbreviation.Text; objSectionBO.Description = txtSectionDesc.Text; objSectionBO.LastModifiedDate = DateTime.UtcNow.AddHours(5.5).ToString(); objSectionBO.LastModifiedUserID = Convert.ToInt32(Session[ApplicationSession.USERID]); if (ValidateName() == true) { ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script language='javascript'>alert('Section Name or/and Section Abbrev " + txtSectionName.Text + "/" + txtAbbreviation.Text + " Already Exists.');</script>"); goto Exit; } #region RollBack Transaction Starts DatabaseTransaction.OpenConnectionTransation(); if (ViewState["Mode"].ToString() == "Save") { objResults = objSectionBL.Section_Insert(objSectionBO); if (objResults != null) { if (objResults.resultDT.Rows.Count > 0) { ViewState["SectionMID"] = Convert.ToInt32(objResults.resultDT.Rows[0][0].ToString()); objSectionTBO.SectionMID = Convert.ToInt32(ViewState["SectionMID"].ToString()); objSectionTBO.SchoolMID = Convert.ToInt32(Session[ApplicationSession.SCHOOLID]); objSectionTBO.MediumMID = 1; objSectionTBO.LastModifiedDate = DateTime.UtcNow.AddHours(5.5).ToString(); objSectionTBO.LastModifiedUserID = Convert.ToInt32(Session[ApplicationSession.USERID]); objResults = objSectionBL.SectionT_Insert(objSectionTBO); if (objResults.status == ApplicationResult.CommonStatusType.SUCCESS) { } } } ClearAll(); ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script language='javascript'>alert('Section Created Successfully.');</script>"); //GridDataBind(); PanelGrid_VisibilityMode(1); } else { ApplicationResult objResultsUpdate = new ApplicationResult(); objSectionBO.SectionMID = Convert.ToInt32(ViewState["SectionMID"].ToString()); objResultsUpdate = objSectionBL.Section_Update(objSectionBO); if (objResultsUpdate.status == ApplicationResult.CommonStatusType.SUCCESS) { ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script language='JavaScript'>alert('Section updated successfully.');</script>"); ClearAll(); } } DatabaseTransaction.CommitTransation(); GridDataBind(); #endregion Exit :; } catch (Exception ex) { logger.Error("Error", ex); ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Oops! There is some technical issue. Please Contact to your administrator.');</script>"); } }