private void LoadFileResource()
{
using (var helper = new DbHelper.ActAndRes())
{
var files = new List <FileResourceEventArgs>();
var fileR = helper.GetFileResource(FileResourceId);
if (fileR != null)
{
txtName.Text = fileR.Name;
CKEditor1.Text = fileR.Description;
chkDisplayDescription.Checked = fileR.ShowDescriptionOnCoursePage;
chkShowSize.Checked = fileR.ShowSize;
chkShowType.Checked = fileR.ShowType;
chkShowUploadModifiedDate.Checked = fileR.ShowUploadModifiedDate;
ddlDisplay.SelectedIndex = fileR.Display;
var i = 1;
foreach (var f in fileR.FileResourceFiles)
{
files.Add(new FileResourceEventArgs()
{
Id = f.SubFileId,
Visible = true,
FileType = f.SubFile.FileType,
IconPath = f.SubFile.IconPath,
FilePath = f.SubFile.FileDirectory + "/" + f.SubFile.FileName,
FileDisplayName = f.SubFile.DisplayName,
FileSizeInBytes = f.SubFile.FileSizeInBytes
,
LocalId = i.ToString()
});
i++;
}
FilesDisplay1.SetInitialValues(files);
RestrictionUC.SetActivityResource(false, ((int)Enums.Resources.File) + 1, fileR.Id);
}
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
var user = Page.User as CustomPrincipal;
if (user != null)
{
var file = new Academic.DbEntities.ActivityAndResource.FileResource()
{
Id = FileResourceId,
Name = txtName.Text
,
Description = CKEditor1.Text
,
//Display = (byte)ddlDisplay.SelectedIndex
//,
ShowSize = chkShowSize.Checked
,
ShowType = chkShowType.Checked
,
ShowUploadModifiedDate = chkShowUploadModifiedDate.Checked
,
ShowDescriptionOnCoursePage = chkDisplayDescription.Checked
,
};
if (ddlDisplay.SelectedIndex == 0)
{
file.Display = 2;
}
else
{
file.Display = 4;
}
//files
var list = new List <Academic.DbEntities.Subjects.SubjectFile>();
var files = FilesDisplay1.GetFiles();
if (files != null)
{
foreach (var f in files)
{
var fileName = Path.GetFileName(f.FilePath);
var fi = new Academic.DbEntities.Subjects.SubjectFile()
{
Id = f.Id,
CreatedBy = user.Id
,
CreatedDate = DateTime.Now
,
DisplayName = f.FileDisplayName //Path.GetFileName(imageFile.FileName)
,
FileDirectory = DbHelper.StaticValues.CourseFilesLocation //StaticValue.UserImageDirectory
,
FileName = fileName
//Guid.NewGuid().ToString() + GetExtension(imageFile.FileName, imageFile.ContentType)
,
FileSizeInBytes = f.FileSizeInBytes //imageFile.ContentLength
,
FileType = f.FileType //imageFile.ContentType
,
IconPath = f.IconPath
,
SubjectId = SubjectId
,
Void = !f.Visible
};
list.Add(fi);
}
}
var restriction = RestrictionUC.GetRestriction();
if (!RestrictionUC.IsValid)
{
return;
}
using (var helper = new DbHelper.ActAndRes())
{
var saved = helper.AddOrUpdateFileResource(file, list, SectionId, restriction);
if (saved != null)
{
Response.Redirect(DbHelper.StaticValues.WebPagePath.CourseDetailPage(SubjectId, SectionId));
//Response.Redirect("~/Views/Course/Section/Master/CourseSectionListing.aspx?SubId=" + SubjectId + "&edit=1#section_" + SectionId);
}
}
}
}
protected void btnSubmit_OnClick(object sender, EventArgs e)
{
var user = Page.User as CustomPrincipal;
if (user != null)
{
var date = DateTime.Now;
var submission = new Academic.DbEntities.ActivityAndResource.AssignmentItems.AssignmentSubmissions()
{
Id = SubmissionId
,
AssignmentId = AssignmentId
,
UserClassId = UserClassId
};
if (pnlText.Visible)
{
submission.SubmissionText = CKEditor1.Text;
}
if (SubmissionId > 0)
{
submission.ModifiedDate = date;
}
else
{
submission.SubmittedDate = date;
}
#region Files
var list = new List <Academic.DbEntities.UserFile>();
if (pnlFileSubmit.Visible)
{
var files = FilesDisplay1.GetFiles();
if (files != null)
{
foreach (var f in files)
{
var fileName = Path.GetFileName(f.FilePath);
var fi = new Academic.DbEntities.UserFile()
{
Id = f.Id,
CreatedBy = user.Id
,
CreatedDate = DateTime.Now
,
DisplayName = f.FileDisplayName //Path.GetFileName(imageFile.FileName)
,
FileDirectory = DbHelper.StaticValues.CourseFilesLocation //StaticValue.UserImageDirectory
,
FileName = fileName
//Guid.NewGuid().ToString() + GetExtension(imageFile.FileName, imageFile.ContentType)
,
FileSizeInBytes = f.FileSizeInBytes //imageFile.ContentLength
,
FileType = f.FileType //imageFile.ContentType
,
IconPath = f.IconPath
//,
//SubjectId = SubjectId
,
Void = !f.Visible
};
list.Add(fi);
}
}
// var files = FilesDisplay1.GetFiles();
// var filelist = new List<Academic.DbEntities.UserFile>();
// //var files = FilesDisplay1.GetFiles();
// if (files != null)
// {
// var sublist = new
// List<Academic.DbEntities.ActivityAndResource.AssignmentItems.AssignmentSubmissionFiles>();
// foreach (var f in files)
// {
// var subFile = new Academic.DbEntities.ActivityAndResource.AssignmentItems.AssignmentSubmissionFiles()
// {
// AssignmentSubmissionsId = SubmissionId
// ,FileSubmittedDate = date
// };
// var fileName = Path.GetFileName(f.FilePath);
// var fi = new Academic.DbEntities.UserFile()
// {
// CreatedBy = user.Id
// ,
// CreatedDate = date
// ,
// DisplayName = f.FileDisplayName //Path.GetFileName(imageFile.FileName)
// ,
// FileDirectory = DbHelper.StaticValues.CourseFilesLocation //StaticValue.UserImageDirectory
// ,
// FileName = fileName
// //Guid.NewGuid().ToString() + GetExtension(imageFile.FileName, imageFile.ContentType)
// ,
// FileSizeInBytes = f.FileSizeInBytes //imageFile.ContentLength
// ,
// FileType = f.FileType //imageFile.ContentType
// ,
// IconPath = f.IconPath
// ,
// Id = f.Id
// ,
// //SubjectId = SubjectId
// };
// filelist.Add(fi);
// }
// }
}
#endregion
using (var helper = new DbHelper.Assignments())
{
var saved = helper.AddOrUpdateAssignmentSubmission(submission, list);
if (saved != null)
{
Response.Redirect("~/Views/ActivityResource/Assignments/AssignmentView.aspx?SubId=" + SubjectId +
"&arId=" + AssignmentId +
"&secId=" + SectionId
);
}
else
{
lblError.Visible = true;
}
}
}
}
void LoadActivity(int assignmentId)
{
using (var helper = new DbHelper.ActAndRes())
{
var ass = helper.GetAssignment(assignmentId);
if (ass != null)
{
var submission = ass.Submissions.FirstOrDefault(x => x.UserClassId == UserClassId);
if (submission != null)
{
var files = new List <FileResourceEventArgs>();
SubmissionId = submission.Id;
if (ass.OnlineText)
{
CKEditor1.Text = submission.SubmissionText;
}
if (ass.FileSubmission)
{
FilesDisplay1.NumberOfFilesToUpload = ass.MaximumNoOfUploadedFiles ?? 0;
var i = 1;
foreach (var f in submission.AssignmentSubmissionFiles)
{
files.Add(new FileResourceEventArgs()
{
Id = f.UserFileId,
Visible = true,
FileType = f.UserFile.FileType,
IconPath = f.UserFile.IconPath,
FilePath = f.UserFile.FileDirectory + "/" + f.UserFile.FileName,
FileDisplayName = f.UserFile.DisplayName,
FileSizeInBytes = f.UserFile.FileSizeInBytes
,
LocalId = i.ToString()
});
i++;
}
FilesDisplay1.SetInitialValues(files);
}
}
AssignmentId = assignmentId;
lblName.Text = ass.Name;
lblDescription.Text = ass.Description;
if (ass.FileSubmission || ass.OnlineText)
{
if (ass.FileSubmission)
{
pnlFileSubmit.Visible = true;
lblFileLimit.Text = "(File Limit : " + (ass.MaximumNoOfUploadedFiles ?? 0) + " files, " +
" Maximum size per file: " + (ass.MaximumSubmissionSize ?? 0) +
"KB)";
//FilesDisplay1.NumberOfFilesToUpload = ass.MaximumNoOfUploadedFiles ?? 0;
}
else
{
pnlFileSubmit.Visible = false;
pnlFileSubmit.Controls.Clear();
}
if (ass.OnlineText)
{
//lblScript.Text = WordLimitScript(ass.WordLimit ?? 0);
lblWordLimit.Text = "(Word Limit : " + (ass.WordLimit ?? 0) + " words)";
pnlText.Visible = true;
}
else
{
pnlText.Visible = false;
pnlText.Controls.Clear();
}
}
else
{
btnSubmit.Visible = false;
}
}
}
}
private void PopulateSchoolInfo(CustomPrincipal user)
{
using (var helper = new DbHelper.Office())
{
var sch = helper.GetSchoolOfUser(user.Id);
if (sch != null)
{
CKEditor1.Text = sch.Description;
hidSchoolId.Value = sch.Id.ToString();
txtAddress.Text = sch.Address;
txtName.Text = sch.Name;
txtEmailGeneral.Text = sch.EmailGeneral;
//txtEmailMarketing.Text = sch.EmailMarketing;
//txtEmailSupport.Text = sch.EmailSupport;
txtPhoneMain.Text = sch.PhoneMain;
//txtPhoneAfterHours.Text = sch.PhoneAfterHours;
hidImageId.Value = sch.ImageId.ToString();
//txtStreet.Text = sch.Street;
txtWeb.Text = sch.Website;
hidUserId.Value = sch.UserId.ToString();
//cmbSchoolType.SelectedValue = sch.SchoolTypeId.ToString();
var f = helper.GetSchoolImage(sch.ImageId);
if (f != null)
{
//var fileName = Path.GetFileName(f.FilePath);
var image = new FileResourceEventArgs()
{
Id = f.Id,
//CreatedBy = user.Id
//,
//CreatedDate = DateTime.Now
//,
FileDisplayName = f.DisplayName //Path.GetFileName(imageFile.FileName)
//,
// FileDirectory = DbHelper.StaticValues.SchoolFileLocation //StaticValue.UserImageDirectory
// ,
//FileName = fileName
,
FilePath = DbHelper.StaticValues.SchoolFileLocation + f.FileName
//Guid.NewGuid().ToString() + GetExtension(imageFile.FileName, imageFile.ContentType)
,
FileSizeInBytes = f.FileSizeInBytes //imageFile.ContentLength
,
FileType = f.FileType //imageFile.ContentType
,
IconPath = f.IconPath
,
//SubjectId = SubjectId
};
FilesDisplay1.SetInitialValues(new List <FileResourceEventArgs>()
{
image
});
}
}
if (SiteMap.CurrentNode != null)
{
var list = new List <IdAndName>()
{
new IdAndName()
{
Name = SiteMap.RootNode.Title
, Value = SiteMap.RootNode.Url
, Void = true
},
new IdAndName()
{
Name = sch == null?SiteMap.CurrentNode.ParentNode.Title:sch.Name
, Value = SiteMap.CurrentNode.ParentNode.Url
, Void = true
},
new IdAndName()
{
Name = "Edit"
}
};
SiteMapUc.SetData(list);
}
}
}
//private void PopulateCountry()
//{
// List<string> countries = new List<string>();
// var getCultureInfo = CultureInfo.GetCultures(CultureTypes.SpecificCultures);
// foreach (var c in getCultureInfo)
// {
// var getRegionInfo =
// new RegionInfo(c.LCID);
// var name = getRegionInfo.EnglishName.Split(new char[] { '(' })[0];
// if (!countries.Contains(name))
// {
// countries.Add(name);
// }
// }
// countries.Sort();
// var i = 0;
// try
// {
// i = countries.IndexOf("Nepal");
// }
// catch
// {
// }
// if (i != 0)
// countries.Insert(0, "Select");
// ddlCountry.DataSource = countries;
// ddlCountry.DataBind();
// ddlCountry.SelectedIndex = i;
//}
protected void btnSave_Click(object sender, EventArgs e)
{
//if (cmbSchoolType.SelectedValue == "" || cmbSchoolType.SelectedValue == "0")
//{
// valiSchType.IsValid = false;
//}
//if (ddlCountry.SelectedIndex == 0)
// valiCountry.IsValid = false;
if (IsValid)
{
var user = User as CustomPrincipal;
if (user == null)
{
return;
}
var school = new Academic.DbEntities.Office.School()
{
Id = user.SchoolId,
Name = txtName.Text,
Address = txtAddress.Text,
EmailGeneral = txtEmailGeneral.Text,
EmailMarketing = "", //txtEmailMarketing.Text,
EmailSupport = "", //txtEmailSupport.Text,
IsActive = chkActive.Checked,
PhoneMain = txtPhoneMain.Text,
PhoneAfterHours = "", //txtPhoneAfterHours.Text,
Description = CKEditor1.Text,
//SchoolTypeId = Convert.ToInt32(cmbSchoolType.Text),
Website = txtWeb.Text,
CreatedDate = DateTime.Now,
ImageId = Convert.ToInt32(hidImageId.Value)
};
if (user.SchoolId <= 0)
{
school.UserId = user.Id;
}
using (var helper = new DbHelper.Office())
{
var files = FilesDisplay1.GetFiles();
var image = new UserFile();
if (files != null)
{
if (files.Count >= 1)
{
var f = files[0];
//foreach (var f in files)
{
var fileName = Path.GetFileName(f.FilePath);
image = new Academic.DbEntities.UserFile()
{
Id = f.Id,
CreatedBy = user.Id
,
CreatedDate = DateTime.Now
,
DisplayName = f.FileDisplayName //Path.GetFileName(imageFile.FileName)
,
FileDirectory = DbHelper.StaticValues.SchoolFileLocation //StaticValue.UserImageDirectory
,
FileName = fileName
//Guid.NewGuid().ToString() + GetExtension(imageFile.FileName, imageFile.ContentType)
,
FileSizeInBytes = f.FileSizeInBytes //imageFile.ContentLength
,
FileType = f.FileType //imageFile.ContentType
,
IconPath = f.IconPath
,
//SubjectId = SubjectId
};
if (f.Id > 0)
{
image.ModifiedBy = user.Id;
image.ModifiedDate = DateTime.Now;
}
}
}
}
var saved = helper.AddOrUpdateSchool(school, image);//FileUpload1.PostedFile
//update cookie -- add school Id to the cookie
//Page.User.Identity.Name;
if (saved != null)
{
if (user.SchoolId <= 0)
{
var ok = UpdateSchoolInfoInCookie(user, saved.Id);
if (ok)
{
Response.Redirect("~/ViewsSite/User/Dashboard/Dashboard.aspx");
}
else
{
lblMsg.Text = "Error while saving.";
}
//---not needed, since redirect is done above
//SchoolTypeUC.SavedId = 0;
//lblMsg.Visible = true;
//lblMsg.Text = "Save Successful.";
}
else
{
Response.Redirect("~/About.aspx"); //"//~/Views/Office/");
}
}
else
{
lblMsg.Text = "Error while saving.";
}
}
}
else
{
lblMsg.Text = "Some fields are invalid or not filled.";
}
}
private void LoadSubmission()
{
using (var helper = new DbHelper.ActAndRes())
{
var userClassId = UserClassId;
var actres = helper.GetActivityResource(ActivityResourceId);
if (actres != null)
{
var grd = (actres.ActivityGradings.FirstOrDefault(x => x.UserClassId == userClassId));
var ass = helper.GetAssignment(ActivityId);
if (ass != null)
{
var sub = ass.Submissions.FirstOrDefault(x => x.UserClassId == userClassId);
lblName.Text = ass.Name;
lblDescription.Text = ass.Description;
if (sub != null)
{
if (ass.FileSubmission)
{
var files = new List <FileResourceEventArgs>();
FilesDisplay1.NumberOfFilesToUpload = ass.MaximumNoOfUploadedFiles ?? 0;
var i = 1;
foreach (var f in sub.AssignmentSubmissionFiles)
{
files.Add(new FileResourceEventArgs()
{
Id = f.UserFileId,
Visible = true,
FileType = f.UserFile.FileType,
IconPath = f.UserFile.IconPath,
FilePath = f.UserFile.FileDirectory + "/" + f.UserFile.FileName,
FileDisplayName = f.UserFile.DisplayName,
FileSizeInBytes = f.UserFile.FileSizeInBytes
,
LocalId = i.ToString()
});
i++;
}
FilesDisplay1.SetInitialValues(files);
}
if (grd != null)
{
var user = grd.UserClass.User;
lblStudentName.Text = user.FirstName
+ (string.IsNullOrEmpty(user.MiddleName)? "": " " + user.MiddleName)
+ (string.IsNullOrEmpty(user.LastName) ? "" : " " + user.LastName);
lblEmail.Text = user.Email;
lblClassName.Text = grd.UserClass.SubjectClass.GetName;
var std = user.Student.FirstOrDefault();
if (std != null)
{
lblRoll.Text = std.CRN;
}
txtRemarks.Text = grd.Remarks;
}
else
{
using (var clsHelper = new DbHelper.Classes())
{
var uc = clsHelper.GetUserClass(userClassId);
if (uc != null)
{
var user = uc.User;
lblStudentName.Text = user.FirstName
+ (string.IsNullOrEmpty(user.MiddleName) ? "" : " " + user.MiddleName)
+ (string.IsNullOrEmpty(user.LastName) ? "" : " " + user.LastName);
lblEmail.Text = user.Email;
lblClassName.Text = uc.SubjectClass.GetName;
var std = user.Student.FirstOrDefault();
if (std != null)
{
lblRoll.Text = std.CRN;
}
}
else
{
Response.Redirect("~/Views/All_Resusable_Codes/Error/ErrorPage.aspx");
}
}
}
if (ass.OnlineText)
{
pnlText.Visible = true;
txtSubmittedText.Text = sub.SubmissionText;
lblWordLimit.Text = "(Word limit : " + (ass.WordLimit ?? 0)
+ " words)";
}
if (ass.FileSubmission)
{
pnlFileSubmit.Visible = true;
lblFileLimit.Text = "(Maximum No. of files allowed : " + (ass.MaximumNoOfUploadedFiles ?? 0)
+ ", Maximum file size : " + (ass.MaximumSubmissionSize ?? 0)
+ "KB)";
//each file load
}
if (ass.GradeType.RangeOrValue) //value
{
var values = ass.GradeType.GradeValues.ToList();
ddlGrade.Visible = true;
var lst = new List <Academic.DbEntities.Grades.GradeValue>();
var maxid = 0;
try
{
maxid = Convert.ToInt32(ass.MaximumGrade);
}
catch { }
var max = values.FirstOrDefault(x => x.Id == maxid);
if (max != null)
{
lblMaximumGrade.Text = max.Value;
foreach (var gv in ass.GradeType.GradeValues)
{
if ((gv.EquivalentPercentOrPostition ?? 0).CompareTo(
(max.EquivalentPercentOrPostition ?? 0)) <= 0)
{
lst.Add(gv);
}
}
}
var minid = 0;
try
{
minid = Convert.ToInt32(ass.GradeToPass);
}
catch { }
var min = values.FirstOrDefault(x => x.Id == minid);
if (min != null)
{
lblMinimumGradeToPass.Text = min.Value;
}
ddlGrade.DataSource = lst;
ddlGrade.DataBind();
if (grd != null)
{
try
{
if ((grd.ObtainedGradeId ?? 0) > 0)
{
ddlGrade.SelectedValue = (grd.ObtainedGradeId ?? 0).ToString();
}
}
catch { }
}
}
else//range
{
txtGrade.Visible = true;
lblMaximumGrade.Text = ass.MaximumGrade;
lblMinimumGradeToPass.Text = ass.GradeToPass;
if (grd != null)
{
txtGrade.Text = (grd.ObtainedGradeMarks ?? 0).ToString("F");
}
}
}
}
}
}
}
