public int CourseSessionMaterials_CheckDAL(CourseMaterials _objCourseMaterials)
{
return(ExecuteScalarSPInt32("TMS_CourseSessionMaterials_Check",
ParamBuilder.Par("ID", _objCourseMaterials.ID),
// ParamBuilder.Par("PrimaryMaterial", _objCourseMaterials.PrimaryMaterial),
ParamBuilder.Par("OrganizationID", _objCourseMaterials.OrganizationID)));
}
/// <summary>
/// Courses the materials delete dal.
/// </summary>
/// <param name="_objCourseMaterials">The object course materials.</param>
/// <returns>System.Int32.</returns>
public int CourseMaterials_DeleteDAL(CourseMaterials _objCourseMaterials)
{
return(ExecuteScalarInt32Sp("TMS_CourseMaterials_Delete",
ParamBuilder.Par("ID", _objCourseMaterials.ID),
ParamBuilder.Par("UpdatedBy", _objCourseMaterials.UpdatedBy),
ParamBuilder.Par("UpdatedDate", _objCourseMaterials.UpdatedDate)));
}
public ActionResult Index(Guid?id)
{
if (id == null)
{
return(RedirectToAction("Index", "Home"));
}
if (!isMember(id) && !isCourseCreator(id))
{
return(RedirectToAction("Index", "Course", new { id = id }));
}
var chapters =
db.Chapters.Where(c => c.Course.Id == id).Select(e => new
{
e, Materials = e.Materials.Where(m => m.IsActive)
}).AsEnumerable().Select(e => e.e).ToList();
var course = db.Courses.FirstOrDefault(i => i.Id == id);
var model = new CourseMaterials
{
CourseId = (Guid)id,
CanEdit = isCourseCreator(id),
ChapterList = chapters,
IsItActive = course.IsCourseActive
};
return(View(model));
}
/// <summary>
/// Courses the materials update dal.
/// </summary>
/// <param name="_objCourseMaterials">The object course materials.</param>
/// <returns>System.Int32.</returns>
public int CourseMaterials_UpdateDAL(CourseMaterials _objCourseMaterials)
{
return(ExecuteScalarInt32Sp("TMS_CourseMaterials_Update",
ParamBuilder.Par("ID", _objCourseMaterials.ID),
ParamBuilder.Par("PrimaryMaterial", _objCourseMaterials.PrimaryMaterial),
ParamBuilder.Par("SecondaryMaterial", _objCourseMaterials.SecondaryMaterial),
ParamBuilder.Par("UpdatedBy", _objCourseMaterials.UpdatedBy),
ParamBuilder.Par("UpdatedDate", _objCourseMaterials.UpdatedDate)));
}
/// <summary>
/// Courses the materials create dal.
/// </summary>
/// <param name="_objCourseMaterials">The object course materials.</param>
/// <returns>System.Int64.</returns>
public long CourseMaterials_CreateDAL(CourseMaterials _objCourseMaterials)
{
var parameters = new[] { ParamBuilder.Par("ID", 0) };
return(ExecuteInt64withOutPutparameterSp("TMS_CourseMaterials_Create", parameters,
ParamBuilder.Par("PrimaryMaterial", _objCourseMaterials.PrimaryMaterial),
ParamBuilder.Par("SecondaryMaterial", _objCourseMaterials.SecondaryMaterial),
ParamBuilder.Par("OrganizationID", _objCourseMaterials.OrganizationID),
ParamBuilder.Par("CreatedBy", _objCourseMaterials.CreatedBy),
ParamBuilder.Par("CreatedDate", _objCourseMaterials.CreatedDate)));
}
public int CourseSessionMaterials_CheckBAL(CourseMaterials _objCourseMaterials) => _ConfigurationDAL.CourseSessionMaterials_CheckDAL(_objCourseMaterials);
/// <summary> /// Courses the materials duplication check bal. /// </summary> /// <param name="_objCourseMaterials">The object course materials.</param> /// <returns>System.Int32.</returns> public int CourseMaterials_DuplicationCheckBAL(CourseMaterials _objCourseMaterials) => _ConfigurationDAL.CourseMaterials_DuplicationCheckDAL(_objCourseMaterials);
/// <summary> /// Courses the materials delete bal. /// </summary> /// <param name="_objCourseMaterials">The object course materials.</param> /// <returns>System.Int32.</returns> public int CourseMaterials_DeleteBAL(CourseMaterials _objCourseMaterials) => _ConfigurationDAL.CourseMaterials_DeleteDAL(_objCourseMaterials);
/// <summary> /// Courses the materials create bal. /// </summary> /// <param name="_objCourseMaterials">The object course materials.</param> /// <returns>System.Int64.</returns> public long CourseMaterials_CreateBAL(CourseMaterials _objCourseMaterials) => _ConfigurationDAL.CourseMaterials_CreateDAL(_objCourseMaterials);
