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["classId"] != null) { ClassCL classCL = new ClassCL(); classCL.id = Convert.ToInt32(Request.QueryString["classId"]); classCL.class1 = txtClass.Text; classCL.section = txtSection.Text; classCL.sessionId = Convert.ToInt32(Session["sessionId"]); classCL.dateCreated = Convert.ToDateTime(txtDateCreated.Text); classCL.dateModified = dateNow; classCL.isDeleted = false; ClassCL classReturn = classBLL.updateClass(classCL); Response.Redirect("ManageClass.aspx?classid=" + classReturn.id); } else { ClassCL classCL = new ClassCL(); classCL.class1 = txtClass.Text; classCL.section = txtSection.Text; classCL.sessionId = Convert.ToInt32(Session["sessionId"]); classCL.dateCreated = dateNow; classCL.dateModified = dateNow; classCL.isDeleted = false; int classId = classBLL.addClass(classCL); Response.Redirect("ManageClass.aspx?classId=" + classId); } }
/// <summary> /// Adds a class instance of Database from the client Data. /// </summary> /// <param name="classesInput">The input data from the client side.</param> /// <returns></returns> public int addClass(ClassCL classesInput) { Class classQuery = dbcontext.Classes.Add(new Class { Id = classesInput.id, Class1 = classesInput.class1, Section = classesInput.section, SessionId = classesInput.sessionId, DateCreated = classesInput.dateCreated, DateModified = classesInput.dateModified, IsDeleted = classesInput.isDeleted, }); dbcontext.SaveChanges(); int ClassId = classQuery.Id; return(ClassId); }
/// <summary> /// This method fetches the particular Class via ClassId from the database. /// </summary> /// <param name="classId">Details of ClassId to be fetched</param> /// <returns></returns> public ClassCL viewClassById(int classId) { Class queryClassDB = (from x in dbcontext.Classes where x.Id == classId && x.IsDeleted == false select x).FirstOrDefault(); ClassCL classCL = new ClassCL() { class1 = queryClassDB.Class1, id = queryClassDB.Id, section = queryClassDB.Section, sessionId = queryClassDB.SessionId, totalStrength = queryClassDB.Students.Count(), dateCreated = queryClassDB.DateCreated, dateModified = queryClassDB.DateModified, isDeleted = queryClassDB.IsDeleted, classSection = queryClassDB.Class1 + "-" + queryClassDB.Section, }; return(classCL); }
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 { if (Request.QueryString["classId"] != null) { int classId = Convert.ToInt32(Request.QueryString["classId"]); lblHeading.Text = "Update Class"; ClassCL classCL = classBLL.viewClassById(classId); txtClass.Text = classCL.class1; txtSection.Text = classCL.section; txtTotalStrength.Text = classCL.totalStrength.ToString(); txtDateCreated.Text = classCL.dateCreated.ToString("dd MMMM yyyy"); txtDateUpdated.Text = classCL.dateModified.ToString("dd MMMM yyyy"); } else { lblHeading.Text = "Add Class"; } } } } }
/// <summary> /// Updates the class instance of Database from the client data /// </summary> /// <param name="classesInput">Class Data from the Client Side.</param> /// <returns></returns> public ClassCL updateClass(ClassCL classesInput) { ClassCL classReturn = new ClassCL(); Class classQuery = (from x in dbcontext.Classes where x.Id == classesInput.id select x).FirstOrDefault(); classQuery.Class1 = classesInput.class1; classQuery.Section = classesInput.section; classQuery.SessionId = classesInput.sessionId; classQuery.DateCreated = classesInput.dateCreated; classQuery.DateModified = classesInput.dateModified; classQuery.IsDeleted = classesInput.isDeleted; dbcontext.SaveChanges(); classReturn.dateCreated = classQuery.DateCreated; classReturn.dateModified = classQuery.DateModified; classReturn.isDeleted = classQuery.IsDeleted; classReturn.id = classQuery.Id; classReturn.class1 = classQuery.Class1; classReturn.section = classQuery.Section; classReturn.totalStrength = classQuery.Students.Count(); return(classReturn); }