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";
}
}
}
}
}
