public static void Insert(Student_Registration_Form studentToAdd)
//used by that add student form to add a new record to the db
{
var db = new DataClassesDataContext();
db.Student_Registration_Forms.InsertOnSubmit(studentToAdd);
db.SubmitChanges();
}
protected void AddStudent_Click(object sender, EventArgs e)
{
// Create a new student object
var student = new Student_Registration_Form
{
//instantiate values
Fname = FirstName.Text,
Lname = LastName.Text,
Gender = ddlGender.SelectedValue,
DOB = Convert.ToDateTime(txtDOB.Text),
Address1 = Address.Text,
Accomodition_Type = ddlAccomodationType.SelectedValue,
Phone = LandLine.Text,
Mobile = Mobile.Text,
Email = Email.Text,
Marital_Status = ddlStatus.SelectedValue,
Contact = ddlContact.SelectedValue,
Main_Ethnicity = ddlRace.SelectedValue,
Faculty = ddlFaculty.SelectedValue,
Courses = ddlCourse.SelectedValue,
Detailed_Ethnicity = DetailedEnthicity.Text,
campus = ddlCampus.SelectedValue
};
try
{
// Submit the data to database via students object
Students.Insert(student);
}
catch (Exception ff)
{
ErrorMessage.Text = ff.ToString();
}
}
partial void DeleteStudent_Registration_Form(Student_Registration_Form instance);
partial void UpdateStudent_Registration_Form(Student_Registration_Form instance);
partial void InsertStudent_Registration_Form(Student_Registration_Form instance);
public static void Delete(Student_Registration_Form studentToDelete)
{
var db = new DataClassesDataContext();
db.Student_Registration_Forms.Attach(studentToDelete);
db.SubmitChanges();
}
public static void Update(Student_Registration_Form oldStudent, Student_Registration_Form newStudent)
{
var db = new DataClassesDataContext();
db.Student_Registration_Forms.Attach(newStudent, oldStudent);
db.SubmitChanges();
}
