private void LoadCourseDetail()
{
using (var helper = new DbHelper.Subject())
{
var course = helper.Find(CourseId);
//lblTitle.Text = course.Name;
//lblSummary.Text = course.Summary;
if (course != null)
{
var sections = course.SubjectSections;
if (sections != null)
{
var unVoidedSections = sections.Where(x => !(x.Void ?? false));
foreach (var subjectSection in unVoidedSections)
{
SectionUc sectionuc = (SectionUc)Page.LoadControl("~/Views/Course/Section/SectionUc.ascx");
sectionuc.SummaryVisible = subjectSection.ShowSummary ?? false;
sectionuc.SubjectId = subjectSection.SubjectId;
sectionuc.SectionId = subjectSection.Id;
pnlSections.Controls.Add(sectionuc);
}
}
}
}
//CreateSectionUc uc = (CreateSectionUc)Page.LoadControl("~/Views/Course/Section/CreateSectionUc.ascx");
//uc.ID = "createSection";
//uc.Visible = false;
//uc.SubjectId = CourseId;
//uc.OnSaveEvent += uc_OnSaveEvent;
//pnlSections.Controls.Add(uc);
}
void LoadCourses(int categoryId)
{
var catId = categoryId.ToString();
var selected = new List <int>();
foreach (ListItem i in lstAssignedCourses.Items)
{
//value has two fields -- '0'=courseId, '1'=categoryId, '2'- earlier credit,
//'3'-elective , '4'-currently assigned credit
var cat = i.Value.Split(new char[] { '_' });
//only select those which are in same category
if (catId == cat[1])
{
selected.Add(Convert.ToInt32(cat[0]));
}
}
using (var helper = new DbHelper.Subject())
{
var unAssignedCourses = helper.ListCourses(ProgramId, categoryId, selected);
foreach (var subject in unAssignedCourses)
{
lstUnAssignedCourses.Items.Add(new ListItem()
{
Value = subject.Id + "_" + subject.SubjectCategoryId + "_" + subject.Credit //+(false).ToString(),
,
Text = subject.FullName
});
}
}
}
void GetSubCategory(DbHelper.Subject helper, int schoolId, int categoryId
, int paddingPosition)
{
paddingPosition++;
var subCategories = helper.ListSubCategories(schoolId, categoryId);
foreach (var cat in subCategories)
{
var spaces = " ";
for (int j = 0; j < paddingPosition * 4; j++)
{
spaces += " ";
}
var litem = new ListItem()
{
Text = spaces + cat.Name
};
litem.Attributes.Add("style", "padding-left:" + (paddingPosition * 4) + "px");
var catLink = new LinkButton()
{
Text = cat.Name
,
ID = "category_" + cat.Id
};
catLink.Click += catLink_Click;
catLink.Style.Add("padding-left", ((paddingPosition) * 16) + "px");
pnlCategories.Controls.Add(catLink);
GetSubCategory(helper, schoolId, cat.Id, paddingPosition);
}
}
private void CourseCategoryDelete()
{
var user = Page.User as CustomPrincipal;
if (user != null)
{
if (user.IsInRole("manager") || user.IsInRole(DbHelper.StaticValues.Roles.CourseEditor))
{
//var courseId = Request.QueryString["crsId"];
var categoryId = Request.QueryString["catId"];
if (categoryId != null)
{
var catId = Convert.ToInt32(categoryId);
using (var courseHelper = new DbHelper.Subject())
{
var deleted = courseHelper.DeleteCategory(catId);
if (deleted)
{
Response.Redirect("~/Views/Course/", false);
}
else
{
lblError.Visible = true;
}
}
}
}
else
{
Response.Redirect("~/Views/All_Resusable_Codes/Error/ErrorPage.aspx?error=" +
DbHelper.StaticValues.GetEncodedError(1)
);
}
}
}
void GetSubCats(Category.ListUC parentUc, DbHelper.Subject helper, int schoolId, int categoryId, int paddingCount)
{
#region Function all
var edit = Manager;
var subcats = helper.ListSubCategories(schoolId, categoryId);
var selectedCat = SelectedCategory;
for (var s = 0; s < subcats.Count; s++)
{
var catUc = (Category.ListUC)Page.LoadControl("~/Views/Course/Category/ListUC.ascx");
catUc.Deselect();
catUc.SetNameAndIdOfCategory(subcats[s].Id, subcats[s].Name, paddingCount, edit);//list
paddingCount += 1;
catUc.NameClicked += catUc_NameClicked;
catUc.ID = "category_" + subcats[s].Id;
//parentUc.AddSubCategories(catUc);
pnlCategories.Controls.Add(catUc);
if ((selectedCat == subcats[s].Id && !IsPostBack) || selectedCat == 0)
{
catUc_NameClicked(catUc, new DataEventArgs()
{
Id = subcats[s].Id,
Name = subcats[s].Name
});
catUc.Select();
selectedCat = subcats[s].Id;
}
GetSubCats(catUc, helper, schoolId, subcats[s].Id, paddingCount);
}
#endregion
}
void LoadCourses(int categoryId)
{
using (var helper = new DbHelper.Subject())
{
//dlistCourses.DataSource = null;
dlistCourses.DataSource = helper.ListCourses(categoryId);
dlistCourses.DataBind();
}
}
private void BindData()
{
using (var helper = new DbHelper.Subject())
{
var levelId = Convert.ToInt32(cmbLevel.SelectedValue == ""?"0":cmbLevel.SelectedValue);
var subjects = helper.ListSubjects(levelId);
grdView.DataSource = subjects;
grdView.DataBind();
//grdView.Columns.Add(new datacontrolfie); = "";
}
}
private void LoadCourse(int courseId)
{
using (var helper = new DbHelper.Subject())
{
var sub = helper.Find(courseId);
if (sub != null)
{
txtSubjectName.Text = sub.FullName;
CourseDetailUc1.CourseId = Id;
}
//CourseDetailUc1.
}
}
private void LoadData()
{
using (var helper = new DbHelper.Subject())
{
var subClss = helper.ListEarlierSubjectClasses(UserId);
var againCurrent = subClss.Where(x => !(x.SessionComplete ?? false)).ToList();
var againCurrentSubs = againCurrent.Where(x => x.IsRegular).Select(x => x.SubjectStructure.Subject).Distinct()
.Select(x => x.Id).ToList();
//var reg =
var run = subClss.Where(x => x.IsRegular && (x.SessionComplete ?? false)).GroupBy(x => x.RunningClass).ToList();
foreach (var r in run)
{
var nodeuc =
(EarlierUc_NodesUc)Page.LoadControl("~/ViewsSite/User/ModulesUc/EarlierUc_NodesUc.ascx");
//key is used to display year/subyear
var subjects = r.Select(x => x.SubjectStructure.Subject)
.Distinct()
.Where(x => !againCurrentSubs.Contains(x.Id))
.Distinct().OrderBy(x => x.FullName).ToList();
nodeuc.SetStructureData(r.Key.Year, r.Key.SubYear, subjects);
pnlRegularCourses.Controls.Add(nodeuc);
}
againCurrentSubs = againCurrent.Where(x => !x.IsRegular).Select(x => x.Subject).Distinct()
.Select(x => x.Id).ToList();
var irrRun = subClss.Where(x => !x.IsRegular && (x.SessionComplete ?? false))
.Select(x => x.Subject).Distinct().Where(x => !againCurrentSubs.Contains(x.Id))
.Distinct().OrderBy(x => x.FullName).ToList();
if (irrRun.Any())
{
divNonRegular.Visible = true;
dListNonRegularSubjects.DataSource = irrRun;
dListNonRegularSubjects.DataBind();
}
else
{
if (!run.Any())
{
if (EmptyData != null)
{
EmptyData(this, new EventArgs());
}
}
divNonRegular.Visible = false;
dListNonRegularSubjects.DataSource = null;
dListNonRegularSubjects.DataBind();
}
}
}
//earlier code:::: works
// Note :: ├ ==>1 , └ ==> 2 . ┌ ==> 3 , │ ==> 4 , empty ==> 0
void GetSubCats(Category.ListUC parentUc, DbHelper.Subject helper, int schoolId, int categoryId, List <int> parentPaddingList)
{
#region Function all
var subcats = helper.ListSubCategories(schoolId, categoryId);
var list = new List <int>();
if (subcats.Count > 0)
{
foreach (var i in parentPaddingList)
{
list.Add(0);
}
}
var selectedCat = SelectedCategory;
for (var s = 0; s < subcats.Count; s++)
{
var catUc = (Category.ListUC)Page.LoadControl("~/Views/Course/Category/ListUC.ascx");
catUc.Deselect();
list.Add((parentPaddingList[parentPaddingList.Count - 1] == 1) ? 2 : 1);
catUc.SetNameAndIdOfCategory(subcats[s].Id, subcats[s].Name, list, false);//list
catUc.NameClicked += catUc_NameClicked;
catUc.ID = "category_" + subcats[s].Id;
//parentUc.AddSubCategories(catUc);
pnlCategories.Controls.Add(catUc);
if ((selectedCat == subcats[s].Id && !IsPostBack) || selectedCat == 0)
{
catUc_NameClicked(catUc, new DataEventArgs()
{
Id = subcats[s].Id,
Name = subcats[s].Name
});
catUc.Select();
selectedCat = subcats[s].Id;
}
GetSubCats(catUc, helper, schoolId, subcats[s].Id, list);
list.RemoveAt(list.Count - 1);
}
#endregion
}
public void LoadCourseList(string edit, int yearId, int subYearId = 0)
{
hidYearId.Value = yearId.ToString();
hidSubYearId.Value = subYearId.ToString();
hidEdit.Value = edit;
//AddCourses1.YearId = yearId;
//AddCourses1.SubYearId = subYearId;
using (var helper = new DbHelper.Subject())
{
var courseList = helper.ListCoursesOfStructure(yearId, subYearId);
dlistCourses.DataSource = courseList;
dlistCourses.DataBind();
}
}
private void PopulateCourseData(int courseId)
{
using (var helper = new DbHelper.Subject())
{
var course = helper.GetCourse(courseId);
if (course != null)
{
if (SiteMap.CurrentNode != null)
{
var list = new List <IdAndName>()
{
new IdAndName()
{
Name = SiteMap.RootNode.Title
, Value = SiteMap.RootNode.Url
, Void = true
},
new IdAndName()
{
Name = SiteMap.CurrentNode.ParentNode.Title
, Value = SiteMap.CurrentNode.ParentNode.Url
, Void = true
}
,
new IdAndName()
{
Name = course.FullName
, Value = "~/Views/Course/CourseDetail.aspx?cId=" + course.Id
, Void = true
}
, new IdAndName()
{
Name = "Edit"
}
};
SiteMapUc.SetData(list);
}
txtName.Text = course.FullName;
txtShortName.Text = course.ShortName;
txtCode.Text = course.Code;
txtCredit.Text = course.Credit.ToString();
CKEditor1.Text = course.Summary;
CategoryId = CategoryId;
}
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
var user = Page.User as CustomPrincipal;
if (user != null)
{
if (Page.IsValid)
{
Subject subject = new Subject()
{
Id = CourseId,
FullName = txtName.Text,
ShortName = txtShortName.Text,
Code = txtCode.Text,
Credit = Convert.ToInt32(string.IsNullOrEmpty(txtCredit.Text) ? "0" : txtCredit.Text),
SubjectCategoryId = CategoryId,
Summary = CKEditor1.Text
};
if (CourseId == 0)
{
subject.CreatedDate = DateTime.Now.Date;
subject.CreatedById = user.Id;
}
using (var helper = new DbHelper.Subject())
{
var saved = helper.AddOrUpdateSubject(subject);
if (saved)
{
if (CourseId > 0)
{
Response.Redirect("~/Views/Course/CourseDetail.aspx?cId=" + CourseId);
}
else
{
Response.Redirect("~/Views/Course/?catId=" + CategoryId);
}
}
else
{
lblError.Visible = true;
}
}
}
}
}
private void LoadAssignedList()
{
using (var helper = new DbHelper.Subject())
{
var assignedCourses = helper.ListCoursesOfStructure(YearId, SubYearId);
//ViewState["SavedCourses"] = assignedCourses;
foreach (var subject in assignedCourses)
{
lstAssignedCourses.Items.Add(new ListItem()
{
Value = subject.Id + "_" + subject.CategoryId + "_" + subject.Credit + "_" + subject.IsElective.ToString(),
Text = subject.Name
});
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
//AddCourses1.CancelClicked += AddCourses_ReturnClicked;
//AddCourses1.SaveClicked += AddCourses_ReturnClicked;
var user = Page.User as CustomPrincipal;
if (user != null)
{
if (!IsPostBack)
{
if (user.IsInRole("manager"))
{
var edit = (Session["editMode"] as string) ?? "0";
var showBtn = Request.QueryString["swMgBt"];
var show = showBtn != null && showBtn == "1";
btnManageSubject.Visible = edit == "1" || show;
}
else
{
btnManageSubject.Visible = false;
}
using (var helper = new DbHelper.Subject())
{
var courses = helper.ListCoursesOfStructure(YearId, SubYearId);
dlistCourses.DataSource = courses;
dlistCourses.DataBind();
//courses.ForEach(x =>
//{
// savedCourses.Add(new Subject()
// {
// Id = x.Id
// ,
// Name = x.Name
// ,
// CategoryId = x.SubjectCategoryId
// ,
// Checked = false
// });
//});
//ViewState["SavedCourses"] = savedCourses;
}
}
}
}
void LoadCategories(int schoolId)
{
var selectedCat = SelectedCategory;
using (var helper = new DbHelper.Subject())
{
var cats = helper.ListAllCategories(schoolId);
var list = new List <int>();
if (!cats.Any())
{
lnkCoursCreate.Visible = false;
}
var edit = Manager;
for (var c = 0; c < cats.Count; c++)
{
var catUc = (Category.ListUC)Page.LoadControl("~/Views/Course/Category/ListUC.ascx");
catUc.Deselect();
list.Add(1);
catUc.SetNameAndIdOfCategory(cats[c].Id, cats[c].Name, 0, edit);//list
catUc.NameClicked += catUc_NameClicked;
catUc.ID = "category_" + cats[c].Id;
pnlCategories.Controls.Add(catUc);
if ((selectedCat == cats[c].Id && !IsPostBack) || selectedCat == 0)
{
catUc_NameClicked(catUc, new DataEventArgs()
{
Id = cats[c].Id,
Name = cats[c].Name
});
catUc.Select();
selectedCat = cats[c].Id;
}
//GetSubCats(catUc, helper, schoolId, cats[c].Id, list);
GetSubCats(catUc, helper, schoolId, cats[c].Id, 1);
list.RemoveAt(list.Count - 1);
}
}
}
private void LoadData()
{
var catId = Request.QueryString["catId"];
if (catId != null)
{
var categoryId = Convert.ToInt32(catId);
using (var helper = new DbHelper.Subject())
{
var category = helper.GetCategory(categoryId);
if (category != null)
{
CategoryId = categoryId;
txtName.Text = category.Name;
txtDescription.Text = category.Description;
ParentCategoryId = category.ParentId ?? 0;
}
}
}
}
public static List <DbEntities.Subjects.SubjectCategory> LoadSubjectCategory(ref DropDownList cmbCategory,
int schoolId, bool includeTopAlso = false, bool includeEmptyField = false, int selectedValue = 0)
{
cmbCategory.DataTextField = "Name";
cmbCategory.DataValueField = "Id";
using (var helper = new DbHelper.Subject())
{
var cats = helper.GetCategories(schoolId);
if (includeTopAlso)
{
cats.Insert(0, new DbEntities.Subjects.SubjectCategory()
{
Id = 0,
Name = " Top "
});
}
if (includeEmptyField)
{
cats.Insert(0, new DbEntities.Subjects.SubjectCategory()
{
Id = -1,
Name = ""
});
}
cmbCategory.DataSource = cats;
cmbCategory.DataBind();
if (selectedValue > 0)
{
var index = cats.IndexOf(cats.First(x => x.Id == selectedValue));
if (index >= 0)
{
cmbCategory.SelectedIndex = index;
}
}
return(cats.ToList());
}
}
private void CourseSectionDelete()
{
var user = Page.User as CustomPrincipal;
if (user != null)
{
if (user.IsInRole("manager") ||
user.IsInRole(DbHelper.StaticValues.Roles.CourseEditor) ||
user.IsInRole("teacher"))
{
var courseId = Request.QueryString["crsId"];
var sectionId = Request.QueryString["secId"];
if (courseId != null && sectionId != null)
{
var secId = Convert.ToInt32(sectionId);
using (var courseHelper = new DbHelper.Subject())
{
var deleted = courseHelper.DeleteSection(secId);
if (deleted)
{
Response.Redirect("~/Views/Course/Section/default.aspx?SubId=" + courseId
+ "&edit=1", false);
}
else
{
lblError.Visible = true;
}
}
}
}
else
{
Response.Redirect("~/Views/All_Resusable_Codes/Error/ErrorPage.aspx?error=" +
DbHelper.StaticValues.GetEncodedError(1)
);
}
}
}
} //Earlier
/*var regularincomplete = subSession.Where(x => x.IsRegular)
* .Select(x => x.SubjectStructure.Subject).ToList();
* var notregularincomplete = subSession.Where(x => !x.IsRegular)
* .Select(x => x.Subject).ToList();
* regularincomplete.AddRange(notregularincomplete);*/
private void LoadData()
{
using (var helper = new DbHelper.Subject())
{
#region Using Subject Class but its not complete
var subClss = helper.ListCurrentSubjectClasses(UserId);
var run = subClss.Where(x => x.IsRegular).GroupBy(x => x.RunningClass);
foreach (var r in run)
{
var nodeuc = (EarlierUc_NodesUc)
Page.LoadControl("~/ViewsSite/User/ModulesUc/EarlierUc_NodesUc.ascx");
//key is used to display year/subyear
var subjects = r.Select(x => x.SubjectStructure.Subject).Distinct().OrderBy(x => x.FullName).ToList();
nodeuc.SetStructureData(r.Key.Year, r.Key.SubYear, subjects);
pnlRegularCourses.Controls.Add(nodeuc);
//lbltitle.ToolTip = r.Key.ProgramBatch.NameFromBatch;
}
var irrRun = subClss.Where(x => !x.IsRegular)
.Select(x => x.Subject).Distinct().OrderBy(x => x.FullName).ToList();
if (irrRun.Any())
{
divNonRegular.Visible = true;
dListNonRegularSubjects.DataSource = irrRun;
dListNonRegularSubjects.DataBind();
}
else
{
divNonRegular.Visible = false;
dListNonRegularSubjects.DataSource = null;
dListNonRegularSubjects.DataBind();
}
#endregion
}
}
public static List <DbEntities.Subjects.Subject> LoadSubject(ref DropDownList cmbSubject, int schoolId)
{
cmbSubject.DataTextField = "Name";
cmbSubject.DataValueField = "Id";
using (var helper = new DbHelper.Subject())
{
var cats = helper.GetSubjectList(schoolId);
//if (includeEmptyField)
{
cats.Insert(0, new DbEntities.Subjects.Subject()
{
Id = 0,
FullName = ""
});
}
cmbSubject.DataSource = cats;
cmbSubject.DataBind();
return(cats.ToList());
}
}
//public String ReturnUrl
//{
// set
// {
// btnCancel.Visible = true;
// hidRetUrl.Value = value;
// }
//}
protected void btnSave_Click(object sender, EventArgs e)
{
if (Page.IsValid)
{
var cat = new Academic.DbEntities.Subjects.SubjectCategory()
{
Id = CategoryId
,
SchoolId = SchoolId
,
CreatedDate = DateTime.Now.Date
,
Description = txtDescription.Text
,
IsActive = chkIsActive.Checked
,
Name = txtName.Text
};
if (!(cmbCategory.SelectedValue == "" || cmbCategory.SelectedValue == "0" || cmbCategory.SelectedValue == "-1"))
{
cat.ParentId = Convert.ToInt32(cmbCategory.SelectedValue);
}
using (var helper = new DbHelper.Subject())
{
var save = helper.AddOrUpdateSubjectCategory(cat);
if (save != null)
{
Response.Redirect("~/Views/Course/?catId=" + save.Id);
}
else
{
lblError.Visible = true;
}
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
//examOfClass
var eoc = Request.QueryString["eocId"];
if (eoc != null)
{
try
{
hidExamOfClassId.Value = eoc;
using (var ehelper = new DbHelper.Exam())
using (var shelper = new DbHelper.Subject())
using (var bhelper = new DbHelper.Batch())
{
var examClass = ehelper.GetExamOfClass(ExamOfClassId);
if (examClass != null)
{
//UI title and other controls
lblExamName.Text = examClass.Exam.Name;
lblClassName.Text = examClass.RunningClass.ProgramBatch.NameFromBatch;
//Courses in this exam
var lst = shelper.ListExamCourses(examClass.Id);
var i = 1;
foreach (var es in lst)
{
pnlSubjects.Controls.Add(new HyperLink()
{
Text = i + ". " + es.SubjectClass.SubjectStructure.Subject.FullName + "<br/>"
,
CssClass = "margin-top-bottom-little"
});
i++;
}
//students in the exam
i = 1;
var stds = bhelper.ListStudentsOfProgramBatch(examClass.RunningClass.ProgramBatch.Id);
foreach (var s in stds)
{
pnlStudents.Controls.Add(new HiddenField()
{
Value = s.UserId.ToString()
});
pnlStudents.Controls.Add(new Label()
{
Text = i + ". "
});
pnlStudents.Controls.Add(new Image()
{
ImageUrl = s.ImageUrl
,
Width = 40
,
Height = 40
,
BorderColor = Color.LightSlateGray
,
BorderWidth = 1
,
BorderStyle = BorderStyle.Solid
,
//CssClass = "margin-top-bottom-little"
});
pnlStudents.Controls.Add(new HyperLink()
{
Text = " " + s.CRN + " " + s.Name + "<br/>"
,
CssClass = "margin-top-bottom-little"
});
i++;
}
}
}
}
catch { }
}
}
}
List <IdAndName> GetCourse()
{
var subId = Request.QueryString["SubId"];
var fromCls = Request.QueryString["from"];
var yId = Request.QueryString["yId"];
var sId = Request.QueryString["sId"];
using (var helper = new DbHelper.Subject())
{
var list = new List <IdAndName>();
var sub = helper.Find(Convert.ToInt32(subId));
// if (SiteMap.CurrentNode != null)
// {
list.Add(new IdAndName()
{
Name = "Home", //SiteMap.RootNode.Title,
Value = "~/", //SiteMap.RootNode.Url,
Void = true
});
if (sId != null && yId != null)
{
//lnkEdit.NavigateUrl += "&yId=" + yId + "&sId=" + sId;
list.Add(new IdAndName()
{
Name = "Manage Programs",
Value = "~/Views/Structure/",
Void = true
});
using (var strHelper = new DbHelper.Structure())
{
list.Add(new IdAndName()
{
Name = strHelper.GetSructureDirectory(Convert.ToInt32(yId), Convert.ToInt32(sId)),
Value = "~/Views/Structure/CourseListing.aspx?yId=" + yId + "&sId=" + sId,
Void = true
});
}
list.Add(new IdAndName()
{
Name = sub.FullName
});
}
else if (fromCls != null)
{
//lnkEdit.NavigateUrl += "&frmDetailView=" + fromCls;
list.Add(new IdAndName()
{
Name = "Courses", //SiteMap.CurrentNode.ParentNode.Title,
Value = "~/Views/Course/Default.aspx", //SiteMap.CurrentNode.ParentNode.Url,
Void = true
});
list.Add(new IdAndName()
{
Name = sub.FullName,
Value = "~/Views/Course/CourseDetail.aspx?cId=" + sub.Id,
Void = true
});
list.Add(new IdAndName()
{
Name = "View"
});
}
else
{
list.Add(new IdAndName()
{
Name = sub.FullName,
Value = "~/Views/Course/Section/?SubId=" + subId,
//"~/Views/Course/CourseDetail.aspx?cId=" + sub.Id
Void = true
});
}
//}
return(list);
}
}
private void LoadCourseDetail()
{
var courseId = CourseId;
using (var helper = new DbHelper.Subject())
{
lnkAddSection1.NavigateUrl = "~/Views/Course/Section/CreateSection.aspx?SubId=" + courseId;
var course = helper.Find(courseId);
//lblTitle.Text = course.Name;
//lblSummary.Text = course.Summary;
if (course != null)
{
var sections = course.SubjectSections;
if (sections != null)
{
var user = Page.User as CustomPrincipal;
var elligible = false;
if (user != null)
{
using (var chelper = new DbHelper.Classes())
{
var roles = user.GetRoles();
//Context.UserClass.Any(x=>x.subje)
// var roles = user.GetRoles().Select(x => x.Role.RoleName).ToList();
if (roles.Contains(DbHelper.StaticValues.Roles.CourseEditor.ToString()) ||
roles.Contains(DbHelper.StaticValues.Roles.Manager.ToString()) ||
roles.Contains(DbHelper.StaticValues.Roles.Admin) ||
roles.Contains("teacher"))
{
elligible = true;
}
//else
//{
// //teacher
// elligible = (chelper.IsUserElligibleToViewSubjectSection(SubjectId, UserId));
//}
var unVoidedSections = sections.Where(x => !(x.Void ?? false)).OrderBy(x => x.Position);
using (var ahelper = new DbHelper.ActAndRes())
foreach (var subjectSection in unVoidedSections)
{
var canView = elligible;
if (!canView)
{
canView = ahelper.EvaluateRestriction(null, subjectSection.Restriction, user.Id);
}
if (canView) //
{
SectionUc sectionuc =
(SectionUc)Page.LoadControl("~/Views/Course/Section/SectionUc.ascx");
sectionuc.AddActResClicked += sectionuc_AddActResClicked;
//sectionuc.EditEnabled = EditEnabled;
//sectionuc.SummaryVisible = subjectSection.ShowSummary ?? false;
//sectionuc.SubjectId = subjectSection.SubjectId;
//sectionuc.SectionId = subjectSection.Id;
//sectionuc.SectionName = subjectSection.Name;
sectionuc.SetData(EditEnabled, subjectSection.ShowSummary ?? false
, subjectSection.SubjectId, subjectSection.Id
, subjectSection.Name, UserId, elligible);
var sectionlbl = new Literal()
{
Text = "<a name='section_" + subjectSection.Id + "'></a>"
};
pnlSections.Controls.Add(sectionlbl);
pnlSections.Controls.Add(sectionuc);
}
}
}
}
}
}
}
//CreateSectionUc uc = (CreateSectionUc)Page.LoadControl("~/Views/Course/Section/CreateSectionUc.ascx");
//uc.ID = "createSection";
//uc.Visible = false;
//uc.SubjectId = CourseId;
//uc.OnSaveEvent += uc_OnSaveEvent;
//pnlSections.Controls.Add(uc);
}
private void LoadData2()
{
using (var helper = new DbHelper.Subject())
{
var userClasses = helper.ListCurrentUserClasses(UserId);
#region Manager Classes
var managerClasses = userClasses.Where(x => x.Role.RoleName == "manager" || x.Role.RoleName == "teacher");
var managerSubjects =
managerClasses.GroupBy(
x => x.SubjectClass.IsRegular ? x.SubjectClass.SubjectStructure.Subject : x.SubjectClass.Subject);
foreach (var subjGroup in managerSubjects)
{
//key is subject
var mngUc = (Course.ManagerCourseUc)
Page.LoadControl("~/ViewsSite/User/ModulesUc/Course/ManagerCourseUc.ascx");
mngUc.SetData(subjGroup.Key.Id, subjGroup.Key.ShortName, subjGroup.Key.FullName, subjGroup.ToList());
foreach (var uclass in subjGroup)
{
// var mngUcClass = (Course.ManagerCourseUc)
//Page.LoadControl("~/ViewsSite/User/ModulesUc/Course/ManagerCourseUc.ascx");
// mngUc.SetData(subjGroup.Key.Id, subjGroup.Key.ShortName, subjGroup.Key.FullName, subjGroup.ToList());
}
pnlRegularCourses.Controls.Add(mngUc);
}
#endregion
#region Student Classes
var studentClasses = userClasses.Where(x => x.Role.RoleName == "student");
var run = studentClasses.Select(x => x.SubjectClass).GroupBy(x => x.RunningClass);
foreach (var r in run)
{
if (r.Key != null)
{
var nodeuc =
(EarlierUc_NodesUc)Page.LoadControl("~/ViewsSite/User/ModulesUc/EarlierUc_NodesUc.ascx");
//key is used to display year/subyear
var subjects = r.Select(x => x.IsRegular ? x.SubjectStructure.Subject : x.Subject)
.Distinct().OrderBy(x => x.ShortName).ToList();
nodeuc.SetStructureData(r.Key.Year, r.Key.SubYear, subjects);
//lbltitle.ToolTip = r.Key.ProgramBatch.NameFromBatch;
pnlRegularCourses.Controls.Add(nodeuc);
}
else
{
//key is used to display year/subyear
var nodeuc = (EarlierUc_NodesUc)
Page.LoadControl("~/ViewsSite/User/ModulesUc/EarlierUc_NodesUc.ascx");
var subjects = r.Select(x => x.IsRegular ? x.SubjectStructure.Subject : x.Subject)
.Distinct().OrderBy(x => x.ShortName).ToList();
nodeuc.SetStructureData(null, null, subjects);
//foreach (var s in r)
//{
// var name = s.GetName;
// var nodeuc = (EarlierUc_NodesUc)
// Page.LoadControl("~/ViewsSite/User/ModulesUc/EarlierUc_NodesUc.ascx");
// //nodeuc.SetStructureData(r.Key.Year, r.Key.SubYear, subjects);
// nodeuc.SetStructureData(new Year(){Name=s.GetName}, null, subjects);
// pnlRegularCourses.Controls.Add(nodeuc);
//}
}
}
#endregion
//var runClass = userClasses.GroupBy(x => x.SubjectClass.RunningClass);
//var subClss = userClasses.Select(x => x.SubjectClass);//helper.ListCurrentSubjectClasses(UserId);
//var irrRun = subClss.Where(x => !x.IsRegular)
// .Select(x => x.Subject).Distinct().OrderBy(x => x.FullName).ToList();
//if (irrRun.Any())
//{
// divNonRegular.Visible = true;
// dListNonRegularSubjects.DataSource = irrRun;
// dListNonRegularSubjects.DataBind();
//}
//else
//{
// divNonRegular.Visible = false;
// dListNonRegularSubjects.DataSource = null;
// dListNonRegularSubjects.DataBind();
//}
}
}
private void LoadCategories(int schoolId)
{
using (var helper = new DbHelper.Subject())
{
var categories = helper.ListAllCategories(schoolId);
var i = 0;
var list = new List <int>();
foreach (var cat in categories)
{
list.Add(1);
var catLink = new LinkButton()
{
Text = cat.Name
,
ID = "category_" + cat.Id
};
catLink.Click += catLink_Click;
//catUc.ID = "category" + cat.Id.ToString() + cat.Name;
//catUc.Deselect();
//catUc.SetNameAndIdOfCategory(cat.Id, cat.Name, list, false);
if (i == 0)
{
if (hidSelectedCategoryId.Value == "0")
{
//catUc.Select();
hidSelectedCategoryId.Value = cat.Id.ToString();
lblSelectedCategoryName.Text = cat.Name;
if (CategorySelected != null)
{
CategorySelected(catLink, new IdAndNameEventArgs()
{
Id = cat.Id
});
}
}
//else if (hidSelectedCategoryId.Value == cat.Id.ToString())
//{
// //InitialUpdateOfCourses(cat.Id, cat.Name);
// //selectedAlready = true;
//}
}
//else if (!selectedAlready)
//{
// if (hidSelectedCategory.Value == cat.Id.ToString())
// {
// InitialUpdateOfCourses(cat.Id, cat.Name);
// selectedAlready = true;
// }
//}
//catUc.NameClicked += catUc_NameClicked;
//pnlCategories.Controls.Add(catUc);
pnlCategories.Controls.Add(catLink);
GetSubCategory(helper, schoolId, cat.Id, 1);
list.RemoveAt(list.Count - 1);
//var spaces = "";
//for (int j = 0; j < list.Count * 4; j++)
//{
// spaces += " ";
//}
//var litem = new ListItem() { Text = cat.Name };
//litem.Attributes.Add("style", "background-color:#41f111");//"padding-left:"+(list.Count*4)+"px");
//ddlCategories.Items.Add(litem);
i++;
}
}
}
private void LoadCustomText()
{
try
{
#region Activity Resource
var actResId = Request.QueryString["actResId"];
//var actOrRes = Request.QueryString["actOrRes"];
//var actOrResId = Request.QueryString["actOrResId"];
//var actResType = Request.QueryString["actResType"];
if (actResId != null)//actOrRes != null && actOrResId != null && actResType != null)
{
var displayType = "";
//var type = Convert.ToByte(actResType);
//var aOrRId = Convert.ToInt32(actOrResId);
using (var helper = new DbHelper.ActAndRes())
{
var actRes = helper.GetActivityResource(Convert.ToInt32(actResId));
if (actRes != null)
{
if (Convert.ToBoolean(actRes.ActivityOrResource)) //activity
{
switch (actRes.ActivityResourceType - 1)
{
case (int)Enums.Activities.Assignment: //Assignment
displayType = Enums.Activities.Assignment.ToString().ToLower();
break;
case (int)Enums.Activities.Chat: //chat
displayType = Enums.Activities.Chat.ToString().ToLower();
break;
case (int)Enums.Activities.Forum: //forum
displayType = Enums.Activities.Forum.ToString().ToLower();
break;
case (int)Enums.Activities.Choice:
displayType = Enums.Activities.Choice.ToString().ToLower();
break;
case (int)Enums.Activities.Lession: //lession
displayType = Enums.Activities.Lession.ToString().ToLower();
break;
case (int)Enums.Activities.Wiki: //wiki
displayType = Enums.Activities.Wiki.ToString().ToLower();
break;
case (int)Enums.Activities.Workshop: //Workshop
displayType = Enums.Activities.Workshop.ToString().ToLower();
break;
}
}
else //resource
{
switch (actRes.ActivityResourceType - 1)
{
case (int)Enums.Resources.Book: //Book
displayType = Enums.Resources.Book.ToString().ToLower();
break;
case (int)Enums.Resources.File: //file
displayType = Enums.Resources.File.ToString().ToLower();
break;
case (int)Enums.Resources.Folder:
displayType = Enums.Resources.Folder.ToString().ToLower();
break;
case (int)(Enums.Resources.Label):
displayType = Enums.Resources.Label.ToString().ToLower();
break;
case (int)(Enums.Resources.Page):
displayType = Enums.Resources.Page.ToString().ToLower();
break;
case (int)(Enums.Resources.Url):
displayType = Enums.Resources.Url.ToString().ToLower();
break;
}
}
lblInfoText.Text = ("Are you sure to delete the " + displayType
+ ", " + actRes.Name + "?");
//DbHelper.StaticValues.Decode
}
}
return;
}
#endregion
#region Book chapter
var chapterId = Request.QueryString["bcId"];
if (chapterId != null)
{
using (var helper = new DbHelper.ActAndRes())
{
var chapter = helper.GetChapter(Convert.ToInt32(chapterId));
if (chapter != null)
{
lblInfoText.Text = "Are you sure to delete the chapter, " + chapter.Title + "?";
}
return;
}
}
#endregion
#region Grade
var gradeId = Request.QueryString["grdId"];
if (gradeId != null)
{
using (var helper = new DbHelper.Grade())
{
var grade = helper.GetGrade(Convert.ToInt32(gradeId));
if (grade != null)
{
lblInfoText.Text = "Are you sure to delete the grade, " + grade.Name + "?";
}
return;
}
}
#endregion
#region Notice
var noticeId = Request.QueryString["nId"];
if (noticeId != null)
{
using (var helper = new DbHelper.Notice())
{
var notice = helper.GetNotice(Convert.ToInt32(noticeId));
if (notice != null)
{
lblInfoText.Text = "Are you sure to delete the notice, " + notice.Title + "?";
}
}
return;
}
#endregion
#region Academic year and SEssion
var acaId = Request.QueryString["acaId"];
if (acaId != null)
{
using (var helper = new DbHelper.AcademicYear())
{
var academic = helper.GetAcademicYear(Convert.ToInt32(acaId));
if (academic != null)
{
lblInfoText.Text = "Are you sure to delete the academic year, " + academic.Name + "?";
}
return;
}
}
var sessId = Request.QueryString["sessId"];
if (sessId != null)
{
using (var helper = new DbHelper.AcademicYear())
{
var session = helper.GetSession(Convert.ToInt32(sessId));
if (session != null)
{
lblInfoText.Text = "Are you sure to delete the session, " + session.Name + "?";
}
return;
}
}
#endregion
#region SubjectClass
var subclsId = Request.QueryString["subclsId"];
if (subclsId != null)
{
using (var helper = new DbHelper.Classes())
{
var cls = helper.GetSubjectSession(Convert.ToInt32(subclsId));
if (cls != null)
{
lblInfoText.Text = "Are you sure to delete the class, " + (cls.IsRegular ? cls.GetName : cls.Name) + "?";
}
}
return;
}
#endregion
#region Course and Category
var catId = Request.QueryString["catId"];
var crsId = Request.QueryString["crsId"];
//crsId should be null so it means that its category only
if (catId != null && crsId == null)
{
using (var helper = new DbHelper.Subject())
{
var category = helper.GetCategory(Convert.ToInt32(catId));
if (category != null)
{
lblInfoText.Text = "Are you sure to delete the category, " + category.Name + "?";
}
}
return;
}
#endregion
}
catch { }
}
protected void btnSave_Click(object sender, EventArgs e)
{
//if (cmbCategory.SelectedValue == "" || cmbCategory.SelectedValue == "0" || cmbCategory.SelectedValue == "-1")
//{
// RequiredFieldValidator1.IsValid = false;
//}
var user = Page.User as CustomPrincipal;
if (user != null)
{
if (Page.IsValid)
{
var credit = txtCredit.Text;
Subject subject = new Subject()
{
Id = SubjectId,
FullName = txtName.Text,
ShortName = txtShortName.Text,
Code = txtCode.Text,
//HasTheory = chkListHas.Items[0].Selected,
//HasLab = chkListHas.Items[1].Selected,
//HasTutorial = chkListHas.Items[2].Selected,
//HasProject = chkListHas.Items[3].Selected,
//IsElective = chkListIs.Items[0].Selected,
//IsOutOfSyllabus = chkListIs.Items[1].Selected,
CreatedDate = DateTime.Now.Date,
CreatedById = user.Id,
//IsActive = ckhIsActive.Checked
//,
//SubjectCategoryId = Convert.ToInt32(cmbCategory.SelectedValue)
SubjectCategoryId = CategoryId
};
//if (string.IsNullOrEmpty(txtCredit.Text))
//{
// subject.Credit = Convert.ToByte(txtCode.Text == "" ? "0" : txtCode.Text);
//}
//if (!String.IsNullOrEmpty(txtFullMarks.Text))
//{
// subject.FullMarks = Convert.ToInt32(txtFullMarks.Text);
//}
//if (!string.IsNullOrEmpty(txtPassPercent.Text))
//{
// subject.PassPercentage = Convert.ToByte(txtPassPercent.Text);
//}
//if (!string.IsNullOrEmpty(txtCompletionHours.Text))
//{
// subject.CompletionHours = Convert.ToInt16(txtCompletionHours.Text);
//}
using (var helper = new DbHelper.Subject())
{
var saved = helper.AddOrUpdateSubject(subject);
//Response.Redirect("~/Views/Course/");
if (SaveClicked != null)
{
if (saved)
{
SaveClicked(this, DbHelper.StaticValues.SuccessSaveMessageEventArgs);
}
else
{
SaveClicked(this, DbHelper.StaticValues.ErrorSaveMessageEventArgs);
}
}
}
}
}
}
public void LoadCourses()
{
var date = DateTime.Now;
var count = 0;
using (var aHelper = new DbHelper.ActAndRes())
using (var helper = new DbHelper.Subject())
using (var clsHelper = new DbHelper.Classes())
{
try
{
//aHelper.ListActivitiesAndResourcesOfSection()
var fromDashboard = FromDashboard;
var user = Page.User as CustomPrincipal;
if (user != null)
{
//var subjects = helper.GetCurrentRegularSubjectsOfUser(user.Id);
//var subjectsArray = helper.ListCurrentAndEarlierCoursesOfUser(user.Id);
List <Academic.DbEntities.Subjects.Subject> subjectsArray;
bool earlier = false;
if (hidLoadType.Value == "earlier")
{
earlier = true;
var subArray = helper.GetEarlierAndCurrentCourseAndClassesForManagerAndTeacherV3(user.Id,
false);
subjectsArray = subArray[1];//.Keys.ToList();
//subjectsArray = helper.ListEarlierSubjectClasses(user.Id)
// .Select(x => (x.IsRegular) ? x.SubjectStructure.Subject : x.Subject).ToList();
}
else
{
var subArray = helper.GetEarlierAndCurrentCourseAndClassesForManagerAndTeacherV3(user.Id,
true);
subjectsArray = subArray[0];//.Keys.ToList();
//subjectsArray = helper.ListCurrentSubjectClasses(user.Id)
// .Select(x => (x.IsRegular) ? x.SubjectStructure.Subject : x.Subject).ToList();
}
//foreach (var c in subjects[loadType])
//foreach (var c in subjectsArray[loadType])
foreach (var c in subjectsArray.Distinct())
{
//if (!lblHeading.Visible && fromDashboard)
//{
// lblHeading.Visible = true;
//}
CourseUc uc =
(CourseUc)Page.LoadControl("~/ViewsSite/DashBoard/Student/CourseOverView/CourseUc.ascx");
var navigationUrl = "~/Views/Course/Section/?SubId="
+ c.Id;
uc.TitleNavigationTarget = navigationUrl;
uc.Id = c.FullName + "_" + c.Id;
uc.Title = c.FullName;
//classes calculation
var userclasses = clsHelper.GetCurrentUserClassesOfUser(c.Id, user.Id);
//var clsIds = classes.Select(x => x.SubjectClass.Id).ToList();
var roles = user.GetRoles();
var elligible = false;
//Context.UserClass.Any(x=>x.subje)
// var roles = user.GetRoles().Select(x => x.Role.RoleName).ToList();
//if ()
{
elligible = user.IsElligibleForManagement;
//roles.Contains(DbHelper.StaticValues.Roles.CourseEditor.ToString())
// || roles.Contains(DbHelper.StaticValues.Roles.Manager.ToString())
// || roles.Contains(DbHelper.StaticValues.Roles.Admin.ToString())
// || roles.Contains("teacher");
}
var enterSubject = false;
//Messages
//Restriction calculation is not done yet
if (!earlier)
{
foreach (var sec in c.SubjectSections.AsEnumerable().Where(x => !(x.Void ?? false)))
{
var canView = elligible;
if (!canView)
{
canView = aHelper.EvaluateRestriction(null, sec.Restriction, user.Id);
}
if (canView) //
{
foreach (var act in sec.ActivityResources.AsEnumerable()
.Where(x => x.ActivityOrResource && !(x.Void ?? false)))//only activity
{
if (!elligible)
{
canView = aHelper.EvaluateRestriction(null, act.Restriction, user.Id);
}
if (canView) //
{
foreach (var ac in act.ActivityClasses)
{
//ac.ActivityResourceViews.Where(x=>x.)
var usrCls = userclasses.FirstOrDefault(x => x.SubjectClassId == ac.SubjectClassId);
if (usrCls != null)
{
//check for activity view
var viewed = ac.ActivityResourceViews.FirstOrDefault(a => a.UserClassId == usrCls.Id);
//!cls.ActivityResourceViews.ToList().Exists(x => x.UserClassId == classMatch.Id)
if (!(user.IsInRole("manager") || user.IsInRole("teacher")))
{
if (viewed != null)
{
if ((date - viewed.ViewedDate).TotalDays < 1)
{
enterSubject = true;
var cuc = (CourseMessageUC)
Page.LoadControl("~/ViewsSite/DashBoard/Student/CourseOverView/CourseMessageUC.ascx");
var thisIcon = ActivityResourceValues.RetriveMethod(actOrRes: true, actResType: (byte)(act.ActivityResourceType));
if (thisIcon != null)
{
cuc.ImageLink = thisIcon.IconPath;
cuc.Text = @"You have new """ + (thisIcon.Name) + @"""";
cuc.NavigateUrl = navigationUrl + "#section_" + sec.Id;
cuc.ToolTip = act.Name;
uc.AddMessages(cuc);
//if (fromDashboard)
//{
// if (!pnlCourseList.Visible)
// {
// pnlCourseList.Visible = true;
// }
//}
}
break;
}
}
else //(!ac.ActivityResourceViews.ToList().Exists(x => x.UserClassId == usrCls.Id))// && x.ActivityClassId == ac.Id)
{
//then don't display
enterSubject = true;
var cuc = (CourseMessageUC)
Page.LoadControl("~/ViewsSite/DashBoard/Student/CourseOverView/CourseMessageUC.ascx");
//var thisType = Enum.GetNames(typeof(Enums.Activities))[act.ActivityResourceType-1];
var thisIcon = ActivityResourceValues.RetriveMethod(actOrRes: true, actResType: (byte)(act.ActivityResourceType));
if (thisIcon != null)
{
cuc.ImageLink = thisIcon.IconPath;
cuc.Text = "You have new \"" + (thisIcon.Name) + "\"";
//cuc.NavigateUrl = thisIcon.ViewUrl
// + "?SubId=" + c.Id +
// "&arId=" + act.ActivityResourceId +
// "&secId=" + sec.Id +
// "&edit=0";
cuc.NavigateUrl = navigationUrl + "#section_" + sec.Id;
cuc.ToolTip = act.Name;
uc.AddMessages(cuc);
}
break;
}
}
#region Submission
//var actres = ahelper.GetActivityResource(true
// , (byte)(Enums.Activities.Assignment + 1), AssignmentId);
if (usrCls.Role.RoleName == "teacher" || usrCls.Role.RoleName == "manager")
{
if (act.ActivityOrResource
&&
act.ActivityResourceType == (byte)(Enums.Activities.Assignment + 1) &&
!(act.Void ?? false))
{
//then its assignment .. check for new submission
var ass = aHelper.GetAssignment(act.ActivityResourceId);
if (ass != null)
{
//its definitely assignment
var users = ass.Submissions.Count; //.OrderByDescending(x => x.SubmittedDate).Select(x => x.UserClassId).ToList();
var gradings = act.ActivityGradings.Count; //.Select(x=>x.UserClassId).ToList();
//var anyUnGraded = act.ActivityGradings.Any(x =>
// !users.Contains(x.UserClassId));
if (users > gradings)
{
enterSubject = true;
var cuc = (CourseMessageUC)Page.LoadControl
("~/ViewsSite/DashBoard/Student/CourseOverView/CourseMessageUC.ascx");
var thisIcon = ActivityResourceValues.AssignmentActivity();
//ActivityResourceValues.RetriveMethod(actOrRes: true, actResType: (byte)(act.ActivityResourceType));
if (thisIcon != null)
{
cuc.ImageLink = "~/Content/Icons/ActivityResource/Assignment/document_submit_icon.png"; //thisIcon.IconPath;
cuc.Text = "You have new Submission"; //+ (thisIcon.Name);
cuc.NavigateUrl = navigationUrl + "#section_" + sec.Id;
cuc.ToolTip = act.Name;
uc.AddMessages(cuc);
}
break;
}
}
}
}
#endregion
}
}
}
}
}
//Messages list
}
}
if (!fromDashboard)
{
this.pnlCourseList.Controls.Add(uc);
count++;
}
else
{
if (enterSubject)
{
if (!lblHeading.Visible)
{
lblHeading.Visible = fromDashboard;
}
this.pnlCourseList.Controls.Add(uc);
count++;
}
}
}
}
}
catch (Exception e) { }
}
this.Visible = count != 0;
}
