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);
SMSCL smsNew = new SMSCL();
if (Request.QueryString["smsId"] != null)
{
smsNew.id = Convert.ToInt32(Request.QueryString["smsId"]);
smsNew.template = txtSMS.Text;
smsNew.studentLeaveTypeId = Convert.ToInt32(ddlStudentLeaveType.SelectedValue);
smsNew.dateModified = dateNow;
smsBLL.updateSMS(smsNew);
Response.Redirect("ManageSMSTemplate.aspx?smsId=" + smsNew.id);
}
else
{
smsNew.template = txtSMS.Text;
smsNew.studentLeaveTypeId = Convert.ToInt32(ddlStudentLeaveType.SelectedValue);
smsNew.id = 0;
smsNew.isDeleted = false;
smsNew.dateCreated = dateNow;
smsNew.dateModified = dateNow;
int smsIdUpdated = smsBLL.addSMS(smsNew);
Response.Redirect("ManageSMSTemplate.aspx?smsId=" + smsIdUpdated);
}
}
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["smsId"] != null)
{
lblHeading.Text = "Update SMS Template";
int smsId = Convert.ToInt32(Request.QueryString["smsId"]);
SMSCL smsCL = smsBLL.viewSMSTemplatesById(smsId);
ddlStudentLeaveType.DataSource = studentLTypeBLL.viewStudentLeaveTypes();
ddlStudentLeaveType.DataValueField = "id";
ddlStudentLeaveType.DataTextField = "name";
ddlStudentLeaveType.Items.Insert(0, new ListItem("Select", "-1"));
ddlStudentLeaveType.DataBind();
ddlStudentLeaveType.SelectedValue = smsCL.studentLeaveTypeId.ToString();
txtSMS.Text = smsCL.template;
txtDateCreated.Text = smsCL.dateCreated.ToString();
txtDateUpdated.Text = smsCL.dateModified.ToString();
}
else
{
lblHeading.Text = "Add SMS Template";
ddlStudentLeaveType.DataSource = studentLTypeBLL.viewStudentLeaveTypes();
ddlStudentLeaveType.DataValueField = "id";
ddlStudentLeaveType.DataTextField = "name";
ddlStudentLeaveType.Items.Insert(0, new ListItem("Select", "-1"));
ddlStudentLeaveType.DataBind();
}
}
}
}
}
/// <summary>
/// This method fetches the particular SMS Templates via SMS Template Id from the database.
/// </summary>
/// <param name="smsId">Details of SMS Template Id to be fetched</param>
/// <returns></returns>
public SMSCL viewSMSTemplatesById(int smsId)
{
SM item = (from x in dbcontext.SMS where x.Id == smsId && x.IsDeleted == false select x).FirstOrDefault();
SMSCL smsCL = new SMSCL()
{
dateCreated = item.DateCreated,
dateModified = item.DateModified,
id = item.Id,
isDeleted = item.IsDeleted,
studentLeaveTypeId = item.StudentLeaveTypeId,
template = item.Template,
};
return(smsCL);
}
/// <summary>
/// Adds a student leave type instance of Database from the client Data.
/// </summary>
/// <param name="smsInput">The input data from the client side.</param>
/// <returns></returns>
public int addSMS(SMSCL smsInput)
{
SM smsQuery = dbcontext.SMS.Add(new SM
{
Id = smsInput.id,
Template = smsInput.template,
StudentLeaveTypeId = smsInput.studentLeaveTypeId,
DateCreated = smsInput.dateCreated,
DateModified = smsInput.dateModified,
IsDeleted = smsInput.isDeleted,
});
dbcontext.SaveChanges();
int SMSId = smsQuery.Id;
return(SMSId);
}
/// <summary>
/// Updates the Student Leave Type instance of Database from the client data.
/// </summary>
/// <param name="smsInput">Class Data from the Client Side.</param>
/// <returns></returns>
public SMSCL updateSMS(SMSCL smsInput)
{
SMSCL smsReturn = new SMSCL();
SM smsQuery = (from x in dbcontext.SMS where x.Id == smsInput.id select x).FirstOrDefault();
smsQuery.StudentLeaveTypeId = smsInput.studentLeaveTypeId;
smsQuery.Template = smsInput.template;
smsQuery.DateCreated = smsInput.dateCreated;
smsQuery.DateModified = smsInput.dateModified;
smsQuery.IsDeleted = smsInput.isDeleted;
dbcontext.SaveChanges();
smsReturn.studentLeaveTypeId = smsQuery.StudentLeaveTypeId;
smsReturn.template = smsQuery.Template;
smsReturn.dateCreated = smsQuery.DateCreated;
smsReturn.dateModified = smsQuery.DateModified;
smsReturn.isDeleted = smsQuery.IsDeleted;
return(smsReturn);
}
