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 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 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 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 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 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();
}
}
public void AddExamDate(Entities.ExamDate c1, Entities.Subjects s2, Entities.Section s3, Entities.Class c2, Entities.personalInfo p1, Entities.ExamType e1)
{
using (WSqlCommand s1 = new WSqlCommand(dbconstring, "[dbo].[spInsertExamDate]"))
{
s1.AddParameter("@subjectName", System.Data.SqlDbType.NVarChar, s2.subjectName);
s1.AddParameter("@sectionName", System.Data.SqlDbType.NVarChar, s3.sectionName);
s1.AddParameter("@className", System.Data.SqlDbType.NVarChar, c2.className);
s1.AddParameter("@examTypeId", System.Data.SqlDbType.NVarChar, e1.examTypeId);
s1.AddParameter("@iAm", System.Data.SqlDbType.NVarChar, p1.pKId);
s1.AddParameter("@examDate", System.Data.SqlDbType.Date, c1.examDate);
s1.AddParameter("@totalMarks", System.Data.SqlDbType.Int, c1.totalMarks);
s1.Execute();
}
}
public void CoursePlan(Entities.CoursePlan c1, Entities.Subjects s2, Entities.Section s3, Entities.Class c2, Entities.personalInfo p1)
{
using (WSqlCommand s1 = new WSqlCommand(dbconstring, "[dbo].[spInsertCourseProgress]"))
{
s1.AddParameter("@subjectName", System.Data.SqlDbType.NVarChar, s2.subjectName);
s1.AddParameter("@sectionName", System.Data.SqlDbType.NVarChar, s3.sectionName);
s1.AddParameter("@className", System.Data.SqlDbType.NVarChar, c2.className);
s1.AddParameter("@pKId", System.Data.SqlDbType.NVarChar, p1.pKId);
s1.AddParameter("@progressId", System.Data.SqlDbType.Int, c1.progressId);
s1.AddParameter("@year", System.Data.SqlDbType.NVarChar, c1.year);
s1.AddParameter("@goal", System.Data.SqlDbType.NVarChar, c1.Goal);
s1.Execute();
}
}
