public IQueryable<volunteer> getVolunteers()
{
//create instance of LINQ object
volunteerclassDataContext objVolunteerDC = new volunteerclassDataContext();
var allVolunteers = objVolunteerDC.volunteers.Select(x => x);
return allVolunteers;
}
public IQueryable<volunteer> getVolunteerByID(int _id)
{
volunteerclassDataContext objVolunteerDC = new volunteerclassDataContext();
var allVolunteers = objVolunteerDC.volunteers.Where(x => x.vol_Id == _id).Select(x => x);
return allVolunteers;
}
public bool commitDelete(int _id)
{
volunteerclassDataContext objVolunteerDC = new volunteerclassDataContext();
using (objVolunteerDC)
{
var objDelVolunteer = objVolunteerDC.volunteers.Single(x => x.vol_Id == _id);
objVolunteerDC.volunteers.DeleteOnSubmit(objDelVolunteer);
objVolunteerDC.SubmitChanges();
return true;
}
}
//commitUpdate to update the data
public bool commitUpdate(int _id, string _fname, string _lname, string _email, string _phone)
{
volunteerclassDataContext objVolunteerDC = new volunteerclassDataContext();
using (objVolunteerDC)
{
var objUpVolunteer = objVolunteerDC.volunteers.Single(x => x.vol_Id == _id);
objUpVolunteer.firstname = _fname;
objUpVolunteer.lastname = _lname;
//objUpVolunteer.age = _age;
//objUpVolunteer.gender = _gender;
//objUpVolunteer.school_name = _schoolname;
//objUpVolunteer.volunteer_type = _voltype;
objUpVolunteer.email = _email;
objUpVolunteer.phone = _phone;
objVolunteerDC.SubmitChanges();
return true;
}
}
//CommitInsert to save the data to the database
public bool commitInsert(string _fname, string _lname, int _age, string _gender, string _schoolname, string _voltype, string _email, string _phone)
{
volunteerclassDataContext objVolunteerDC = new volunteerclassDataContext();
using (objVolunteerDC)
{
//create an instance of the table
volunteer objNewVolunteer = new volunteer();
objNewVolunteer.firstname = _fname;
objNewVolunteer.lastname = _lname;
objNewVolunteer.age = _age;
objNewVolunteer.gender = _gender;
objNewVolunteer.school_name = _schoolname;
objNewVolunteer.volunteer_type = _voltype;
objNewVolunteer.email = _email;
objNewVolunteer.phone = _phone;
//objNewVolunteer.vol_Id = _id;
objVolunteerDC.volunteers.InsertOnSubmit(objNewVolunteer);
objVolunteerDC.SubmitChanges();
return true;
}
}
protected void subVolunteer(object sender, CommandEventArgs e)
{
volunteerclassDataContext objVolunteerDC = new volunteerclassDataContext();
//create instance of volunteer table
volunteer objNewVolunteer = new volunteer();
objNewVolunteer.firstname = txtfname.Text;
objNewVolunteer.lastname = txtlname.Text;
objNewVolunteer.age = int.Parse(txtage.Text.ToString());
objNewVolunteer.gender = rdb_gender.Text;
objNewVolunteer.school_name = txtschool.Text;
objNewVolunteer.volunteer_type = ddl_voltype.SelectedItem.Text;
objNewVolunteer.email = txtemail.Text;
objNewVolunteer.phone = txtcontact.Text;
objNewVolunteer.filename = file_up.FileName.ToString();
objNewVolunteer.filedata = file_up.FileContent.ToString();
objNewVolunteer.filetype = file_up.FileBytes.ToString();
objVolunteerDC.volunteers.InsertOnSubmit(objNewVolunteer);
objVolunteerDC.SubmitChanges();
//after submitting form clears all fields
txtfname.Text = "";
txtlname.Text = "";
txtemail.Text = "";
txtage.Text = "";
txtschool.Text = "";
txtcontact.Text = "";
ddl_voltype.Text = "";
rdb_gender.Text = "";
lbl_msgV.Text = "Your volunteer application was submitted successfully!";
_subRebind();
}
