protected void btnSave_OnClick(object sender, EventArgs e)
{
//activate the session (as well as academic year)
// mark complete the previous active session
// or mark complete the previous academic year and its session
// mark all running classes of previous session as complete
// create new running class and mark them active
var user = Page.User as CustomPrincipal;
if (user != null)
{
//var date = DateTime.Now;
var aId = Convert.ToInt32(hidAcademicYearId.Value);
var currActiveSessionId = Convert.ToInt32(hidCurrentlyActiveSessionId.Value);
var nextActivatingSessionId = Convert.ToInt32(hidNextActivatingSessionId.Value);
using (var helper = new DbHelper.AcademicYear())
{
var saved = helper.CreateNextActiveSession(user.SchoolId, aId, currActiveSessionId
, nextActivatingSessionId, user.Id);
if (saved)
{
Response.Redirect("~/Views/Academy/Detail.aspx?aId=" + hidAcademicYearId.Value);
}
else
{
lblError.Visible = true;
lblError.Text = "Couldn't save.";
}
}
}
}
private void LoadBatches()
{
var user = Page.User as CustomPrincipal;
if (user != null)
{
using (var aHelper = new DbHelper.AcademicYear())
using (var helper = new DbHelper.Batch())
{
var academic = aHelper.ListAcademicYears(user.SchoolId);
if (academic.Any())
{
var edit = Edit == "1";
var lst = helper.GetBatchList(SchoolId, 10
, 0); //Convert.ToInt32(String.IsNullOrEmpty(txtPageNo.Text) ? "0" : txtPageNo.Text));
foreach (var batch in lst)
{
ItemUc itemUc = (ItemUc)Page.LoadControl("~/Views/Student/Batch/List/ItemUc.ascx");
itemUc.LoadData(batch.Id, batch.Name, batch.Description, batch.ProgramBatches.Count
, batch.AcademicYear.StartDate, edit);
pnlItems.Controls.Add(itemUc);
}
}
else
{
//display academic year creation prompt form
}
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
lblError.Visible = false;
valiStartDate.ErrorMessage = "Required";
valiEnd.ErrorMessage = "Required";
if (!IsPostBack)
{
using (var helper = new DbHelper.AcademicYear())
{
var aca = helper.GetAcademicYear(AcademicYearId);
var session = helper.GetSession(SessionId);
if (aca != null)
{
lblHeading.Text = "New Session Create";
lblAcademicHeading.Text = @"Session create in Academic Year: """ + aca.Name + @"""";
lblAcademicStart.Text = "Start Date: " + aca.StartDate.ToShortDateString();
lblAcademicEnd.Text = "End Date: " + aca.EndDate.ToShortDateString();
ViewState["AcademicYearStartDate"] = aca.StartDate.Date;
ViewState["AcademicYearEndDate"] = aca.EndDate.Date;
}
if (session != null)
{
lblHeading.Text = @"Edit Session """ + session.Name + @"""";
LoadSessionData(session);
}
//LoadSessionParametersAndDate();
}
}
}
private Academic.DbEntities.AcademicYear GetAcademicYear(DbHelper.AcademicYear helper, CustomPrincipal user)
{
DateTime start = DateTime.MinValue, end = DateTime.MaxValue;
try
{
start = Convert.ToDateTime(txtAcademicStart.Text);
var earlierAca = helper.GetEarlierAcademicYear(user.SchoolId);
if (earlierAca != null && earlierAca?.Id != AcademicYearId)
{
if (start.Date <= earlierAca.EndDate.Date)
{
valiAcademicStart.ErrorMessage = "Must be greater than end-date of earlier academic year (" + earlierAca.EndDate.ToShortDateString() + ")";
valiAcademicStart.IsValid = false;
}
}
}
catch
{
valiAcademicStart.ErrorMessage = "Incorrect format.";
valiAcademicStart.IsValid = false;
}
try
{
end = Convert.ToDateTime(txtAcademicEnd.Text);
if (end <= start)
{
valiAcademicEnd.ErrorMessage = "End date must be greater than start date";
valiAcademicEnd.IsValid = false;
}
}
catch
{
valiAcademicEnd.ErrorMessage = "Incorrect format.";
valiAcademicEnd.IsValid = false;
}
if (Page.IsValid)
{
var entity = new Academic.DbEntities.AcademicYear()
{
Id = AcademicYearId
,
Name = txtName.Text
,
EndDate = end
,
StartDate = start
,
SchoolId = user.SchoolId
,
Position = start.Year * 10000 + start.Month * 100 + start.Day,
};
return(entity);
}
return(null);
}
protected void btnActivate_Click(object sender, EventArgs e)
{
int aId = AcademicYearId;
int sId = SessionId;
using (var helper = new DbHelper.AcademicYear())
{
//then session need to be activated
//helper.ActivateAcademicYearSession(aId, sId);
}
}
protected void btnOk_Click(object sender, EventArgs e)
{
using (var helper = new DbHelper.AcademicYear())
{
var msg = "";
var user = Page.User as CustomPrincipal;
if (user != null && user.IsInRole("manager"))
{
if (Task == "activate")
{
if (AcademicYearId > 0)
{
msg = helper.ActivateAcademicYearSession(user.Id, AcademicYearId, 0);
}
else if (SessionId > 0)
{
msg = helper.ActivateAcademicYearSession(user.Id, 0, SessionId);
}
}
else if (Task == "completed")
{
if (AcademicYearId > 0)
{
msg = helper.MarkCompleteAcademicYearSession(user.Id, AcademicYearId, 0);
}
else if (SessionId > 0)
{
msg = helper.MarkCompleteAcademicYearSession(user.Id, 0, SessionId);
}
}
if (msg != "success")
{
lblError.Visible = true;
}
else
{
var sessionId = SessionId;
if (sessionId > 0)
{
Response.Redirect("~/Views/Academy/Session/SessionDetail.aspx?aId=" + AcademicYearId + "&sId=" + sessionId + "&edit=1");
}
else
{
Response.Redirect("~/Views/Academy/AcademicYear/AcademicYearDetail.aspx?aId=" + AcademicYearId + "&edit=1");
}
}
}
else
{
Response.Redirect("~/Views/Academy/List.aspx");
}
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
//if (cmbSchool.SelectedValue == "0")
//{
// RequiredFieldValidator2.IsValid = false;
//}
//else
//{
// RequiredFieldValidator2.IsValid = true;
//}
var user = Page.User as CustomPrincipal;
if (user != null)
{
if (IsValid)
{
var entity = new Academic.DbEntities.AcademicYear()
{
Id = Convert.ToInt32(hidId.Value)
,
Name = txtName.Text
,
//EndDate = dtEnd.SelectedDate
//,
//StartDate = dtStart.SelectedDate
//,
SchoolId = user.SchoolId// Values.Session.GetSchool(Session)
,
IsActive = CheckBox1.Checked
};
using (var helper = new DbHelper.AcademicYear())
{
var saved = helper.AddOrUpdateAcademicYear(user.SchoolId, entity);
if (saved != null)
{
//Response.Write("SAVE SUCCESSFUL!");
//earlier uncommented
//pnlAcademicYear.Enabled = false;
btnSave.Enabled = false;
//CreateUC1.ValidationEnabled = true;
CreateUC1.AcademicYearId = saved.Id;
//earlier uncommented
//pnlAcademicYear.BackColor = Color.Aquamarine;
pnlSession.Visible = true;
}
}
}
}
}
//public void LoadStructure(int schoolId)
//{
// var user = Page.User as CustomPrincipal;
// if (user != null)
// using (var helper = new DbHelper.Structure())
// {
// var programs = helper.ListPrograms(schoolId);
// programs.ForEach(p =>
// {
// var litem = new ListItem() { Text = " " + p.Name, Value = p.Id.ToString() };
// var pbs = p.ProgramBatches.FirstOrDefault(x => x.BatchId == BatchId);
// if (pbs != null)
// {
// litem.Value += "_" + pbs.Id;
// litem.Selected = !(pbs.Void ?? false);
// }
// else
// {
// litem.Value += "_0";
// litem.Selected = false;
// }
// CheckBoxList1.Items.Add(litem);
// });
// }
//}
//public void SetDatasForEdit(int batchId)
//{
// using (var helper = new DbHelper.Batch())
// {
// var batch = helper.GetBatch(batchId);
// if (batch != null)
// {
// BatchId = batch.Id;
// //txtName.Text = batch.Name;
// //txtDescription.Text = batch.Description;
// //ddlAcademicYear.SelectedValue = batch.AcademicYearId.ToString();
// //txtCommenceDate.Text = batch.ClassCommenceDate == null ? "" : batch.ClassCommenceDate.Value.ToShortDateString();
// }
// // program batches
// }
//}
protected void btnSave_Click(object sender, EventArgs e)
{
using (var helper = new DbHelper.AcademicYear())
{
var user = Page.User as CustomPrincipal;
if (user != null)
{
//academic year
var academicYear = GetAcademicYear(helper, user);
if (academicYear == null)
{
return;
}
//batch
List <Academic.DbEntities.Batches.ProgramBatch> list = new List <ProgramBatch>();
var batch = GetBatch(user, ref list);
if (batch == null)
{
return;
}
var sessions = GetSessions(academicYear);
if (sessions == null)
{
return;
}
var saved = helper.AddOrUpdateAcademicYearAndBatch(user.SchoolId, academicYear, sessions, batch, list);
if (saved != null)
{
lblFromSessionNotice.Visible = true;
if (lblFromSessionNotice.Visible)
{
Response.Redirect("~/Views/Student/Batch/?Id=" + saved.Id + "&from=startSession");
//Response.Redirect("~/Views/Academy/StartSession.aspx");
}
else
{
Response.Redirect("~/Views/Academy/");
}
}
else
{
lblError.Visible = true;
}
}
}
}
private void AcademicYearDelete()
{
var acaId = Request.QueryString["acaId"];
using (var helper = new DbHelper.AcademicYear())
{
var deleted = helper.DeleteAcademicYear(Convert.ToInt32(acaId));
if (deleted)
{
Response.Redirect("~/Views/Academy/", false);
}
else
{
lblError.Visible = true;
}
}
}
private void BindGrid(CustomPrincipal user)
{
var edit = Edit;
if (user.IsInRole("manager") || user.IsInRole("teacher"))
{
var aId = Request.QueryString["aId"];
var academicId = 0;
try
{
academicId = Convert.ToInt32(aId);
}
catch { }
using (var helper = new DbHelper.AcademicYear())
{
//var aca = helper.ListAcademicYears(user.SchoolId);
var aca = helper.GetCurrentPreviousAndNextAcademicYears(user.SchoolId, academicId);
if (aca[0] != null)
{
lnkPrevious.NavigateUrl = "~/Views/Academy/?aId=" + aca[0].Id;
}
else
{
lnkPrevious.Visible = false;
}
if (aca[2] != null)
{
lnkNext.NavigateUrl = "~/Views/Academy/?aId=" + aca[2].Id;
}
else
{
lnkNext.Visible = false;
}
//foreach (var ay in aca)
if (aca[1] != null)
{
var ay = aca[1];
var uc =
(UserControls.AcademicYearListUC)
Page.LoadControl("~/Views/Academy/UserControls/AcademicYearListUC.ascx");
uc.LoadAcademicYear(ay, edit);
pnlAcademicYearListing.Controls.Add(uc);
}
}
}
}
public void LoadStructure(int schoolId)
{
var batchId = BatchId;
var user = Page.User as CustomPrincipal;
if (user != null)
{
using (var aHelper = new DbHelper.AcademicYear())
using (var helper = new DbHelper.Structure())
{
//var academicYears = aHelper.ListNotCompleteAcademicYear(user.SchoolId);
//if (academicYears.Any())
//{
// ddlAcademicYear.DataValueField = "Id";
// ddlAcademicYear.DataTextField = "Name";
// ddlAcademicYear.DataSource = academicYears;
// ddlAcademicYear.DataBind();
//}
var programs = helper.ListPrograms(schoolId);
programs.ForEach(p =>
{
var litem = new ListItem()
{
Text = " " + p.Name, Value = p.Id.ToString()
};
var pbs = p.ProgramBatches.FirstOrDefault(x => x.BatchId == BatchId);
if (pbs != null)
{
litem.Value += "_" + pbs.Id;
litem.Selected = !(pbs.Void ?? false);
}
else
{
litem.Value += "_0";
litem.Selected = false;
}
CheckBoxList1.Items.Add(litem);
});
}
}
}
//public void LoadStructure(int schoolId)
//{
// var user = Page.User as CustomPrincipal;
// if (user != null)
// using (var helper = new DbHelper.Structure())
// {
// var programs = helper.ListPrograms(schoolId);
// programs.ForEach(p =>
// {
// var litem = new ListItem() { Text = " " + p.Name, Value = p.Id.ToString() };
// var pbs = p.ProgramBatches.FirstOrDefault(x => x.BatchId == BatchId);
// if (pbs != null)
// {
// litem.Value += "_" + pbs.Id;
// litem.Selected = !(pbs.Void ?? false);
// }
// else
// {
// litem.Value += "_0";
// litem.Selected = false;
// }
// CheckBoxList1.Items.Add(litem);
// });
// }
//}
//public void SetDatasForEdit(int batchId)
//{
// using (var helper = new DbHelper.Batch())
// {
// var batch = helper.GetBatch(batchId);
// if (batch != null)
// {
// BatchId = batch.Id;
// //txtName.Text = batch.Name;
// //txtDescription.Text = batch.Description;
// //ddlAcademicYear.SelectedValue = batch.AcademicYearId.ToString();
// //txtCommenceDate.Text = batch.ClassCommenceDate == null ? "" : batch.ClassCommenceDate.Value.ToShortDateString();
// }
// // program batches
// }
//}
protected void btnSave_Click(object sender, EventArgs e)
{
var user = Page.User as CustomPrincipal;
if (user != null)
{
//academic year
var academicYear = GetAcademicYear(user);
if (academicYear == null)
{
return;
}
//batch
List <Academic.DbEntities.Batches.ProgramBatch> list = new List <ProgramBatch>();
var batch = GetBatch(user, ref list);
if (batch == null)
{
return;
}
//var sessions = new List<Academic.DbEntities.Session>();
using (var helper = new DbHelper.AcademicYear())
{
//var saved = helper.AddOrUpdateAcademicYearAndBatch(user.SchoolId, academicYear, batch, list);
//if (saved != null)
//{
// var btn = sender as Button;
// if (btn != null)
// {
// if (btn.ID == "btnSaveAndAddSessions")
// {
// Response.Redirect("~/Views/Academy/Session/Create.aspx?aId=" + saved.Id);
// }
// else
// {
// Response.Redirect("~/Views/Academy/");
// }
// }
//}
//else lblError.Visible = true;
}
}
}
private void BindGrid(CustomPrincipal user)
{
var edit = Edit;
if (user.IsInRole("manager") || user.IsInRole("teacher"))
{
using (var helper = new DbHelper.AcademicYear())
{
var aca = helper.GetAcademicYearListForSchool(
user.SchoolId);
foreach (var ay in aca)
{
var uc =
(UserControls.AcademicYearListUC)
Page.LoadControl("~/Views/Academy/UserControls/AcademicYearListUC.ascx");
uc.LoadAcademicYear(
ay.Id, ay.Name, ay.StartDate, ay.EndDate
, ay.IsActive, ay.Sessions.ToList(), ay.Completed ?? false, edit);
pnlAcademicYearListing.Controls.Add(uc);
}
}
}
}
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 { }
}
private void LoadData()
{
var user = Page.User as CustomPrincipal;
var aId = Request.QueryString["aId"];
if (user != null)
{
using (var aHelper = new DbHelper.AcademicYear())
using (var bHelper = new DbHelper.Batch())
using (var sHelper = new DbHelper.Structure())
{
var fromSession = Request.QueryString["from"];
if (fromSession == "startSession")
{
lblFromSessionNotice.Visible = true;
}
if (aId == null)
{
var sessionsDefault = aHelper.ListDefaultSessions(user.SchoolId);
if (sessionsDefault.Count >= 2)
{
txtSession1Name.Text = sessionsDefault[0].Name;
txtSession2Name.Text = sessionsDefault[1].Name;
}
}
else
{
//btnSaveAndAddSessions.Visible = false;
var batch = bHelper.GetBatchByAcademicYearId(Convert.ToInt32(aId));
if (batch != null)
{
BatchId = batch.Id;
var acad = batch.AcademicYear;
if (acad != null)
{
//=========================Academic year, batch
AcademicYearId = acad.Id;
txtName.Text = acad.Name;
txtAcademicStart.Text = acad.StartDate.ToShortDateString();
txtAcademicEnd.Text = acad.EndDate.ToShortDateString();
txtBatchName.Text = batch.Name;
//========================Sessions
var sessions = acad.Sessions.Where(x => !(x.Void ?? false)).ToList();
if (sessions.Count >= 2)
{
// enable disable session1
txtSession1Name.Text = sessions[0].Name;
Session1Id = sessions[0].Id;
txtSession1Start.Text = sessions[0].StartDate.ToShortDateString();
txtSession1End.Text = sessions[0].EndDate.ToShortDateString();
var session1Enabled = !(sessions[0].IsActive || (sessions[0].Completed ?? false));
txtSession1Name.Enabled = session1Enabled;
txtSession1Start.Enabled = session1Enabled;
txtSession1End.Enabled = session1Enabled;
//enable , disable session2
txtSession2Name.Text = sessions[1].Name;
Session2Id = sessions[1].Id;
txtSession2Start.Text = sessions[1].StartDate.ToShortDateString();
txtSession2End.Text = sessions[1].EndDate.ToShortDateString();
var session2Enabled = !(sessions[1].IsActive || (sessions[1].Completed ?? false));
txtSession2Name.Enabled = session2Enabled;
txtSession2Start.Enabled = session2Enabled;
txtSession2End.Enabled = session2Enabled;
//enable , disable -- academic year
if (batch.AcademicYear.IsActive || (batch.AcademicYear.Completed ?? false) ||
!session2Enabled || !session1Enabled)
{
txtName.Enabled = false;
txtAcademicEnd.Enabled = false;
txtAcademicStart.Enabled = false;
CheckBoxList1.Enabled = false;
//earlier working
//chkSelectAll.Enabled = false;
txtName.Enabled = false;
txtBatchName.Enabled = false;
btnSave.Enabled = false;
CheckBoxList1.Enabled = false;
//earlier working
//chkSelectAll.Enabled = false;
}
}
}
}
}
//============================ Structure
SetStructure(sHelper, user);
}
}
}
public bool UpdateSchoolInfoInCookie(CustomPrincipal user, int schoolId)
{
try
{
using (var acchelper = new DbHelper.CustomAccount())
{
//if (Membership.ValidateUser(viewModel.UserName, viewModel.Password))
//if (acchelper.CheckUser(viewModel.UserName, viewModel.Password))
//{
//Response.Cookies.Remove(FormsAuthentication.FormsCookieName);
using (var acaHelper = new DbHelper.AcademicYear())
using (var helper = new DbHelper.User())
{
//var user = helper.Users.First(u => u.UserName == userName);
CustomPrincipalSerializeModel serializeModel = new CustomPrincipalSerializeModel();
serializeModel.Id = user.Id;
serializeModel.FirstName = user.FirstName;
serializeModel.LastName = user.LastName;
serializeModel.SchoolId = schoolId;
var sess = acaHelper.GetCurrentSession();
if (sess != null)
{
serializeModel.AcademicYearId = sess.AcademicYearId;
serializeModel.SessionId = sess.Id;
}
//var acaId = acaHelper.GetCurrentAcademicYear(user.SchoolId);
//if (acaId != null)
//{
// serializeModel.AcademicYearId = acaId.Id;
// var sess = acaHelper.GetCurrentSession(acaId.Id);
// if (sess != null)
// {
// serializeModel.SessionId = sess.Id;
// }
// //else
// //{
// // serializeModel.SessionId = 0;
// //}
//}
JavaScriptSerializer serializer = new JavaScriptSerializer();
string userData = serializer.Serialize(serializeModel);
FormsAuthenticationTicket authTicket = new FormsAuthenticationTicket(
1,
//viewModel.Email,
user.UserName,
DateTime.Now,
DateTime.Now.AddMinutes(15),
false,
userData);
string encTicket = FormsAuthentication.Encrypt(authTicket);
HttpCookie faCookie = new HttpCookie(FormsAuthentication.FormsCookieName, encTicket);
Response.Cookies.Set(faCookie);//.Add(faCookie);
//Response.Cookies[FormsAuthentication.FormsCookieName]= faCookie;
/* //FormsAuthentication.set
* //return RedirectToAction("Index", "Home");
* string returnUrl = Request.QueryString["ReturnUrl"] as string;
* if (returnUrl != null)
* {
* //if (returnUrl.Contains("DashBoard%2fStudent") && roles.Contains("student"))
* //{
*
* //}
* Response.Redirect(returnUrl);
* }
* else
* {
* Response.Redirect("~/ViewsSite/Default.aspx");
* }*/
}
//}
}
return(true);
}
catch (Exception exee)
{
return(false);
}
}
//protected void CreateUserWizard1_CreatedUser(object sender, EventArgs e)
//{
// var username = CreateUserWizard1.UserName;
// var password = CreateUserWizard1.Password;
// var email = CreateUserWizard1.Email;
// var que = CreateUserWizard1.Question;
// var ans = CreateUserWizard1.Answer;
// var user = new Academic.DbEntities.User.Users()
// {
// UserName = CreateUserWizard1.UserName
// ,
// Password = CreateUserWizard1.Password
// ,
// Email = CreateUserWizard1.Email
// ,
// SecurityQuestion = CreateUserWizard1.Question
// ,
// SecurityAnswer = CreateUserWizard1.Answer
// };
// using (var helper = new DbHelper.CustomAccount())
// {
// var success = helper.Register(user);
// if (success)
// UserLogin(user);
// }
//}
public void UserLogin(Users viewModel)
{
using (var acchelper = new DbHelper.CustomAccount())
{
//if (Membership.ValidateUser(viewModel.UserName, viewModel.Password))
if (acchelper.CheckUser(viewModel.UserName, viewModel.Password))
{
using (var acaHelper = new DbHelper.AcademicYear())
using (var helper = new DbHelper.User())
{
var user = helper.Users.First(u => u.UserName == viewModel.UserName);
CustomPrincipalSerializeModel serializeModel = new CustomPrincipalSerializeModel();
serializeModel.Id = user.Id;
serializeModel.FirstName = user.FirstName;
serializeModel.LastName = user.LastName;
serializeModel.SchoolId = user.SchoolId ?? 0;
var sess = acaHelper.GetCurrentSession();
if (sess != null)
{
serializeModel.AcademicYearId = sess.AcademicYearId;
serializeModel.SessionId = sess.Id;
}
JavaScriptSerializer serializer = new JavaScriptSerializer();
string userData = serializer.Serialize(serializeModel);
FormsAuthenticationTicket authTicket = new FormsAuthenticationTicket(
1,
//viewModel.Email,
viewModel.UserName,
DateTime.Now,
DateTime.Now.AddMinutes(15),
false,
userData);
string encTicket = FormsAuthentication.Encrypt(authTicket);
HttpCookie faCookie = new HttpCookie(FormsAuthentication.FormsCookieName, encTicket);
Response.Cookies.Add(faCookie);
//FormsAuthentication.set
//return RedirectToAction("Index", "Home");
string returnUrl = Request.QueryString["ReturnUrl"] as string;
if (returnUrl != null)
{
//if (returnUrl.Contains("DashBoard%2fStudent") && roles.Contains("student"))
//{
//}
Response.Redirect(returnUrl);
}
else
{
//Response.Redirect("~/ViewsSite/Default.aspx");
Response.Redirect("~/ViewsSite/User/Dashboard/Dashboard.aspx");
}
}
}
}
}
void LoadData()
{
lblError.Visible = false;
valiStartDate.ErrorMessage = "Required";
valiEnd.ErrorMessage = "Required";
if (!IsPostBack)
{
using (var helper = new DbHelper.AcademicYear())
{
var aca = helper.GetAcademicYear(AcademicYearId);
if (aca != 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.ParentNode.Title
, Value = SiteMap.CurrentNode.ParentNode.ParentNode.Url + "?edit=1"
, Void = true
},
new IdAndName()
{
Name = aca.Name
, Value = SiteMap.CurrentNode.ParentNode.Url + "?aId=1&edit=1"
, Void = true
},
new IdAndName()
{
Name = "Session edit"
}
};
SiteMapUc.SetData(list);
}
//lblHeading.Text = "New Session Create";
lblAcademicHeading.Text = aca.Name;
lblAcademicStart.Text = aca.StartDate.ToString("D");
lblAcademicEnd.Text = aca.EndDate.ToString("D");
ViewState["AcademicYearStartDate"] = aca.StartDate.Date;
ViewState["AcademicYearEndDate"] = aca.EndDate.Date;
var session = helper.GetSession(SessionId);
if (session != null)
{
//lblHeading.Text = @"Edit Session """ + session.Name + @"""";
LoadSessionData(session);
}
}
//LoadSessionParametersAndDate();
}
}
}
public void UserLogin(Users viewModel)
{
using (var acchelper = new DbHelper.CustomAccount())
{
//if (Membership.ValidateUser(viewModel.UserName, viewModel.Password))
var user = acchelper.GetUser(viewModel.UserName, viewModel.Password);
if (user != null)
{
using (var acaHelper = new DbHelper.AcademicYear())
using (var helper = new DbHelper.User())
{
//var user = foundUser;//helper.Users.First(u => u.UserName == viewModel.UserName);
CustomPrincipalSerializeModel serializeModel = new CustomPrincipalSerializeModel();
serializeModel.Id = user.Id;
serializeModel.UserName = user.UserName;
serializeModel.FirstName = user.FirstName;
serializeModel.LastName = user.LastName;
serializeModel.SchoolId = user.SchoolId ?? 0;
serializeModel.TestString = "kkkkk";
var sess = acaHelper.GetCurrentSession();
if (sess != null)
{
serializeModel.AcademicYearId = sess.AcademicYearId;
serializeModel.SessionId = sess.Id;
}
JavaScriptSerializer serializer = new JavaScriptSerializer();
string userData = serializer.Serialize(serializeModel);
FormsAuthenticationTicket authTicket = new FormsAuthenticationTicket(
1,
//viewModel.Email,
viewModel.UserName,
DateTime.Now,
DateTime.Now.AddMinutes(15),
false,
userData);
string encTicket = FormsAuthentication.Encrypt(authTicket);
HttpCookie faCookie = new HttpCookie(FormsAuthentication.FormsCookieName, encTicket);
Response.Cookies.Add(faCookie);
//var reurl = FormsAuthentication.GetRedirectUrl(viewModel.UserName, true);
//if (!string.IsNullOrEmpty(reurl))
//{
// UpdateLoginTime(user.Id);
// //FormsAuthentication.RedirectFromLoginPage(user.UserName, true);
// Response.Redirect(reurl);
//}
//else
{
//FormsAuthentication.set
//return RedirectToAction("Index", "Home");
string returnUrl = Request.QueryString["ReturnUrl"] as string;
if (returnUrl != null)
{
//if (returnUrl.Contains("DashBoard%2fStudent") && roles.Contains("student"))
//{
//}
UpdateLoginTime(user.Id);
var qs = Request.QueryString.ToString().Replace("ReturnUrl=", "");
var queries = qs.Split(new char[] { '&' });
var i = 0;
foreach (var q in queries)
{
if (i > 0)
{
returnUrl += "&" + q;
}
i++;
}
Response.Redirect(returnUrl);
}
else
{
//Response.Redirect("~/ViewsSite/Default.aspx");
UpdateLoginTime(user.Id);
Response.Redirect("~/");
}
}
}
}
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
//var btn = (Button)sender;
//bool task = btn.ID == "btnSaveAndAddMore";
var startdate = DateTime.Now;
var enddate = DateTime.Now;
var start = (DateTime)ViewState["AcademicYearStartDate"];
var end = (DateTime)ViewState["AcademicYearEndDate"];
try
{
startdate = Convert.ToDateTime(txtStart.Text);
if (startdate < start || startdate > end)
{
valiStartDate.ErrorMessage = "Should be between Start and End dates of Academic year.";
valiStartDate.IsValid = false;
}
}
catch
{
valiStartDate.IsValid = false;
valiStartDate.ErrorMessage = "Not in right format.";
}
try
{
//if (Page.IsValid)
{
enddate = Convert.ToDateTime(txtEnd.Text);
if (enddate < start || enddate > end)
{
valiEnd.ErrorMessage = "Should be between Start and End dates of Academic year.";
valiEnd.IsValid = false;
}
if (enddate < startdate)
{
valiStartDate.ErrorMessage = "Can't be greater than end date";
valiStartDate.IsValid = false;
valiEnd.ErrorMessage = "Can't be less than start date";
valiEnd.IsValid = false;
}
}
}
catch
{
valiEnd.IsValid = false;
valiEnd.ErrorMessage = "Not in right format.";
}
if (Page.IsValid)
{
using (var helper = new DbHelper.AcademicYear())
{
var session = new Academic.DbEntities.Session()
{
Id = SessionId,
Name = txtName.Text
,
EndDate = enddate
,
StartDate = startdate
,
AcademicYearId = AcademicYearId
};
//var sav = helper.AddOrUpdateSession(AcademicYearId, session);
//if (sav)
//{
// //if (!task)
// //{
// Response.Redirect("~/Views/Academy/AcademicYear/AcademicYearDetail.aspx?aId=" + AcademicYearId
// + "&edit=1");
// //Response.Redirect("~/Views/Academy/List.aspx");
// //}
// //else
// //{
// // ResetTextBoxes();
// //}
//}
//else lblError.Visible = true;
}
}
}
public void LoadData()
{
var user = Page.User as CustomPrincipal;
if (user != null)
{
//if (user.IsInRole("manager"))
//{
// btnActivate.Visible = true;
//}
//else
//{
// btnActivate.Visible = false;
//}
using (var helper = new DbHelper.AcademicYear())
{
var sId = SessionId;
var aId = AcademicYearId;
var academic = helper.GetAcademicYear(aId);
if (academic != null)
{
var session = academic.Sessions.FirstOrDefault(x => x.Id == sId);
var editQuery = Session["editMode"] as string;//Request.QueryString["edit"];
var edit = (editQuery ?? "0");
if (session != 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.ParentNode.Title
, Value = SiteMap.CurrentNode.ParentNode.ParentNode.Url + "?edit=" + (edit)
, Void = true
},
new IdAndName()
{
Name = academic.Name
, Value = SiteMap.CurrentNode.ParentNode.Url + "?aId=" + AcademicYearId + "&edit=" + edit
, Void = true
},
new IdAndName()
{
Name = session.Name
}
};
SiteMapUc.SetData(list);
}
//start and end dates
lblStart.Text = session.StartDate.ToString("D");
lblEnd.Text = session.EndDate.ToString("D");
//string name = "";
if (session.Completed ?? false)
{
imgActive.ImageUrl = "~/Content/Icons/Stop/Stop_10px.png";
imgActive.Visible = true;
//btnActivate.Visible = false;
//name = " (Complete)";
}
else if (session.IsActive)
{
imgActive.ImageUrl = "~/Content/Icons/Start/active_icon_10px.png";
imgActive.Visible = true;
//name = " (Active)";
//btnActivate.Text = "Mark this as 'Complete'";
}
//else
//{
// btnActivate.Text = "Activate this session";
// //btnMarkComplete.Visible = false;
//}
lblHeading.Text = academic.Name + " - " + session.Name;// + name;
lblPageTitle.Text = lblHeading.Text;
//classes
LoadClasses(session);
//SessionsListingInAYDetailUC.LoadSessionData(academic.Id, session.Id, session.Name, session.StartDate
// , session.EndDate, session.IsActive, session.Completed ?? false, edit == "1");
}
}
}
}
//using (var helper = new DbHelper.AcademicPlacement())
//{
// var classes = helper.ListRunningRunningClasses(AcademicYearId, 0);//.OrderBy(p=>p.ProgramBatch.Program.Name);
// if (classes.Any())
// pnlSessionPrograms.Visible = true;
// ListView1.DataSource = classes;
// ListView1.DataBind();
//}
}
protected void Page_Load(object sender, EventArgs e)
{
lblError.Visible = false;
if (!IsPostBack)
{
try
{
var aId = Request.QueryString["aId"];
var sId = Request.QueryString["sId"];
var clsId = Request.QueryString["clsId"];
var task = Request.QueryString["task"];
var user = Page.User as CustomPrincipal;
if (user != null)
{
using (var clsHelper = new DbHelper.Classes())
using (var helper = new DbHelper.AcademicYear())
{
if (aId != null)
{
#region Academic year
var acaId = Convert.ToInt32(aId);
AcademicYearId = acaId;
var aca = helper.GetAcademicYear(acaId);
if (task != null && aca != null)
{
#region SiteMap
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.ParentNode.ParentNode.Title
, Value = SiteMap.CurrentNode.ParentNode.ParentNode.ParentNode.Url + "?edit=1"
, Void = true
},
new IdAndName()
{
Name = aca.Name
, Value = SiteMap.CurrentNode.ParentNode.ParentNode.Url + "?aId=" + aId + "&edit=1"
, Void = true
},
new IdAndName()
{
Name = (task == "activate")?"Activate":"Mark Complete"
}
};
SiteMapUc.SetData(list);
}
#endregion
if (aca.SchoolId != user.SchoolId)
{
Response.Redirect("~/Views/Academy/List.aspx");
}
Task = task;
if (task == "activate")
{
lblPageTitle.Text = "Activate";
lblHeading.Text = "Activate Academic year : " + aca.Name + ((aca.IsActive) ? " (Active)" : "");
if (aca.IsActive)
{
btnOk.Enabled = false;
btnOk.ToolTip = "Already Active.";
lblQue.Text = "Already Active.";
}
else
{
lblQue.Text =
//"Previous academic year will be marked as completed along with all the running " +
//"classes in that academic year. " +
"All the classes in this academic year will be active. " +
"Are you sure to 'activate' the academic year : " + aca.Name
+ "?";
}
}
else if (task == "completed")
{
lblQue.Text = "All the running classes in this academic year will be marked as completed. " +
"This can't be undone. " +
"Are you sure to mark this academic year : <strong>" + aca.Name + "</strong>" +
", as 'completed'? ";
lblPageTitle.Text = "Mark complete";
lblHeading.Text = "Mark Academic year : " + aca.Name + " as 'Complete'";
}
else
{
Response.Redirect("~/Views/Academy/List.aspx");
}
}
else
{
Response.Redirect("~/Views/Academy/List.aspx");
}
#endregion
}
else if (sId != null)
{
#region Session
var sessId = Convert.ToInt32(sId);
SessionId = sessId;
var sess = helper.GetSession(sessId);
if (task != null && sess != null)
{
#region SiteMap
AcademicYearId = sess.AcademicYearId;
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.ParentNode.ParentNode.Title
, Value = SiteMap.CurrentNode.ParentNode.ParentNode.ParentNode.Url + "?edit=1"
, Void = true
},
new IdAndName()
{
Name = sess.AcademicYear.Name
, Value = SiteMap.CurrentNode.ParentNode.ParentNode.Url
+ "?aId=" + sess.AcademicYearId + "&edit=1"
, Void = true
},
new IdAndName()
{
Name = sess.Name
, Value = SiteMap.CurrentNode.ParentNode.Url + "?aId=" + sess.AcademicYearId
+ "&sId=" + sess.Id + "&edit=1"
, Void = true
},
new IdAndName()
{
Name = (task == "activate")?"Activate":"Mark Complete"
}
};
SiteMapUc.SetData(list);
}
#endregion
if (sess.AcademicYear.SchoolId != user.SchoolId)
{
Response.Redirect("~/Views/Academy/List.aspx");
}
Task = task;
if (task == "activate")
{
lblQue.Text =
"Previous session will be marked as completed along with all the running" +
" classes in that session. This task " +
"can't be undone. " +
"Are you sure to 'activate' the session : " + sess.Name
+ "?";
lblPageTitle.Text = "Activate";
lblHeading.Text = "Activate Session : " + sess.Name;
}
else if (task == "completed")
{
lblQue.Text = "All the running classes in this session will be marked as completed. " +
"This can't be undone. " +
"Are you sure to mark this session '<strong>" + sess.Name +
"</strong>' as '<em>completed</em>'? ";
lblPageTitle.Text = "Mark complete";
lblHeading.Text = "Mark Session : <strong>'" + sess.Name + "'</strong> as '<em>Complete</em>'";
}
else
{
Response.Redirect("~/Views/Academy/List.aspx");
}
}
else
{
Response.Redirect("~/Views/Academy/List.aspx");
}
#endregion
}
else if (clsId != null)
{
var classId = Convert.ToInt32(clsId);
var cls = clsHelper.GetSubjectSession(classId);
if (cls != null && task != null)
{
}
}
else
{
Response.Redirect("~/Views/Academy/List.aspx");
}
}
}
}
catch
{
Response.Redirect("~/Views/Academy/List.aspx");
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
try
{
var aId = Request.QueryString["aId"];
var sId = Request.QueryString["sId"];
var user = Page.User as CustomPrincipal;
if (user != null)
{
if (user.IsInRole("manager") || user.IsInRole("exam-head"))
{
Manager = true;
}
else if (user.IsInRole("teacher"))
{
Teacher = true;
}
//else
using (var acahelper = new DbHelper.AcademicYear())
//using (var helper = new DbHelper.Exam())
{
var acasesList = new List <Academic.ViewModel.AcademicAndSessionCombinedViewModel>();
acasesList = acahelper.ListAcademicAndSessionAsViewModel(user.SchoolId, Manager, Teacher);
var first = acasesList.FirstOrDefault() ?? new AcademicAndSessionCombinedViewModel();
if (aId != null && sId != null)
{
var a = Convert.ToInt32(aId);
var s = Convert.ToInt32(sId);
first = acasesList.FirstOrDefault(x =>
x.AcademicYearId == a && (x.SessionId) == s) ??
new AcademicAndSessionCombinedViewModel()
{
//Id = 0
//,SessionId = 0
//, AcademicYearId = 0
//,Name = ""
//,BothNameCombined = ""
//, Completed = false
//,Check = false
};
}
dlistAcademic.DataSource = acasesList;
dlistAcademic.DataBind();
var index = acasesList.IndexOf(first);
dlistAcademic.SelectedIndex = (index == -1) ? 0 : index;
SetExams(user.SchoolId
, first.AcademicYearId
, first.SessionId
, first.BothNameCombined
, first.Completed);
}
}
}
catch { }
}
}
private void LoadAcademicInfo()
{
using (var helper = new DbHelper.AcademicYear())
{
var aca = helper.GetAcademicYear(AcademicYearId);
if (aca != null)
{
if (!(aca.Void ?? false))
{
lblAcademicInfo.Text = "Classes assign in 'Academic year' : <strong>" + aca.Name + "</strong>";
var ses = helper.GetSession(SessionId);
if (ses != null)
{
hidStartDate.Value = ses.StartDate.ToShortDateString();
hidEndDate.Value = ses.EndDate.ToShortDateString();
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.ParentNode.Title
,
Value = SiteMap.CurrentNode.ParentNode.ParentNode.Url + "?edit=1"
,
Void = true
}
,
new IdAndName()
{
Name = aca.Name
,
Value = SiteMap.CurrentNode.ParentNode.Url + "?aId=" + aca.Id + "&edit=1"
,
Void = true
}
,
new IdAndName()
{
Name = "Classes"
}
};
SiteMapUc.SetData(list);
}
if (aca.Sessions.Select(x => x.Id).Contains(ses.Id))
{
lblAcademicInfo.Text += " and 'Session' : " + ses.Name;
}
else
{
Response.Redirect("~/Views/Academy/AcademicYear/AcademicYearDetail.aspx?aId=" +
AcademicYearId);
}
}
else
{
//ses==null
hidStartDate.Value = aca.StartDate.ToShortDateString();
hidEndDate.Value = aca.EndDate.ToShortDateString();
}
}
else
{
Response.Redirect("~/Views/Academy/List.aspx");
}
}
else
{
Response.Redirect("~/Views/Academy/List.aspx");
}
}
}
