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(); }