private void button2_Click(object sender, EventArgs e) { BloodDataContext D = new BloodDataContext(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=F:\C# projects\finalProject\Blood Donation\Blood.mdf;Integrated Security=True;Connect Timeout=30"); //Information info = new Information(); //Donor_Info pr = new Donor_Info //{ // Name = Convert.ToString(donornam.Text), // Address = add.Text, // Password = pass.Text, // Phone = Convert.ToInt32(ph.Text), //}; var x = from a in D.DonorInfos where a.DonorId == d select a; if (donornam.Text != "") { // var a = x.First().Name; //donornam.Text = a; x.First().Name = donornam.Text; } if (add.Text != "") { x.First().Address = add.Text; } if (pass.Text != "") { x.First().Password = pass.Text; } if (ph.Text != "") { x.First().Phone = ph.Text; } //D.Donor_Infos.InsertOnSubmit(pr); D.SubmitChanges(); MessageBox.Show("Successfully Update"); //Donor c = new Donor(); donor.Show(); donor.show(); this.Hide(); }
private void button1_Click(object sender, EventArgs e) { BloodDataContext D = new BloodDataContext(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=F:\C# projects\finalProject\Blood Donation\Blood.mdf;Integrated Security=True;Connect Timeout=30"); var x = from a in D.RequestInfos where a.Gid == Convert.ToInt32(textBox1.Text) select a; x.First().Status = "Donated"; var y = from a in D.DonorInfos where a.DonorId == Dono select a; y.First().Status = "Donated"; MessageBox.Show("Confirm Request"); D.SubmitChanges(); this.Hide(); don.show(); }