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["scId"] != null) { StudentCategoryCL scCL = new StudentCategoryCL(); scCL.id = Convert.ToInt32(Request.QueryString["scId"]); scCL.name = txtSCName.Text; scCL.dateCreated = Convert.ToDateTime(txtDateCreated.Text); scCL.dateModified = dateNow; scCL.isDeleted = false; StudentCategoryCL scReturn = studentCategoryBLL.updateSC(scCL); Response.Redirect("ManageSC.aspx?scId=" + scReturn.id); } else { StudentCategoryCL scCL = new StudentCategoryCL(); scCL.name = txtSCName.Text; scCL.dateCreated = dateNow; scCL.dateModified = dateNow; scCL.isDeleted = false; int scId = studentCategoryBLL.addSC(scCL); Response.Redirect("ManageSC.aspx?scId=" + scId); } }
public StudentCategoryCL viewSCById(int scId) { StudentCategory querySCDB = (from x in dbcontext.StudentCategories where x.Id == scId && x.IsDeleted == false select x).FirstOrDefault(); StudentCategoryCL scCL = new StudentCategoryCL() { id = querySCDB.Id, name = querySCDB.Name, dateCreated = querySCDB.DateCreated, dateModified = querySCDB.DateModified, isDeleted = querySCDB.IsDeleted, totalStrength = querySCDB.Students.Count(), }; return(scCL); }
public int addSC(StudentCategoryCL scInput) { StudentCategory scQuery = dbcontext.StudentCategories.Add(new StudentCategory { Id = scInput.id, Name = scInput.name, DateCreated = scInput.dateCreated, DateModified = scInput.dateModified, IsDeleted = scInput.isDeleted, }); dbcontext.SaveChanges(); int SCId = scQuery.Id; return(SCId); }
public StudentCategoryCL updateSC(StudentCategoryCL scInput) { StudentCategoryCL scReturn = new StudentCategoryCL(); StudentCategory scQuery = (from x in dbcontext.StudentCategories where x.Id == scInput.id select x).FirstOrDefault(); scQuery.Id = scInput.id; scQuery.Name = scInput.name; scQuery.IsDeleted = scInput.isDeleted; scQuery.DateCreated = scInput.dateCreated; scQuery.DateModified = scInput.dateModified; dbcontext.SaveChanges(); scReturn.id = scQuery.Id; scReturn.name = scQuery.Name; scReturn.dateCreated = scQuery.DateCreated; scReturn.dateModified = scQuery.DateModified; scReturn.isDeleted = scQuery.IsDeleted; return(scReturn); }
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["scId"] != null) { int scId = Convert.ToInt32(Request.QueryString["scId"]); lblHeading.Text = "Update Student Category"; StudentCategoryCL scCL = studentCategoryBLL.viewSCById(scId); txtSCName.Text = scCL.name; txtTotalStrength.Text = scCL.totalStrength.ToString(); txtDateCreated.Text = scCL.dateCreated.ToString("dd MMMM yyyy"); txtDateUpdated.Text = scCL.dateModified.ToString("dd MMMM yyyy"); } else { lblHeading.Text = "Add Student Category"; } } } } }