public static void Insert(StudentToAdd student)
{
BandStudentDBEntities db = new BandStudentDBEntities();
System.Data.Entity.Core.Objects.ObjectParameter OutputID = new System.Data.Entity.Core.Objects.ObjectParameter("OutputID", typeof(int?));
int StudentIdFromDB = db.InsertStudentData(student.StudentFirstName, student.StudentLastName, student.StudentAddress, student.StudentCity, student.StudentState, student.StudentZipCode, student.StudentPhone, student.PerformanceMedium, student.GraduationYear, student.EmailAddress, OutputID);
StudentIdFromDB = Convert.ToInt32(OutputID.Value);
db.SaveChanges();
db.CreateUpdate_InterestAreas(StudentIdFromDB, student.InterestAreas.BM_Music_Education_Vocal, student.InterestAreas.BM_Music_Education_Instrumental,
student.InterestAreas.BM_Music_Performance_Vocal, student.InterestAreas.BM_Music_Performance_Instrumental,
student.InterestAreas.BM_Music_Elective_Studies_Business, student.InterestAreas.BM_Music_Elective_Studies_Outside_Fields,
student.InterestAreas.MM_Performance_Piano, student.InterestAreas.MM_Performance_Vocal, student.InterestAreas.MM_Collaborative_Piano,
student.InterestAreas.Music_Minor, student.InterestAreas.Instrumental_Ensembles, student.InterestAreas.Choral_Ensembles,
student.InterestAreas.Opera_Theatre, student.InterestAreas.Jaguar_Marching_Band, student.InterestAreas.Other, student.InterestAreas.MM_Concentration_in_Music_Education);
db.SaveChanges();
}
public static List<string> GetColumns(string tableName)
{
BandStudentDBEntities db = new BandStudentDBEntities();
return db.TableColumnNames(tableName).ToList();
}
public ActionResult EditUserInfo(User user)
{
var db = new BandStudentDBEntities();
if (ModelState.IsValid)
{
db.UpdateUserRecord(user.UserID, user.UserName, user.UserFirstName, user.UserLastName, user.Active);
db.SaveChanges();
}
return RedirectToAction("Index");
}
