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["subjectId"] != null)
{
SubjectCL subjectCL = new SubjectCL();
subjectCL.id = Convert.ToInt32(Request.QueryString["subjectId"]);
subjectCL.name = txtSubject.Text;
subjectCL.dateCreated = Convert.ToDateTime(txtDateCreated.Text);
subjectCL.dateModified = dateNow;
subjectCL.isDeleted = false;
SubjectCL subjectReturn = subjectBLL.updateSubject(subjectCL);
Response.Redirect("ManageSubject.aspx?subjectid=" + subjectReturn.id);
}
else
{
SubjectCL subjectCL = new SubjectCL();
subjectCL.name = txtSubject.Text;
subjectCL.dateCreated = dateNow;
subjectCL.dateModified = dateNow;
subjectCL.isDeleted = false;
int subjectId = subjectBLL.addSubject(subjectCL);
Response.Redirect("ManageSubject.aspx?subjectId=" + subjectId);
}
}
public SubjectCL viewSubjectById(int subjectId)
{
Subject querySubjectDB = (from x in dbcontext.Subjects where x.Id == subjectId && x.IsDeleted == false select x).FirstOrDefault();
SubjectCL subjectCL = new SubjectCL()
{
name = querySubjectDB.Name,
id = querySubjectDB.Id,
totalClasses = querySubjectDB.ClassSubjectMaps.Where(x => x.IsDeleted == false).Count(),
dateCreated = querySubjectDB.DateCreated,
dateModified = querySubjectDB.DateModified,
isDeleted = querySubjectDB.IsDeleted,
};
return(subjectCL);
}
public int addSubject(SubjectCL subjectsInput)
{
Subject subjectQuery = dbcontext.Subjects.Add(new Subject
{
Id = subjectsInput.id,
Name = subjectsInput.name,
DateCreated = subjectsInput.dateCreated,
DateModified = subjectsInput.dateModified,
IsDeleted = subjectsInput.isDeleted,
});
dbcontext.SaveChanges();
int SubjectId = subjectQuery.Id;
return(SubjectId);
}
public SubjectCL updateSubject(SubjectCL subjectInput)
{
SubjectCL subjectReturn = new SubjectCL();
Subject subjectQuery = (from x in dbcontext.Subjects where x.Id == subjectInput.id && x.IsDeleted == false select x).FirstOrDefault();
subjectQuery.Name = subjectInput.name;
subjectQuery.DateCreated = subjectInput.dateCreated;
subjectQuery.DateModified = subjectInput.dateModified;
subjectQuery.IsDeleted = subjectInput.isDeleted;
dbcontext.SaveChanges();
subjectReturn.dateCreated = subjectQuery.DateCreated;
subjectReturn.dateModified = subjectQuery.DateModified;
subjectReturn.isDeleted = subjectQuery.IsDeleted;
subjectReturn.id = subjectQuery.Id;
subjectReturn.name = subjectQuery.Name;
subjectReturn.totalClasses = subjectQuery.ClassSubjectMaps.Where(x => x.IsDeleted == false).Count();
return(subjectReturn);
}
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)
{
Response.Redirect("index.aspx");
}
else if (role.ToLower() == "teacher" || role.ToLower() == "attendanceo")
{
Response.Redirect("../UnAuthorized.aspx");
}
else
{
if (Request.QueryString["subjectId"] != null)
{
int subjectId = Convert.ToInt32(Request.QueryString["subjectId"]);
lblHeading.Text = "Update Subject";
SubjectCL subjectCL = subjectBLL.viewSubjectById(subjectId);
txtSubject.Text = subjectCL.name;
txtTotalStrength.Text = subjectCL.totalClasses.ToString();
txtDateCreated.Text = subjectCL.dateCreated.ToString("dd MMMM yyyy");
txtDateUpdated.Text = subjectCL.dateModified.ToString("dd MMMM yyyy");
}
else
{
lblHeading.Text = "Add Subject";
}
}
}
}
}
