public static List <ClassesModel> LoadClassesForStudent(int id) { string sql = "dbo.pSelClassesByStudentId @StudentId"; int param = id; return(SqlDataAccess_notused.LoadDataStudentClasses <ClassesModel>(sql, param)); }
public static List <StudentModel> LoadStudents() { string sql = @"select StudentFirstName, StudentLastName, StudentEmailAddress from dbo.StudentTable;"; //loading full model //not parameterized return(SqlDataAccess_notused.LoadData <StudentModel>(sql)); }
public static int CreateStudent(string studentEmailAddres, string studentUserName) { //map front end model to data library model StudentModel studentdata = new StudentModel { UserName = studentUserName, Email = studentEmailAddres }; string sql = @"insert into dbo.StudentTable (StudentFirstName, StudentLastName, StudentEmailAddress) values (@StudentFirstName, @StudentLastName, @StudentEmailAddress)"; //return data of type T return(SqlDataAccess_notused.SaveData(sql, studentdata)); }