protected void AssignHomeWork(object sender, EventArgs e)
{
Page.ClientScript.RegisterStartupScript(GetType(), "id", "toggle_forms('AssignHomeWork')", true);
if (Page.IsValid)
{
Stream str = FileUpload1.PostedFile.InputStream;
BinaryReader br = new BinaryReader(str);
Byte[] size = br.ReadBytes((int)str.Length);
DBHandler.DBHandler db = new DBHandler.DBHandler(con);
Entities.Notes n1 = new Entities.Notes()
{
teacher = Session["School"].ToString(),
date = DateTime.Now.ToShortDateString(),
fileName = Path.GetFileName(FileUpload1.PostedFile.FileName),
dataFile = size,
description = TextArea1.Value,
noteType = "Assignment",
};
Entities.Section s1 = new Entities.Section()
{
sectionName = DropDownList2.SelectedValue,
};
Entities.Class c1 = new Entities.Class()
{
className = DropDownList1.SelectedValue,
};
Entities.Subjects s2 = new Entities.Subjects()
{
subjectName = DropDownList3.SelectedValue,
};
db.AddNotes(n1, s2, s1, c1);
TextArea1.Value = " ";
}
}
protected void AddBranch(object sender, EventArgs e)
{
Page.ClientScript.RegisterStartupScript(GetType(), "id", "toggle_forms('foo')", true);
if (Page.IsValid)
{
DBHandler.DBHandler db = new DBHandler.DBHandler(con);
Entities.Campus c1 = new Entities.Campus()
{
campusName = CampusName.Value,
address = address.Value,
zipCode = Convert.ToInt32(ZipCode.Value.ToString()),
phone1 = Phone1.Value,
phone2 = Phone2.Value,
phone3 = Phone3.Value,
principal = PrincipalName.Value,
email = CEmail.Value,
isActive = CCheck.Checked,
};
Entities.ZipCodes z1 = new Entities.ZipCodes()
{
zipCode = Convert.ToInt32(ZipCode.Value.ToString()),
cityName = CityName.Value,
};
db.InsertBranch(c1, z1);
Clabel.Text = "Campus Added Successfully";
}
}
protected void AssignTeacher(object sender, EventArgs e)
{
DBHandler.DBHandler db = new DBHandler.DBHandler(con);
Entities.Section s3 = new Entities.Section()
{
sectionName = SectionDropDown.SelectedValue,
};
Entities.personalInfo p1 = new Entities.personalInfo()
{
pKId = Session["School"].ToString(),
};
Entities.personalInfo p2 = new Entities.personalInfo()
{
pKId = TeacherDropDown.SelectedValue,
};
Entities.Class c1 = new Entities.Class()
{
className = ClassDropDown.SelectedValue,
};
Entities.Subjects s2 = new Entities.Subjects()
{
subjectName = SubjectDropDown.SelectedValue,
};
db.AssignCourses(s3, p1, p2, c1, s2);
GridView2.DataBind();
UpdatePanel1.Update();
Page.ClientScript.RegisterStartupScript(GetType(), "id", "toggle_forms('AssignCourses')", true);
}
protected void UpdateMarks(object sender, EventArgs e)
{
foreach (GridViewRow row in GridView2.Rows)
{
if (row.RowType == DataControlRowType.DataRow)
{
CheckBox Status = row.FindControl("Status") as CheckBox;
bool IsPresent = Status.Checked ? true : false;
string Marks = (row.FindControl("Marks") as TextBox).Text.Trim();
string SchoolID = (row.FindControl("SchoolID") as Label).Text.Trim();
string StudentName = (row.FindControl("StudentName") as Label).Text.Trim();
DBHandler.DBHandler db = new DBHandler.DBHandler(con);
Entities.StudentExam s1 = new Entities.StudentExam()
{
pKId = SchoolID,
examDate = DropDownList4.SelectedValue,
isPresent = IsPresent,
obtainedMarks = Convert.ToDecimal(Marks),
subjectName = DropDownList3.SelectedValue,
};
db.AddStudentExam(s1);
}
}
Page.ClientScript.RegisterStartupScript(GetType(), "id", "toggle_forms('UpdateMarks')", true);
}
protected void GridView2_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "reply")
{
int rowindex = ((GridViewRow)((ImageButton)e.CommandSource).NamingContainer).RowIndex;
int s = Convert.ToInt32(GridView2.DataKeys[rowindex].Value);
DBHandler.DBHandler db = new DBHandler.DBHandler(con);
Entities.Tickets cc1 = new Entities.Tickets()
{
issueId = s,
};
DataSet ds = new DataSet();
ds = db.SelectTicket(cc1);
if (ds != null
&& ds.Tables.Count > 0
&& ds.Tables[0].Rows.Count > 0)
{
TextArea2.Value = ds.Tables[0].Rows[0]["issue"].ToString();
TextBox3.Text = ds.Tables[0].Rows[0]["generatedBy"].ToString();
TextBox4.Text = ds.Tables[0].Rows[0]["issueId"].ToString();
Page.ClientScript.RegisterStartupScript(GetType(), "id", "TicketReplyPop()", true);
}
}
}
private void Details()
{
DBHandler.DBHandler db = new DBHandler.DBHandler(con);
Entities.StudentExam t1 = new Entities.StudentExam()
{
pKId = Session["School"].ToString(),
};
Entities.Class c1 = new Entities.Class()
{
className = "Class 5",
};
Entities.ExamType e1 = new Entities.ExamType()
{
examType = "Mid term",
};
DataSet ds = new DataSet();
ds = db.Graph(t1, c1, e1);
if (ds != null &&
ds.Tables.Count > 0 &&
ds.Tables[0].Rows.Count > 0)
{
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
string sub;
string per;
sub = ds.Tables[0].Rows[i]["subjectName"].ToString();
per = ds.Tables[0].Rows[i]["Percentage"].ToString();
chartData = chartData + sub + "-" + per + "$";
}
Response.Write(chartData);
}
}
protected void UpdateCoursePlan(object sender, EventArgs e)
{
Page.ClientScript.RegisterStartupScript(GetType(), "id", "toggle_forms('CourseProgress')", true);
if (Page.IsValid)
{
DBHandler.DBHandler db = new DBHandler.DBHandler(con);
Entities.CoursePlan cc1 = new Entities.CoursePlan()
{
year = DateTime.Now.Year.ToString(),
Goal = Goal.Value,
progressId = DropDownList7.SelectedIndex + 1,
};
Entities.Section s1 = new Entities.Section()
{
sectionName = DropDownList10.SelectedValue,
};
Entities.Class c1 = new Entities.Class()
{
className = DropDownList8.SelectedValue,
};
Entities.Subjects s2 = new Entities.Subjects()
{
subjectName = DropDownList9.SelectedValue,
};
Entities.personalInfo p1 = new Entities.personalInfo()
{
pKId = Session["School"].ToString(),
};
db.CoursePlan(cc1, s2, s1, c1, p1);
}
}
protected void UpdateAttendance(object sender, EventArgs e)
{
foreach (GridViewRow row in GridView2.Rows)
{
if (row.RowType == DataControlRowType.DataRow)
{
CheckBox Status = row.FindControl("Status") as CheckBox;
bool attendanceStatus = Status.Checked ? true : false;
CheckBox Status1 = row.FindControl("Status1") as CheckBox;
bool smiles = Status1.Checked ? true : false;
string pKId = (row.FindControl("SchoolID") as Label).Text.Trim();
DBHandler.DBHandler db = new DBHandler.DBHandler(con);
Entities.Subjects s1 = new Entities.Subjects()
{
subjectName = DropDownList3.SelectedValue,
};
Entities.SAttendance s2 = new Entities.SAttendance()
{
pKId = pKId,
Sdate = TextBox1.Text,
attendance = attendanceStatus,
smilies = smiles,
};
db.InsertStudentAttendance(s2, s1);
}
}
Page.ClientScript.RegisterStartupScript(GetType(), "id", "toggle_forms('SAttendance')", true);
}
protected void UpdateAttendance(object sender, EventArgs e)
{
foreach (GridViewRow row in GridView2.Rows)
{
if (row.RowType == DataControlRowType.DataRow)
{
CheckBox Status = row.FindControl("Status") as CheckBox;
bool attendanceStatus = Status.Checked ? true : false;
CheckBox Status1 = row.FindControl("Status1") as CheckBox;
bool smiles = Status1.Checked ? true : false;
string pKId = (row.FindControl("SchoolID") as Label).Text.Trim();
DBHandler.DBHandler db = new DBHandler.DBHandler(con);
Entities.Subjects s1 = new Entities.Subjects()
{
subjectName=DropDownList3.SelectedValue,
};
Entities.SAttendance s2 = new Entities.SAttendance()
{
pKId=pKId,
Sdate = TextBox1.Text,
attendance=attendanceStatus,
smilies=smiles,
};
db.InsertStudentAttendance(s2,s1);
}
}
Page.ClientScript.RegisterStartupScript(GetType(), "id", "toggle_forms('SAttendance')", true);
}
protected void UpdateAttendance(object sender, EventArgs e)
{
Page.ClientScript.RegisterStartupScript(GetType(), "id", "toggle_forms('TAttendance')", true);
if (Page.IsValid)
{
foreach (GridViewRow row in GridView1.Rows)
{
if (row.RowType == DataControlRowType.DataRow)
{
CheckBox Status = row.FindControl("Status") as CheckBox;
bool attendanceStatus = Status.Checked ? true : false;
string pKId = (row.FindControl("pKId") as Label).Text.Trim();
string sttendenceDate = (this.Date.Text.Trim());
DBHandler.DBHandler db = new DBHandler.DBHandler(con);
Entities.TAttendance t1 = new Entities.TAttendance()
{
pKId = pKId,
date = sttendenceDate,
attendance = attendanceStatus,
};
db.InsertTeacherAttendance(t1);
AttendanceLabel.Text = "Updated Successfully";
}
}
}
}
private void Details()
{
DBHandler.DBHandler db = new DBHandler.DBHandler(con);
Entities.StudentExam t1 = new Entities.StudentExam()
{
pKId = Session["School"].ToString(),
};
Entities.Class c1 = new Entities.Class()
{
className = "Class 5",
};
Entities.ExamType e1 = new Entities.ExamType()
{
examType = "Mid term",
};
DataSet ds = new DataSet();
ds = db.Graph(t1, c1, e1);
if (ds != null
&& ds.Tables.Count > 0
&& ds.Tables[0].Rows.Count > 0)
{
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
string sub;
string per;
sub = ds.Tables[0].Rows[i]["subjectName"].ToString();
per = ds.Tables[0].Rows[i]["Percentage"].ToString();
chartData = chartData + sub + "-" + per + "$";
}
Response.Write(chartData);
}
}
protected void GridView12_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "reply")
{
int rowindex = ((GridViewRow)((ImageButton)e.CommandSource).NamingContainer).RowIndex;
int s = Convert.ToInt32(GridView12.DataKeys[rowindex].Value);
DBHandler.DBHandler db = new DBHandler.DBHandler(con);
Entities.Tickets cc1 = new Entities.Tickets()
{
issueId = s,
};
DataSet ds = new DataSet();
ds = db.SelectTicket(cc1);
if (ds != null &&
ds.Tables.Count > 0 &&
ds.Tables[0].Rows.Count > 0)
{
TextArea2.Value = ds.Tables[0].Rows[0]["issue"].ToString();
TextBox3.Text = ds.Tables[0].Rows[0]["generatedBy"].ToString();
TextBox4.Text = ds.Tables[0].Rows[0]["issueId"].ToString();
Page.ClientScript.RegisterStartupScript(GetType(), "id", "sTicketReplyPop()", true);
}
else
{
Page.ClientScript.RegisterStartupScript(GetType(), "id", "toggle_forms('PendingTickets')", true);
}
}
}
protected void AssignTest(object sender, EventArgs e)
{
Page.ClientScript.RegisterStartupScript(GetType(), "id", "toggle_forms('UpcomingTest')", true);
if (Page.IsValid)
{
DBHandler.DBHandler db = new DBHandler.DBHandler(con);
Entities.Notes n1 = new Entities.Notes()
{
teacher = Session["School"].ToString(),
date = DateTime.Now.ToShortDateString(),
description = TextArea2.Value,
noteType = "Quiz",
};
Entities.Section s1 = new Entities.Section()
{
sectionName = DropDownList5.SelectedValue,
};
Entities.Class c1 = new Entities.Class()
{
className = DropDownList4.SelectedValue,
};
Entities.Subjects s2 = new Entities.Subjects()
{
subjectName = DropDownList6.SelectedValue,
};
db.AddNotes(n1, s2, s1, c1);
TextArea2.Value = " ";
}
}
protected void UpdateMarks(object sender, EventArgs e)
{
foreach (GridViewRow row in GridView2.Rows)
{
if (row.RowType == DataControlRowType.DataRow)
{
CheckBox Status = row.FindControl("Status") as CheckBox;
bool IsPresent = Status.Checked ? true : false;
string Marks = (row.FindControl("Marks") as TextBox).Text.Trim();
string SchoolID = (row.FindControl("SchoolID") as Label).Text.Trim();
string StudentName = (row.FindControl("StudentName") as Label).Text.Trim();
DBHandler.DBHandler db = new DBHandler.DBHandler(con);
Entities.StudentExam s1 = new Entities.StudentExam()
{
pKId = SchoolID,
examDate = DropDownList4.SelectedValue,
isPresent = IsPresent,
obtainedMarks = Convert.ToDecimal(Marks),
subjectName=DropDownList3.SelectedValue,
};
db.AddStudentExam(s1);
}
}
Page.ClientScript.RegisterStartupScript(GetType(), "id", "toggle_forms('UpdateMarks')", true);
}
protected void AddBranch(object sender, EventArgs e)
{
Page.ClientScript.RegisterStartupScript(GetType(), "id", "toggle_forms('foo')", true);
if (Page.IsValid)
{
DBHandler.DBHandler db = new DBHandler.DBHandler(con);
Entities.Campus c1 = new Entities.Campus()
{
campusName = CampusName.Value,
address = address.Value,
zipCode = Convert.ToInt32(ZipCode.Value.ToString()),
phone1 = Phone1.Value,
phone2 = Phone2.Value,
phone3 = Phone3.Value,
principal = PrincipalName.Value,
email = CEmail.Value,
isActive = CCheck.Checked,
};
Entities.ZipCodes z1 = new Entities.ZipCodes()
{
zipCode = Convert.ToInt32(ZipCode.Value.ToString()),
cityName = CityName.Value,
};
db.InsertBranch(c1, z1);
Clabel.Text = "Campus Added Successfully";
}
}
protected void AssignStudent(object sender, EventArgs e)
{
Page.ClientScript.RegisterStartupScript(GetType(), "id", "toggle_forms('AssignStudentClass')", true);
if (Page.IsValid)
{
DBHandler.DBHandler db = new DBHandler.DBHandler(con);
Entities.personalInfo t1 = new Entities.personalInfo()
{
pKId = Session["School"].ToString(),
};
Entities.StudentSubject t2 = new Entities.StudentSubject()
{
pKId = SchoolID.Value,
year = Year.Text,
};
Entities.Class c1 = new Entities.Class()
{
className = DropDownList1.SelectedValue,
};
Entities.Section s1 = new Entities.Section()
{
sectionName = DropDownList2.SelectedValue,
};
db.AssignStudentClass(t1, t2, c1, s1);
SqlDataSource6.DataBind();
GridView1.DataBind();
}
}
protected void AddExam(object sender, EventArgs e)
{
Page.ClientScript.RegisterStartupScript(GetType(), "id", "toggle_forms('ExamType')", true);
if (Page.IsValid)
{
DBHandler.DBHandler db = new DBHandler.DBHandler(con);
Entities.ExamType e1 = new Entities.ExamType()
{
examTypeId = ExamID.Value,
examType = ExamName.Value,
};
db.AddExamypes(e1);
GridView1.DataBind();
UpdatePanel1.Update();
ExamDate1.UpdateExam();
}
}
protected void AddCourse(object sender, EventArgs e)
{
Page.ClientScript.RegisterStartupScript(GetType(), "id", "toggle_forms('Courses')", true);
if (Page.IsValid)
{
DBHandler.DBHandler db = new DBHandler.DBHandler(con);
Entities.Subjects t1 = new Entities.Subjects()
{
subjectId = CourseId.Value,
subjectName = CourseName.Value,
};
db.AddCourse(t1);
GridView2.DataBind();
UpdatePanel4.Update();
TecherSection1.UpdateCourse();
ExamDate1.UpdateCourse();
}
}
protected void ClassAndSection(object sender, EventArgs e)
{
DBHandler.DBHandler db = new DBHandler.DBHandler(con);
Entities.CampusClassSection t1 = new Entities.CampusClassSection()
{
className = ClassDropDown.SelectedValue,
sectionName = SectionDropDown.SelectedValue,
};
Entities.personalInfo p1 = new Entities.personalInfo()
{
pKId = Session["School"].ToString(),
};
db.InsertCampusClassSection(t1, p1);
ClassSectionLabel.Text = "Added Successfully";
GridView1.DataBind();
UpdatePanel1.Update();
Page.ClientScript.RegisterStartupScript(GetType(), "id", "toggle_forms('ClassAndSection')", true);
}
protected void ClassAndSection(object sender, EventArgs e)
{
DBHandler.DBHandler db = new DBHandler.DBHandler(con);
Entities.CampusClassSection t1 = new Entities.CampusClassSection()
{
className = ClassDropDown.SelectedValue,
sectionName = SectionDropDown.SelectedValue,
};
Entities.personalInfo p1 = new Entities.personalInfo()
{
pKId = Session["School"].ToString(),
};
db.InsertCampusClassSection(t1, p1);
ClassSectionLabel.Text = "Added Successfully";
GridView1.DataBind();
UpdatePanel1.Update();
Page.ClientScript.RegisterStartupScript(GetType(), "id", "toggle_forms('ClassAndSection')", true);
}
public long AddAccountDetails(ArrayList AddAccountAL, int _CompanyIndex)
{
Logger.InfoLog("ControlGenerator:: Inside AddAccountDetails");
long ReturnDBVal = -1;
try
{
PACT.DBHandler.DBHandler DBH = new DBHandler.DBHandler();
string s = DBH.SetAccountDetails(_CompanyIndex, AddAccountAL, out ReturnDBVal);
Logger.InfoLog("ControlGenerator:: Success: DBH.SetAccountDetails " + ReturnDBVal.ToString());
return(ReturnDBVal);
}
catch (Exception ex)
{
Logger.ErrorLog("ControlGenerator:: AddAccount Details" + ex.StackTrace.ToString());
return(ReturnDBVal);
}
}
protected void AddExamDate(object sender, EventArgs e)
{
Page.ClientScript.RegisterStartupScript(GetType(), "id", "toggle_forms('ExamDate')", true);
if (Page.IsValid)
{
DBHandler.DBHandler db = new DBHandler.DBHandler(con);
Entities.ExamDate cc1 = new Entities.ExamDate()
{
examDate = EDate.Text,
totalMarks = Convert.ToInt32(TotalMarks.Value),
};
Entities.Section s1 = new Entities.Section()
{
sectionName = DropDownList2.SelectedValue,
};
Entities.Class c1 = new Entities.Class()
{
className = DropDownList1.SelectedValue,
};
Entities.Subjects s2 = new Entities.Subjects()
{
subjectName = DropDownList3.SelectedValue,
};
Entities.personalInfo p1 = new Entities.personalInfo()
{
pKId = Session["School"].ToString(),
};
Entities.ExamType e1 = new Entities.ExamType()
{
examTypeId = DropDownList4.SelectedValue,
};
db.AddExamDate(cc1, s2, s1, c1, p1, e1);
GridView1.DataBind();
UpdatePanel1.Update();
}
}
protected void AddSurvey(object sender, EventArgs e)
{
Page.ClientScript.RegisterStartupScript(GetType(), "id", "toggle_forms('NewSurvey')", true);
if (Page.IsValid)
{
DBHandler.DBHandler db = new DBHandler.DBHandler(con);
Entities.Survey s1 = new Entities.Survey()
{
surveyName = ASurveyName.Value,
surveyDate = DateTime.Now.ToShortDateString(),
surveyGeneratedBy = Session["School"].ToString(),
surveyGeneratedFor = DropDownList3.SelectedValue,
type = Convert.ToInt32(RadioButtonList1.SelectedValue),
};
surveyid = db.InsertSurvey(s1);
Panel1.Visible = true;
Panel2.Visible = false;
}
}
protected void TicketReply(object sender, EventArgs e)
{
Page.ClientScript.RegisterStartupScript(GetType(), "id", "sTicketReplyPop()", true);
if (Page.IsValid)
{
DBHandler.DBHandler db = new DBHandler.DBHandler(con);
Entities.Tickets t1 = new Entities.Tickets()
{
generatedBy = Session["School"].ToString(),
generatedFor = TextBox3.Text,
issueDate = DateTime.Now.ToShortDateString(),
issue = TextBox2.Text,
linkedWith = Convert.ToInt32(TextBox4.Text),
isNew = false,
};
db.AddTicket(t1);
Label7.Text = "Replied Successfully";
}
}
public void Smiles()
{
DBHandler.DBHandler db = new DBHandler.DBHandler(con);
Entities.personalInfo p1 = new Entities.personalInfo()
{
pKId = Session["School"].ToString(),
};
DataSet ds = new DataSet();
ds = db.CountSmiles(p1);
if (ds != null &&
ds.Tables.Count > 0 &&
ds.Tables[0].Rows.Count > 0)
{
// Label1.Text = ds.Tables[0].Rows[0]["Smilies"].ToString();
// Label2.Text = ds.Tables[0].Rows[0]["Sad"].ToString();
}
}
protected void ADDEvaluation(object sender, EventArgs e)
{
Page.ClientScript.RegisterStartupScript(GetType(), "id", "toggle_forms('Evaluation')", true);
if (Page.IsValid)
{
DBHandler.DBHandler db = new DBHandler.DBHandler(con);
Entities.Recommendations r1 = new Entities.Recommendations()
{
studentId = EDropDown.SelectedValue,
teacher = Session["School"].ToString(),
Adate = DateTime.Now.ToShortDateString(),
appitude = EAptitude.Value,
attitude = EAttitude.Value,
recommendation = ERecommendation.Value,
};
db.AddEvaluation(r1);
Label1.Text = "Student Evaluated Successfully";
}
}
protected void AddSurvey(object sender, EventArgs e)
{
Page.ClientScript.RegisterStartupScript(GetType(), "id", "toggle_forms('NewSurvey')", true);
if (Page.IsValid)
{
DBHandler.DBHandler db = new DBHandler.DBHandler(con);
Entities.Survey s1 = new Entities.Survey()
{
surveyName = ASurveyName.Value,
surveyDate = DateTime.Now.ToShortDateString(),
surveyGeneratedBy = Session["School"].ToString(),
surveyGeneratedFor = DropDownList3.SelectedValue,
type = Convert.ToInt32(RadioButtonList1.SelectedValue),
};
surveyid = db.InsertSurvey(s1);
Panel1.Visible = true;
Panel2.Visible = false;
}
}
public long AddAccountDetails(ArrayList AddAccountAL, int _CompanyIndex)
{
Logger.InfoLog("ControlGenerator:: Inside AddAccountDetails");
long ReturnDBVal = -1;
try
{
PACT.DBHandler.DBHandler DBH = new DBHandler.DBHandler();
string s = DBH.SetAccountDetails(_CompanyIndex, AddAccountAL, out ReturnDBVal);
Logger.InfoLog("ControlGenerator:: Success: DBH.SetAccountDetails " + ReturnDBVal.ToString());
return ReturnDBVal;
}
catch (Exception ex)
{
Logger.ErrorLog("ControlGenerator:: AddAccount Details" + ex.StackTrace.ToString());
return ReturnDBVal;
}
}
protected void GridView8_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "show")
{
int rowindex = ((GridViewRow)((ImageButton)e.CommandSource).NamingContainer).RowIndex;
s = Convert.ToInt32(GridView8.DataKeys[rowindex].Value);
GridViewRow row = (GridViewRow)(((ImageButton)e.CommandSource).NamingContainer);
string check = (row.FindControl("type") as Label).Text.Trim();
DBHandler.DBHandler db = new DBHandler.DBHandler(con);
Entities.SurveyQuestion q1 = new Entities.SurveyQuestion()
{
surveyId = s,
};
DataSet ds = new DataSet();
ds = db.ShowSurvey(q1);
if (ds != null &&
ds.Tables.Count > 0 &&
ds.Tables[0].Rows.Count > 0)
{
if (check == "Yes/No")
{
GridView9.DataSource = ds;
GridView9.DataBind();
Page.ClientScript.RegisterStartupScript(GetType(), "id", "sShowSurveyPop()", true);
Panel4.Visible = true;
Panel3.Visible = false;
}
else if (check == "Rating")
{
GridView10.DataSource = ds;
GridView10.DataBind();
Page.ClientScript.RegisterStartupScript(GetType(), "id", "sShowSurveyPop()", true);
Panel4.Visible = false;
Panel3.Visible = true;
}
}
else
{
Page.ClientScript.RegisterStartupScript(GetType(), "id", "toggle_forms('ShowSurvey')", true);
}
}
}
protected void AddCourse(object sender, EventArgs e)
{
Page.ClientScript.RegisterStartupScript(GetType(), "id", "toggle_forms('Courses')", true);
if (Page.IsValid)
{
DBHandler.DBHandler db = new DBHandler.DBHandler(con);
Entities.Subjects t1 = new Entities.Subjects()
{
subjectId = CourseId.Value,
subjectName = CourseName.Value,
};
db.AddCourse(t1);
GridView2.DataBind();
UpdatePanel4.Update();
TecherSection1.UpdateCourse();
ExamDate1.UpdateCourse();
}
}
protected void AddSection(object sender, EventArgs e)
{
Page.ClientScript.RegisterStartupScript(GetType(), "id", "toggle_forms('AddSections')", true);
if (Page.IsValid)
{
DBHandler.DBHandler db = new DBHandler.DBHandler(con);
Entities.Section t1 = new Entities.Section()
{
sectionName = SectionName.Value,
};
db.InsertSection(t1);
SSections.DataBind();
GSections.DataBind();
UpdatePanel3.Update();
AddClassSection1.UpdateSection();
TecherSection1.UpdateSection();
StudentSection1.UpdateSection();
ExamDate1.UpdateSection();
SectionLabel.Text = "Section Added Successfully";
}
}
private DataSet GetScreenInfo(int _ScreenID, string _CompanyIndex)
{
Logger.InfoLog("ControlGenerator:: Inside GetScreenInfo");
try
{
PACT.DBHandler.DBHandler DBH = new DBHandler.DBHandler();
ArrayList AL = new ArrayList();
AL.Add(1);
AL.Add("Majeed");
AL.Add(0);
DataSet ds = DBH.GetAddAccountScreenDetails(1, AL);
return(ds);
}
catch (Exception ex)
{
Logger.ErrorLog("ControlGenerator:: GetScreenInfo" + ex.StackTrace.ToString());
return(null);
}
}
protected void AddTicket(object sender, EventArgs e)
{
Page.ClientScript.RegisterStartupScript(GetType(), "id", "toggle_forms('NewTicket')", true);
if (Page.IsValid)
{
DBHandler.DBHandler db = new DBHandler.DBHandler(con);
Entities.Tickets t1 = new Entities.Tickets()
{
generatedBy = Session["School"].ToString(),
generatedFor = IcreatedFor.Text,
issueDate = DateTime.Now.ToShortDateString(),
issue = TextBox1.Text,
};
db.AddTicket(t1);
GridView11.DataBind();
UpdatePanel1.Update();
Page.ClientScript.RegisterStartupScript(GetType(), "id", "toggle_forms('NewTicket')", true);
Label6.Text = "Issue Added Successfully";
TextBox1.Text = " ";
}
}
protected void UpdateGrades(object sender, EventArgs e)
{
foreach (GridViewRow row in GridView1.Rows)
{
if (row.RowType == DataControlRowType.DataRow)
{
string Marks = (row.FindControl("Grade") as TextBox).Text.Trim();
string SchoolID = (row.FindControl("SchoolID") as Label).Text.Trim();
string StudentName = (row.FindControl("StudentName") as Label).Text.Trim();
DBHandler.DBHandler db = new DBHandler.DBHandler(con);
Entities.StudentSubject s1 = new Entities.StudentSubject()
{
pKId = SchoolID,
grade = Marks,
subjectName=DropDownList7.SelectedValue,
};
db.InsertStudentGrade(s1);
}
}
Page.ClientScript.RegisterStartupScript(GetType(), "id", "toggle_forms('UpdateGrade')", true);
}
protected void UpdateGrades(object sender, EventArgs e)
{
foreach (GridViewRow row in GridView1.Rows)
{
if (row.RowType == DataControlRowType.DataRow)
{
string Marks = (row.FindControl("Grade") as TextBox).Text.Trim();
string SchoolID = (row.FindControl("SchoolID") as Label).Text.Trim();
string StudentName = (row.FindControl("StudentName") as Label).Text.Trim();
DBHandler.DBHandler db = new DBHandler.DBHandler(con);
Entities.StudentSubject s1 = new Entities.StudentSubject()
{
pKId = SchoolID,
grade = Marks,
subjectName = DropDownList7.SelectedValue,
};
db.InsertStudentGrade(s1);
}
}
Page.ClientScript.RegisterStartupScript(GetType(), "id", "toggle_forms('UpdateGrade')", true);
}
protected void AddTicket(object sender, EventArgs e)
{
Page.ClientScript.RegisterStartupScript(GetType(), "id", "toggle_forms('NewTicket')", true);
if (Page.IsValid)
{
DBHandler.DBHandler db = new DBHandler.DBHandler(con);
Entities.Tickets t1 = new Entities.Tickets()
{
generatedBy = Session["School"].ToString(),
generatedFor = IcreatedFor.Text,
issueDate = DateTime.Now.ToShortDateString(),
issue = TextBox1.Text,
};
db.AddTicket(t1);
GridView1.DataBind();
UpdatePanel1.Update();
Page.ClientScript.RegisterStartupScript(GetType(), "id", "toggle_forms('NewTicket')", true);
Label2.Text = "Issue Added Successfully";
TextBox1.Text = " ";
}
}
public void Quiz()
{
DBHandler.DBHandler db = new DBHandler.DBHandler(con);
Entities.Notes t1 = new Entities.Notes()
{
noteType = "Quiz",
};
Entities.personalInfo p1 = new Entities.personalInfo()
{
pKId = Session["School"].ToString(),
};
Entities.Class c1 = new Entities.Class()
{
className = "Class 5",
};
DataSet ds = new DataSet();
ds = db.ShowSubNotes(t1, p1, c1);
GridView3.DataSource = ds;
GridView3.DataBind();
}
protected void ShowMarks(object sender, EventArgs e)
{
DBHandler.DBHandler db = new DBHandler.DBHandler(con);
Entities.StudentExam t1 = new Entities.StudentExam()
{
pKId = Session["School"].ToString(),
};
Entities.Class c1 = new Entities.Class()
{
className = DropDownList3.SelectedValue,
};
Entities.ExamType e1 = new Entities.ExamType()
{
examType = DropDownList4.SelectedValue,
};
DataSet ds = new DataSet();
ds = db.Graph(t1, c1, e1);
GridView7.DataSource = ds;
GridView7.DataBind();
Page.ClientScript.RegisterStartupScript(GetType(), "id", "toggle_forms('ProgrssStudent')", true);
}
protected void AddClass(object sender, EventArgs e)
{
Page.ClientScript.RegisterStartupScript(GetType(), "id", "toggle_forms('AddClasses')", true);
if (Page.IsValid)
{
DBHandler.DBHandler db = new DBHandler.DBHandler(con);
Entities.Class t1 = new Entities.Class()
{
classId = ClassId.Value,
className = ClassName.Value,
};
db.InsertClass(t1);
SClasses.DataBind();
GClasses.DataBind();
UpdatePanel2.Update();
AddClassSection1.UpdateClass();
TecherSection1.UpdateClass();
StudentSection1.UpdateClass();
ExamDate1.UpdateClass();
ClassLabel.Text = "Class Added Successfully";
}
}
protected void ShowAttendance(object sender, EventArgs e)
{
DBHandler.DBHandler db = new DBHandler.DBHandler(con);
Entities.personalInfo p1 = new Entities.personalInfo()
{
pKId = Session["School"].ToString(),
};
Entities.Subjects s2 = new Entities.Subjects()
{
subjectName = DropDownList2.SelectedValue,
};
Entities.SAttendance s1 = new Entities.SAttendance()
{
Sdate = DropDownList1.SelectedValue,
};
DataSet ds = new DataSet();
ds = db.ShowStudentAttendacne(p1, s1, s2);
GridView4.DataSource = ds;
GridView4.DataBind();
Page.ClientScript.RegisterStartupScript(GetType(), "id", "toggle_forms('Attendance')", true);
}
protected void AddTeacher(object sender, EventArgs e)
{
Page.ClientScript.RegisterStartupScript(GetType(), "id", "toggle_forms('TeacherSection')", true);
if (Page.IsValid)
{
Stream str = FileUpload1.PostedFile.InputStream;
BinaryReader br = new BinaryReader(str);
Byte[] size = br.ReadBytes((int)str.Length);
DBHandler.DBHandler db = new DBHandler.DBHandler(con);
Entities.personalInfo t1 = new Entities.personalInfo()
{
pKId = TID.Value,
passCode = TPassword.Value,
firstName = TFirstName.Value,
middleName = TMiddleName.Value,
lastName = TLastName.Value,
iAm = Session["School"].ToString(),
phone = TPhoneNo.Value,
emergencyContact = TEmergency.Value,
cellNo = TMobNo.Value,
eMail = TEmail.Value,
enrollmentDate = TEnrollmentDate.Text,
dOB = TDateOfBirth.Text,
gender = Convert.ToInt32(TGender.SelectedIndex.ToString()),
userType = TTypeOfUser.SelectedValue,
isNew = IsNew.Checked,
isActive = TIsActive.Checked,
address1 = TAddress1.Value,
address2 = TAddress2.Value,
address3 = TAddress3.Value,
fileName = Path.GetFileName(FileUpload1.PostedFile.FileName),
recordFile = size,
};
db.insertTest(t1);
UpdateTeacher();
SqlDataSource7.DataBind();
GridView3.DataBind();
}
}
protected void AddStudent(object sender, EventArgs e)
{
Page.ClientScript.RegisterStartupScript(GetType(), "id", "toggle_forms('StudentSection')", true);
if (Page.IsValid)
{
Stream str = FileUpload1.PostedFile.InputStream;
BinaryReader br = new BinaryReader(str);
Byte[] size = br.ReadBytes((int)str.Length);
DBHandler.DBHandler db = new DBHandler.DBHandler(con);
Entities.personalInfo t1 = new Entities.personalInfo()
{
pKId = SID.Value,
passCode = SPassword.Value,
firstName = SFirstName.Value,
middleName = SMiddleName.Value,
lastName = SLastName.Value,
phone = SPhoneNo.Value,
cellNo = SMobNo.Value,
emergencyContact = SEmergency.Value,
iAm = Session["School"].ToString(),
eMail = SEmail.Value,
enrollmentDate = SEnrollmentDate.Text,
dOB = SDateOfBirth.Text,
gender = Convert.ToInt32(SGender.SelectedIndex.ToString()),
userType = STypeOfUser.SelectedValue,
isActive = SIsActive.Checked,
isNew = IsNew.Checked,
address1 = SAddress1.Value,
address2 = SAddress2.Value,
address3 = SAddress3.Value,
fileName = Path.GetFileName(FileUpload1.PostedFile.FileName),
recordFile = size,
};
db.insertTest(t1);
Label2.Text = "Added Successfully";
SqlDataSource4.DataBind();
GridView3.DataBind();
}
}
protected void AdminAssign(object sender, EventArgs e)
{
Page.ClientScript.RegisterStartupScript(GetType(), "id", "toggle_forms('admin')", true);
if (Page.IsValid)
{
Stream str = FileUpload1.PostedFile.InputStream;
BinaryReader br = new BinaryReader(str);
Byte[] size = br.ReadBytes((int)str.Length);
DBHandler.DBHandler db = new DBHandler.DBHandler(con);
Entities.personalInfo t1 = new Entities.personalInfo()
{
pKId = AID.Value,
firstName = AFirstName.Value,
middleName = AMiddleName.Value,
lastName = ALastName.Value,
iAm = Session["School"].ToString(),
phone = APhoneNo.Value,
emergencyContact = AEmergency.Value,
cellNo = AMobNo.Value,
eMail = AEmail.Value,
enrollmentDate = AEnrollmentDate.Text,
dOB = ADateOfBirth.Text,
gender = Convert.ToInt32(DropDownList2.SelectedIndex.ToString()),
userType = DropDownList1.SelectedValue,
isActive = IsActive.Checked,
isNew = IsNew.Checked,
passCode = APassword.Value,
address1 = AAdress1.Value,
address2 = AAdress2.Value,
address3 = AAdress3.Value,
fileName = Path.GetFileName(FileUpload1.PostedFile.FileName),
recordFile = size,
};
db.insertTest(t1);
SqlDataSource4.DataBind();
GridView3.DataBind();
}
}
protected void AddClass(object sender, EventArgs e)
{
Page.ClientScript.RegisterStartupScript(GetType(), "id", "toggle_forms('AddClasses')", true);
if (Page.IsValid)
{
DBHandler.DBHandler db = new DBHandler.DBHandler(con);
Entities.Class t1 = new Entities.Class()
{
classId = ClassId.Value,
className = ClassName.Value,
};
db.InsertClass(t1);
SClasses.DataBind();
GClasses.DataBind();
UpdatePanel2.Update();
AddClassSection1.UpdateClass();
TecherSection1.UpdateClass();
StudentSection1.UpdateClass();
ExamDate1.UpdateClass();
ClassLabel.Text = "Class Added Successfully";
}
}
protected void SubmitSurvey(object sender, EventArgs e)
{
if (Panel3.Visible == true)
{
foreach (GridViewRow row in GridView3.Rows)
{
if (row.RowType == DataControlRowType.DataRow)
{
int questionid = int.Parse((row.FindControl("Label1") as Label).Text);
DropDownList ddl = row.FindControl("DropDownList4") as DropDownList;
int answer = ddl.SelectedIndex;
DBHandler.DBHandler db = new DBHandler.DBHandler(con);
Entities.SurveyReply s1 = new Entities.SurveyReply()
{
surveyId = s,
questionId = questionid,
answer = answer,
repliedBy = Session["School"].ToString(),
};
db.SurveyReply(s1);
}
}
DBHandler.DBHandler db1 = new DBHandler.DBHandler(con);
Entities.SurveyReply s2 = new Entities.SurveyReply()
{
surveyId = s,
repliedBy = Session["School"].ToString(),
};
Entities.Survey s3 = new Entities.Survey()
{
surveyDate = DateTime.Now.ToShortDateString(),
};
db1.InsertSurveyResponse(s2, s3);
Page.ClientScript.RegisterStartupScript(GetType(), "id", "toggle_forms('ShowSurvey')", true);
}
else if (Panel4.Visible == true)
{
foreach (GridViewRow row in GridView1.Rows)
{
if (row.RowType == DataControlRowType.DataRow)
{
int questionid = int.Parse((row.FindControl("Label1") as Label).Text);
CheckBox ddl = row.FindControl("CheckBox1") as CheckBox;
int answer = ddl.Checked ? 6 : 7;
DBHandler.DBHandler db = new DBHandler.DBHandler(con);
Entities.SurveyReply s1 = new Entities.SurveyReply()
{
surveyId = s,
questionId = questionid,
answer = answer,
repliedBy = Session["School"].ToString(),
};
db.SurveyReply(s1);
}
}
DBHandler.DBHandler db1 = new DBHandler.DBHandler(con);
Entities.SurveyReply s2 = new Entities.SurveyReply()
{
surveyId = s,
repliedBy = Session["School"].ToString(),
};
Entities.Survey s3 = new Entities.Survey()
{
surveyDate = DateTime.Now.ToShortDateString(),
};
db1.InsertSurveyResponse(s2, s3);
Page.ClientScript.RegisterStartupScript(GetType(), "id", "toggle_forms('ShowSurvey')", true);
}
}
protected void AssignStudent(object sender, EventArgs e)
{
Page.ClientScript.RegisterStartupScript(GetType(), "id", "toggle_forms('AssignStudentClass')", true);
if (Page.IsValid)
{
DBHandler.DBHandler db = new DBHandler.DBHandler(con);
Entities.personalInfo t1 = new Entities.personalInfo()
{
pKId = Session["School"].ToString(),
};
Entities.StudentSubject t2 = new Entities.StudentSubject()
{
pKId = SchoolID.Value,
year=Year.Text,
};
Entities.Class c1 = new Entities.Class()
{
className = DropDownList1.SelectedValue,
};
Entities.Section s1 = new Entities.Section()
{
sectionName = DropDownList2.SelectedValue,
};
db.AssignStudentClass(t1, t2, c1, s1);
SqlDataSource6.DataBind();
GridView1.DataBind();
}
}
protected void UpdateAttendance(object sender, EventArgs e)
{
Page.ClientScript.RegisterStartupScript(GetType(), "id", "toggle_forms('TAttendance')", true);
if (Page.IsValid)
{
foreach (GridViewRow row in GridView1.Rows)
{
if (row.RowType == DataControlRowType.DataRow)
{
CheckBox Status = row.FindControl("Status") as CheckBox;
bool attendanceStatus = Status.Checked ? true : false;
string pKId = (row.FindControl("pKId") as Label).Text.Trim();
string sttendenceDate = (this.Date.Text.Trim());
DBHandler.DBHandler db = new DBHandler.DBHandler(con);
Entities.TAttendance t1 = new Entities.TAttendance()
{
pKId = pKId,
date = sttendenceDate,
attendance = attendanceStatus,
};
db.InsertTeacherAttendance(t1);
AttendanceLabel.Text = "Updated Successfully";
}
}
}
}
protected void GenerateSurvey(object sender, EventArgs e)
{
Page.ClientScript.RegisterStartupScript(GetType(), "id", "toggle_forms('NewSurvey')", true);
if (Page.IsValid)
{
for (int i = 1; i < 11; i++)
{
if (i == 1 && AQuestion1.Value != "")
{
DBHandler.DBHandler db = new DBHandler.DBHandler(con);
Entities.SurveyQuestion s1 = new Entities.SurveyQuestion()
{
surveyId = surveyid,
questionId = i,
question = AQuestion1.Value,
};
db.GenerateSurvey(s1);
}
if (i == 2 && AQuestion2.Value != "")
{
DBHandler.DBHandler db = new DBHandler.DBHandler(con);
Entities.SurveyQuestion s1 = new Entities.SurveyQuestion()
{
surveyId = surveyid,
questionId = i,
question = AQuestion2.Value,
};
db.GenerateSurvey(s1);
}
if (i == 3 && AQuestion3.Value != "")
{
DBHandler.DBHandler db = new DBHandler.DBHandler(con);
Entities.SurveyQuestion s1 = new Entities.SurveyQuestion()
{
surveyId = surveyid,
questionId = i,
question = AQuestion3.Value,
};
db.GenerateSurvey(s1);
}
if (i == 4 && AQuestion4.Value != "")
{
DBHandler.DBHandler db = new DBHandler.DBHandler(con);
Entities.SurveyQuestion s1 = new Entities.SurveyQuestion()
{
surveyId = surveyid,
questionId = i,
question = AQuestion4.Value,
};
db.GenerateSurvey(s1);
}
if (i == 5 && AQuestion5.Value != "")
{
DBHandler.DBHandler db = new DBHandler.DBHandler(con);
Entities.SurveyQuestion s1 = new Entities.SurveyQuestion()
{
surveyId = surveyid,
questionId = i,
question = AQuestion5.Value,
};
db.GenerateSurvey(s1);
}
if (i == 6 && AQuestion6.Value != "")
{
DBHandler.DBHandler db = new DBHandler.DBHandler(con);
Entities.SurveyQuestion s1 = new Entities.SurveyQuestion()
{
surveyId = surveyid,
questionId = i,
question = AQuestion6.Value,
};
db.GenerateSurvey(s1);
}
if (i == 7 && AQuestion7.Value != "")
{
DBHandler.DBHandler db = new DBHandler.DBHandler(con);
Entities.SurveyQuestion s1 = new Entities.SurveyQuestion()
{
surveyId = surveyid,
questionId = i,
question = AQuestion7.Value,
};
db.GenerateSurvey(s1);
}
if (i == 8 && AQuestion8.Value != "")
{
DBHandler.DBHandler db = new DBHandler.DBHandler(con);
Entities.SurveyQuestion s1 = new Entities.SurveyQuestion()
{
surveyId = surveyid,
questionId = i,
question = AQuestion8.Value,
};
db.GenerateSurvey(s1);
}
if (i == 9 && AQuestion9.Value != "")
{
DBHandler.DBHandler db = new DBHandler.DBHandler(con);
Entities.SurveyQuestion s1 = new Entities.SurveyQuestion()
{
surveyId = surveyid,
questionId = i,
question = AQuestion9.Value,
};
db.GenerateSurvey(s1);
}
if (i == 10 && AQuestion10.Value != "")
{
DBHandler.DBHandler db = new DBHandler.DBHandler(con);
Entities.SurveyQuestion s1 = new Entities.SurveyQuestion()
{
surveyId = surveyid,
questionId = i,
question = AQuestion10.Value,
};
db.GenerateSurvey(s1);
}
}
Panel2.Visible = true;
Panel1.Visible = false;
}
}
private DataSet GetScreenInfo(int _ScreenID, string _CompanyIndex)
{
Logger.InfoLog("ControlGenerator:: Inside GetScreenInfo");
try
{
PACT.DBHandler.DBHandler DBH = new DBHandler.DBHandler();
ArrayList AL = new ArrayList();
AL.Add(1);
AL.Add("Majeed");
AL.Add(0);
DataSet ds = DBH.GetAddAccountScreenDetails(1, AL);
return ds;
}
catch (Exception ex)
{
Logger.ErrorLog("ControlGenerator:: GetScreenInfo" + ex.StackTrace.ToString());
return null;
}
}
protected void AssignTeacher(object sender, EventArgs e)
{
DBHandler.DBHandler db = new DBHandler.DBHandler(con);
Entities.Section s3 = new Entities.Section()
{
sectionName = SectionDropDown.SelectedValue,
};
Entities.personalInfo p1 = new Entities.personalInfo()
{
pKId = Session["School"].ToString(),
};
Entities.personalInfo p2 = new Entities.personalInfo()
{
pKId = TeacherDropDown.SelectedValue,
};
Entities.Class c1 = new Entities.Class()
{
className = ClassDropDown.SelectedValue,
};
Entities.Subjects s2 = new Entities.Subjects()
{
subjectName = SubjectDropDown.SelectedValue,
};
db.AssignCourses(s3,p1,p2,c1,s2);
GridView2.DataBind();
UpdatePanel1.Update();
Page.ClientScript.RegisterStartupScript(GetType(), "id", "toggle_forms('AssignCourses')", true);
}
protected void AddExam(object sender, EventArgs e)
{
Page.ClientScript.RegisterStartupScript(GetType(), "id", "toggle_forms('ExamType')", true);
if (Page.IsValid)
{
DBHandler.DBHandler db = new DBHandler.DBHandler(con);
Entities.ExamType e1 = new Entities.ExamType()
{
examTypeId = ExamID.Value,
examType = ExamName.Value,
};
db.AddExamypes(e1);
GridView1.DataBind();
UpdatePanel1.Update();
ExamDate1.UpdateExam();
}
}
protected void GridView2_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "show")
{
int rowindex = ((GridViewRow)((ImageButton)e.CommandSource).NamingContainer).RowIndex;
s = Convert.ToInt32(GridView2.DataKeys[rowindex].Value);
GridViewRow row = (GridViewRow)(((ImageButton)e.CommandSource).NamingContainer);
string check = (row.FindControl("type") as Label).Text.Trim();
DBHandler.DBHandler db = new DBHandler.DBHandler(con);
Entities.SurveyQuestion q1 = new Entities.SurveyQuestion()
{
surveyId=s,
};
DataSet ds = new DataSet();
ds = db.ShowSurvey(q1);
if (ds != null
&& ds.Tables.Count > 0
&& ds.Tables[0].Rows.Count > 0)
{
if (check == "Yes/No")
{
GridView1.DataSource = ds;
GridView1.DataBind();
Page.ClientScript.RegisterStartupScript(GetType(), "id", "ShowSurveyPop()", true);
Panel4.Visible = true;
Panel3.Visible = false;
}
else if (check == "Rating")
{
GridView3.DataSource = ds;
GridView3.DataBind();
Page.ClientScript.RegisterStartupScript(GetType(), "id", "ShowSurveyPop()", true);
Panel4.Visible = false;
Panel3.Visible = true;
}
}
else
{
Page.ClientScript.RegisterStartupScript(GetType(), "id", "toggle_forms('ShowSurvey')", true);
}
}
}
protected void AddSection(object sender, EventArgs e)
{
Page.ClientScript.RegisterStartupScript(GetType(), "id", "toggle_forms('AddSections')", true);
if (Page.IsValid)
{
DBHandler.DBHandler db = new DBHandler.DBHandler(con);
Entities.Section t1 = new Entities.Section()
{
sectionName = SectionName.Value,
};
db.InsertSection(t1);
SSections.DataBind();
GSections.DataBind();
UpdatePanel3.Update();
AddClassSection1.UpdateSection();
TecherSection1.UpdateSection();
StudentSection1.UpdateSection();
ExamDate1.UpdateSection();
SectionLabel.Text = "Section Added Successfully";
}
}
protected void Loginc(object sender, EventArgs e)
{
user = username.Value;
data = user.Split('@')[0];
data2 = user.Split('@')[1];
DBHandler.DBHandler db = new DBHandler.DBHandler(con);
Entities.tblSchoolId t1 = new Entities.tblSchoolId()
{
schoolId = data,
};
Entities.Campus c1 = new Entities.Campus()
{
campusName = data2,
};
DataSet ds = new DataSet();
ds = db.CheckUserType(t1,c1);
if (ds != null
&& ds.Tables.Count > 0
&& ds.Tables[0].Rows.Count > 0)
{
usertype = ds.Tables[0].Rows[0]["userType"].ToString();
passcode = ds.Tables[0].Rows[0]["passCode"].ToString();
session = ds.Tables[0].Rows[0]["pKId"].ToString();
}
else
{
Label1.Text = "Invalid Username or Password";
}
if (usertype == "admin" || usertype=="Admin")
{
if (password.Value == passcode)
{
Session["School"] = session;
Response.Redirect("Admin.aspx");
}
else
{
Label1.Text = "Invalid Username or Password";
}
}
else if (usertype == "teacher" || usertype=="Teacher")
{
if (password.Value == passcode)
{
Session["School"] = session;
Response.Redirect("Teacher.aspx");
}
else
{
Label1.Text = "Invalid Username or Password";
}
}
else if (usertype == "student" || usertype == "Student")
{
if (password.Value == passcode)
{
Session["School"] = session;
Response.Redirect("Students.aspx");
}
else
{
Label1.Text = "Invalid Username or Password";
}
}
}
protected void TicketReply(object sender, EventArgs e)
{
Page.ClientScript.RegisterStartupScript(GetType(), "id", "TicketReplyPop()", true);
if (Page.IsValid)
{
DBHandler.DBHandler db = new DBHandler.DBHandler(con);
Entities.Tickets t1 = new Entities.Tickets()
{
generatedBy = Session["School"].ToString(),
generatedFor = TextBox3.Text,
issueDate = DateTime.Now.ToShortDateString(),
issue = TextBox2.Text,
linkedWith = Convert.ToInt32(TextBox4.Text),
isNew = false,
};
db.AddTicket(t1);
Label1.Text = "Replied Successfully";
}
}
