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["sltId"] != null)
{
StudentLeaveTypeCL sltCL = new StudentLeaveTypeCL();
sltCL.id = Convert.ToInt32(Request.QueryString["scId"]);
sltCL.name = txtSLTName.Text;
sltCL.dateCreated = Convert.ToDateTime(txtDateCreated.Text);
sltCL.dateModified = dateNow;
sltCL.isDeleted = false;
StudentLeaveTypeCL sltReturn = studentSLT.updateSLT(sltCL);
Response.Redirect("ManageSLT.aspx?sltId=" + sltReturn.id);
}
else
{
StudentLeaveTypeCL sltCL = new StudentLeaveTypeCL();
sltCL.name = txtSLTName.Text;
sltCL.dateCreated = dateNow;
sltCL.dateModified = dateNow;
sltCL.isDeleted = false;
int sltId = studentSLT.addSlt(sltCL);
Response.Redirect("ManageSLT.aspx?sltId=" + sltId);
}
}
/// <summary>
/// This method fetches the particular Student Leave Types via SLT Id from the database.
/// </summary>
/// <param name="sltId">Details of SLT Id to be fetched</param>
/// <returns></returns>
public StudentLeaveTypeCL viewSLTById(int sltId)
{
StudentLeaveType item = (from x in dbcontext.StudentLeaveTypes where x.Id == sltId && x.IsDeleted == false select x).FirstOrDefault();
StudentLeaveTypeCL sltCL = new StudentLeaveTypeCL()
{
dateCreated = item.DateCreated,
dateModified = item.DateModified,
id = item.Id,
isDeleted = item.IsDeleted,
name = item.Name,
};
return(sltCL);
}
/// <summary>
/// Updates the Student Leave Type instance of Database from the client data.
/// </summary>
/// <param name="sltInput">Class Data from the Client Side.</param>
/// <returns></returns>
public StudentLeaveTypeCL updateSLT(StudentLeaveTypeCL sltInput)
{
StudentLeaveTypeCL sltReturn = new StudentLeaveTypeCL();
StudentLeaveType sltQuery = (from x in dbcontext.StudentLeaveTypes where x.Id == sltInput.id select x).FirstOrDefault();
sltQuery.Name = sltInput.name;
sltQuery.DateCreated = sltInput.dateCreated;
sltQuery.DateModified = sltInput.dateModified;
sltQuery.IsDeleted = sltInput.isDeleted;
dbcontext.SaveChanges();
sltReturn.dateCreated = sltQuery.DateCreated;
sltReturn.dateModified = sltQuery.DateModified;
sltReturn.isDeleted = sltQuery.IsDeleted;
sltReturn.name = sltQuery.Name;
return(sltReturn);
}
/// <summary>
/// Adds a student leave type instance of Database from the client Data.
/// </summary>
/// <param name="sltInput">The input data from the client side.</param>
/// <returns></returns>
public int addSlt(StudentLeaveTypeCL sltInput)
{
StudentLeaveType sltQuery = dbcontext.StudentLeaveTypes.Add(new StudentLeaveType
{
Id = sltInput.id,
Name = sltInput.name,
DateCreated = sltInput.dateCreated,
DateModified = sltInput.dateModified,
IsDeleted = sltInput.isDeleted,
});
dbcontext.SaveChanges();
int SltId = sltQuery.Id;
return(SltId);
}
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["sltId"] != null)
{
int sltId = Convert.ToInt32(Request.QueryString["sltId"]);
lblHeading.Text = "Update Student Leave Type";
StudentLeaveTypeCL sltCL = studentSLT.viewSLTById(sltId);
txtSLTName.Text = sltCL.name;
txtDateCreated.Text = sltCL.dateCreated.ToString("dd MMMM yyyy");
txtDateUpdated.Text = sltCL.dateModified.ToString("dd MMMM yyyy");
}
else
{
lblHeading.Text = "Add Student Leave Type";
}
}
}
}
}
