static bool createStudent(Student student)
{
//Adds student to db
using (var contxt = new SchoolDBEntities())
{
contxt.Students.Add(student);
contxt.SaveChanges();
}
return true;
}
static bool createTeacher(Teacher teach)
{
//Add teacher to db
using (var contxt = new SchoolDBEntities())
{
contxt.Teachers.Add(teach);
contxt.SaveChanges();
}
return true;
}
static bool createStandard(Standard stndrd)
{
//Add standard to db
using (var contxt = new SchoolDBEntities())
{
contxt.Standards.Add(stndrd);
contxt.SaveChanges();
}
return true;
}
static bool deleteStudentAddr(String studentName)
{
//Removes a particular students address
Student toDel;
var contxt = new SchoolDBEntities();
toDel = contxt.Students.Where(st => st.StudentName == studentName).FirstOrDefault<Student>();
contxt.Entry(toDel.StudentAddress).State = System.Data.Entity.EntityState.Deleted;
contxt.SaveChanges();
return true;
}
static bool updateTeachIDDisconnect(Teacher toChange, Teacher changeTo)
{
//Change standard description based on what is passed in
//Disconnected mode
Teacher toUpdate;
Teacher change;
using (var contxt = new SchoolDBEntities())
{
toUpdate = contxt.Teachers.Where(st => st.TeacherName == toChange.TeacherName).FirstOrDefault<Teacher>();
change = contxt.Teachers.Where(st => st.TeacherName == changeTo.TeacherName).FirstOrDefault<Teacher>();
}
if (toUpdate != null && change != null)
{
toUpdate.StandardId = change.StandardId;
}
else
{
return false;
}
using (var contxt1 = new SchoolDBEntities())
{
contxt1.Entry(toUpdate).State = System.Data.Entity.EntityState.Modified;
contxt1.SaveChanges();
}
return true;
}
static bool updateTeachID(Teacher toChange, Teacher changeTo)
{
//Change standard description based on what is passed in
var contxt = new SchoolDBEntities();
Teacher toUpdate;
Teacher change;
toUpdate = contxt.Teachers.Where(st => st.TeacherName== toChange.TeacherName).FirstOrDefault<Teacher>();
change = contxt.Teachers.Where(st => st.TeacherName == changeTo.TeacherName).FirstOrDefault<Teacher>();
if (toUpdate != null)
{
toUpdate.StandardId = change.StandardId;
}
else
{
return false;
}
contxt.Entry(toUpdate).State = System.Data.Entity.EntityState.Modified;
contxt.SaveChanges();
return true;
}
static bool updateStudentDisconnect(String studentName, String newAddr)
{
Student toUpdate;
//Update student address in disconnected mode
using (var contxt = new SchoolDBEntities())
{
toUpdate = contxt.Students.Where(st => st.StudentName == studentName).FirstOrDefault<Student>();
}
if (toUpdate != null)
{
toUpdate.StudentAddress.Address1 = newAddr;
}
else
{
return false;
}
using (var contxt1 = new SchoolDBEntities())
{
contxt1.Entry(toUpdate).State = System.Data.Entity.EntityState.Modified;
contxt1.SaveChanges();
}
return true;
}
static bool updateStudent(String studentName, String newAddr)
{
//Updates a student based on whats passed in to the function
var contxt = new SchoolDBEntities();
Student toUpdate;
toUpdate = contxt.Students.Where(st => st.StudentName == studentName).FirstOrDefault<Student>();
if(toUpdate != null)
{
toUpdate.StudentAddress.Address1 = newAddr;
}
else
{
return false;
}
contxt.Entry(toUpdate).State = System.Data.Entity.EntityState.Modified;
contxt.SaveChanges();
return true;
}
static bool updateStandard(String standardName, String newDescription)
{
//Change standard description based on what is passed in
var contxt = new SchoolDBEntities();
Standard toUpdate;
toUpdate = contxt.Standards.Where(st => st.StandardName == standardName).FirstOrDefault<Standard>();
if (toUpdate != null)
{
toUpdate.Description = newDescription;
}
else
{
return false;
}
contxt.Entry(toUpdate).State = System.Data.Entity.EntityState.Modified;
contxt.SaveChanges();
return true;
}
static String readTeachers(String teacherName, int byName)
{
var contxt = new SchoolDBEntities();
string teachers = "";
//Return all teachers in db
if (teacherName.Trim().Equals("*"))
{
var retTeach = from tch in contxt.Teachers
select tch;
foreach (Teacher teacher in retTeach)
{
if (teacher.TeacherName != null && teacher.TeacherName != null)
{
teachers += "\n\n\nName : " + teacher.TeacherName
+ "\nDescription: " + teacher.Standard.Description
+"\nID: " + teacher.Standard.StandardId;
}
else
{
teachers += null;
}
}
}
//Explicit teacher name
else
{
var retTeacher = contxt.Teachers.Where(tch => tch.TeacherName == teacherName).FirstOrDefault<Teacher>();
if (retTeacher.TeacherName != null && retTeacher.TeacherName != null)
{
teachers += "\n\n\nName : " + retTeacher.TeacherName
+ "\nDescription: " + retTeacher.Standard.Description
+ "\nID: " + retTeacher.Standard.StandardId;
}
else
{
teachers += null;
}
}
return teachers;
}
static String readStudents(String studentName)
{
var contxt = new SchoolDBEntities();
string students = "";
//Return all students in db
if (studentName.Trim().Equals("*"))
{
var retStudent = from st in contxt.Students
select st;
foreach (Student student in retStudent)
{
if (student.StudentName != null && student.StudentAddress != null && student.StudentAddress.Address1 != null && student.StudentAddress.Address2 != null)
{
students += "\n\n\nName : " + student.StudentName
+ "\nAddress 1: " + student.StudentAddress.Address1
+ "\nAddress 2: " + student.StudentAddress.Address2
+ "\n " + student.StudentAddress.City + " " + student.StudentAddress.State;
}
else
{
students += "\n\n\nName : " + student.StudentName
+ "\nAddress 1: null"
+ "\nAddress 2: null";
}
}
}
else
{
var retStudent = contxt.Students.Where(st => st.StudentName == studentName).FirstOrDefault<Student>();
if (retStudent.StudentName != null && retStudent.StudentAddress != null && retStudent.StudentAddress.Address1 != null && retStudent.StudentAddress.Address2 != null)
{
students += "\n\n\nName : " + retStudent.StudentName
+ "\nAddress 1: " + retStudent.StudentAddress.Address1
+ "\nAddress 2: " + retStudent.StudentAddress.Address2
+ "\n " + retStudent.StudentAddress.City + " " + retStudent.StudentAddress.State;
}
else
{
students += "\n\n\nName : " + retStudent.StudentName
+ "\nAddress 1: null"
+ "\nAddress 2: null";
}
}
return students;
}
static String readStandards(String standardName)
{
var contxt = new SchoolDBEntities();
string standards = "";
//Return all standards in db
if (standardName.Trim().Equals("*"))
{
var retStandards = from st in contxt.Standards
select st;
foreach (Standard standard in retStandards)
{
if (standard.Description != null && standard.StandardName != null )
{
standards += "\n\n\nName : " + standard.StandardName
+ "\nDescription: " + standard.Description;
}
else
{
standards += null;
}
}
}
else
{
var retStandard = contxt.Standards.Where(st => st.StandardName == standardName).FirstOrDefault<Standard>();
if (retStandard.Description != null && retStandard.StandardName != null)
{
standards += "\n\n\nName : " + retStandard.StandardName
+ "\nDescription: " + retStandard.Description;
}
else
{
standards += null;
}
}
return standards;
}