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