protected void btnSubmit_Click(object sender, EventArgs e)
{
DateTime dateHosting = DateTime.UtcNow;
TimeZoneInfo indianZoneId = TimeZoneInfo.FindSystemTimeZoneById("India Standard Time");
DateTime dateNow = TimeZoneInfo.ConvertTimeFromUtc(dateHosting, indianZoneId);
if (Request.QueryString["examinationId"] != null)
{
ExaminationCL examCL = new ExaminationCL();
examCL.id = Convert.ToInt32(Request.QueryString["examinationId"]);
examCL.classId = Convert.ToInt32(ddlClass.SelectedValue);
examCL.name = txtExamination.Text;
examCL.dateCreated = Convert.ToDateTime(txtDateCreated.Text);
examCL.dateModified = dateNow;
examCL.isDeleted = false;
ExaminationCL examReturn = examinationBLL.updateExamination(examCL);
Response.Redirect("ManageExamination.aspx?examinationid=" + examReturn.id);
}
else
{
ExaminationCL examCL = new ExaminationCL();
examCL.name = txtExamination.Text;
examCL.classId = Convert.ToInt32(ddlClass.SelectedValue);
examCL.dateCreated = dateNow;
examCL.dateModified = dateNow;
examCL.isDeleted = false;
int examId = examinationBLL.addExamination(examCL);
Response.Redirect("ManageExamination.aspx?examinationid=" + examId);
}
}
protected void btnDelete_Click(object sender, EventArgs e)
{
ExaminationCL examCL = new ExaminationCL();
examCL.id = Convert.ToInt32(Request.QueryString["examinationId"]);
examinationBLL.deleteExamination(examCL.id);
Response.Redirect("ManageExamination.aspx");
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (!Request.IsAuthenticated)
{
FormsAuthentication.RedirectToLoginPage();
}
else
{
FormsAuthenticationTicket ticket = (FormsAuthentication.Decrypt(Session["auth"].ToString()));
string userId = ticket.UserData.Split(';')[0];
string role = ticket.UserData.Split(';')[1];
if (Session["sessionId"] == null)
{
SessionCL sessionCL = sessionBLL.addorCheckSession();
Session["sessionId"] = sessionCL.id;
}
else if (role.ToLower() == "teacher" || role.ToLower() == "attendanceo")
{
Response.Redirect("../UnAuthorized.aspx");
}
else
{
sessionId = Convert.ToInt32(Session["sessionId"]);
if (Request.QueryString["examinationId"] != null)
{
int examId = Convert.ToInt32(Request.QueryString["examinationId"]);
lblHeading.Text = "Update Examination";
ddlClass.DataSource = classBLL.viewClasses(sessionId);
ddlClass.DataValueField = "id";
ddlClass.DataTextField = "classSection";
ddlClass.DataBind();
ExaminationCL examCL = examinationBLL.viewExaminationById(examId);
ddlClass.SelectedValue = examCL.classId.ToString();
txtExamination.Text = examCL.name;
txtDateCreated.Text = examCL.dateCreated.ToString("dd MMMM yyyy");
txtDateUpdated.Text = examCL.dateModified.ToString("dd MMMM yyyy");
btnSubmit.Text = "Update";
btnDelete.Visible = true;
}
else
{
lblHeading.Text = "Add Examination";
ddlClass.DataSource = classBLL.viewClasses(sessionId);
ddlClass.DataValueField = "id";
ddlClass.DataTextField = "classSection";
ddlClass.DataBind();
btnSubmit.Text = "Submit";
btnDelete.Visible = false;
}
}
}
}
}
public ExaminationCL viewExaminationById(int examId)
{
Examination queryExamDB = (from x in dbcontext.Examinations where x.Id == examId && x.IsDeleted == false select x).FirstOrDefault();
ExaminationCL examinationCL = new ExaminationCL()
{
name = queryExamDB.Name,
id = queryExamDB.Id,
classSection = queryExamDB.Class.Class1 + "-" + queryExamDB.Class.Section,
classId = queryExamDB.ClassId,
dateCreated = queryExamDB.DateCreated,
dateModified = queryExamDB.DateModified,
isDeleted = queryExamDB.IsDeleted,
};
return(examinationCL);
}
public int addExamination(ExaminationCL examInput)
{
Examination examinationQuery = dbcontext.Examinations.Add(new Examination
{
Id = examInput.id,
Name = examInput.name,
ClassId = examInput.classId,
DateCreated = examInput.dateCreated,
DateModified = examInput.dateModified,
IsDeleted = examInput.isDeleted,
});
dbcontext.SaveChanges();
int ExaminationId = examinationQuery.Id;
return(ExaminationId);
}
public ExaminationCL updateExamination(ExaminationCL examInput)
{
ExaminationCL examReturn = new ExaminationCL();
Examination examQuery = (from x in dbcontext.Examinations where x.Id == examInput.id select x).FirstOrDefault();
examQuery.Name = examInput.name;
examQuery.ClassId = examInput.classId;
examQuery.DateCreated = examInput.dateCreated;
examQuery.DateModified = examInput.dateModified;
examQuery.IsDeleted = examInput.isDeleted;
dbcontext.SaveChanges();
examReturn.dateCreated = examQuery.DateCreated;
examReturn.dateModified = examQuery.DateModified;
examReturn.isDeleted = examQuery.IsDeleted;
examReturn.id = examQuery.Id;
examReturn.name = examQuery.Name;
examReturn.classId = examQuery.ClassId;
return(examReturn);
}
