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