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"); GuestInfo pr = new GuestInfo(); if (textBox1.Text != "" && textBox2.Text != "" && textBox3.Text != "" && textBox4.Text != "") { pr.GName = textBox2.Text; pr.GPhone = textBox3.Text; pr.GAddress = textBox4.Text; D.GuestInfos.InsertOnSubmit(pr); D.SubmitChanges(); RequestInfo rq = new RequestInfo(); rq.DonorId = Convert.ToInt32(textBox1.Text); rq.Gphone = textBox3.Text; var x = from a in D.GuestInfos where a.GPhone.Equals(textBox3.Text) select a; int str = x.First().Gid; rq.Gid = str; D.RequestInfos.InsertOnSubmit(rq); MessageBox.Show("Request Send"); this.Hide(); D.SubmitChanges(); } else { MessageBox.Show("Please fill up all information"); } }
private void metroButton4_Click(object sender, EventArgs e) ///send request donor to donor { BloodDataContext D = new BloodDataContext(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=G:\Blood\Blood Donation\Blood.mdf;Integrated Security=True;Connect Timeout=30"); int rowIndex = metroGrid2.CurrentCell.RowIndex; int did = Convert.ToInt32(metroGrid2.Rows[rowIndex].Cells[0].Value); R rq = new R(); rq.DonorId = did; rq.Did = m; rq.Phone = metroLabel11.Text; rq.Identity = "Donor"; D.Rs.InsertOnSubmit(rq); D.SubmitChanges(); allrequest req = new allrequest(); req.Donorid = did; req.Name = metroLabel4.Text; req.Phone = metroLabel11.Text; req.Address = metroLabel9.Text; req.identity = "Donor"; var p = from a in D.Rs where a.Did.Equals(m) select a; int stra = p.First().Rid; req.Rid = stra; req.identity = "Donor"; D.allrequests.InsertOnSubmit(req); D.SubmitChanges(); //var x = from a in D.RequestInfos // where a.Gid == did // select a; //x.First().Status = "Donated"; //var y = from a in D.DonorInfos // where a.DonorId == m // select a; //y.First().Status = "Donated"; //D.RequestInfos.InsertOnSubmit(rq); MessageBox.Show("Request Send"); D.SubmitChanges(); }
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"); //RequestInfo j = D.RequestInfos.SingleOrDefault(x => x.DonorId == Convert.ToInt32(textBox1.Text)); var y = from a in D.RequestInfos where a.Gid == Convert.ToInt32(textBox1.Text) select a; if (y.Any()) { foreach (var a in y) { D.RequestInfos.DeleteOnSubmit(a); } GuestInfo i = D.GuestInfos.SingleOrDefault(t => t.Gid == Convert.ToInt32(textBox1.Text)); D.GuestInfos.DeleteOnSubmit(i); D.SubmitChanges(); s.showde(); } else { MessageBox.Show("Guest Id Invalid"); } }
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"); AdminInfo pr = new AdminInfo(); if (textBox1.Text != "" && textBox2.Text != "" && textBox3.Text != "" && textBox4.Text != "") { pr.Password = textBox4.Text; pr.Name = textBox2.Text; pr.Phone = textBox1.Text; pr.Username = textBox3.Text; D.AdminInfos.InsertOnSubmit(pr); D.SubmitChanges(); MessageBox.Show("New Admin Added"); a.Show(); this.Hide(); } else { MessageBox.Show("Fill up all information"); } }
private void metroButton6_Click(object sender, EventArgs e) { BloodDataContext D = new BloodDataContext(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=G:\Blood\Blood Donation\Blood.mdf;Integrated Security=True;Connect Timeout=30"); int rowIndex = metroGrid3.CurrentCell.RowIndex; int did = Convert.ToInt32(metroGrid3.Rows[rowIndex].Cells[0].Value); MessageBox.Show(Convert.ToString(did)); var z = from a in D.RequestInfos where a.Gid == did select a; int sam = z.First().RequestId; foreach (var a in z) { D.RequestInfos.DeleteOnSubmit(a); } D.SubmitChanges(); var y = from b in D.GuestInfos where b.Gid == did select b; foreach (var b in y) { D.GuestInfos.DeleteOnSubmit(b); } var n = from b in D.allrequests where b.requestid.Equals(sam) select b; foreach (var b in n) { D.allrequests.DeleteOnSubmit(b); } metroGrid3.Rows.RemoveAt(rowIndex); D.SubmitChanges(); metroGrid3.Update(); show(); }
private void metroButton12_Click(object sender, EventArgs e) { BloodDataContext D = new BloodDataContext(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=G:\Blood\Blood Donation\Blood.mdf;Integrated Security=True;Connect Timeout=30"); int rowIndex = metroGrid2.CurrentCell.RowIndex; int did = Convert.ToInt32(metroGrid2.Rows[rowIndex].Cells[0].Value); var y = from a in D.DonorInfos where a.DonorId == did select a; foreach (var a in y) { D.DonorInfos.DeleteOnSubmit(a); } D.SubmitChanges(); MessageBox.Show(Convert.ToString(did)); var z = from a in D.RequestInfos where a.DonorId == did select a; foreach (var a in z) { D.RequestInfos.DeleteOnSubmit(a); } D.SubmitChanges(); metroGrid2.Rows.RemoveAt(rowIndex); //int x=metroGrid2. //BloodDataContext D = new BloodDataContext(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=G:\finalProject\Blood Donation\Blood.mdf;Integrated Security=True;Connect Timeout=30"); //var y = from a in D.RequestInfos // where a.DonorId == Convert.ToInt32(textBox1.Text) // select a; //foreach (var a in y) //{ // D.RequestInfos.DeleteOnSubmit(a); //} //DonorInfo i = D.DonorInfos.SingleOrDefault(t => t.DonorId == Convert.ToInt32(textBox1.Text)); //D.DonorInfos.DeleteOnSubmit(i); //D.SubmitChanges(); }
private void metroButton2_Click(object sender, EventArgs e) { BloodDataContext D = new BloodDataContext(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=G:\Blood\Blood Donation\Blood.mdf;Integrated Security=True;Connect Timeout=30"); var x = from a in D.DonorInfos where a.DonorId.Equals(Adminid) select a; if (metroTextBox1.Text != "") { metroLabel10.Text = metroTextBox1.Text; x.First().DName = Convert.ToString(metroTextBox1.Text); metroTextBox1.Text = ""; } if (metroTextBox3.Text != "") { string st = metroTextBox3.Text; if (st[0] == '$') { x.First().UserID = metroTextBox3.Text; metroLabel13.Text = metroTextBox3.Text; metroTextBox3.Text = ""; } else { MessageBox.Show("Update user name with $"); } } if (metroTextBox4.Text != "") { x.First().Password = metroTextBox4.Text; metroLabel17.Text = metroTextBox4.Text; metroTextBox4.Text = ""; } if (metroTextBox2.Text != "") { x.First().DPhone = metroTextBox2.Text; metroLabel11.Text = metroTextBox2.Text; metroTextBox2.Text = ""; } if (metroTextBox9.Text != "") { x.First().DAddress = metroTextBox9.Text; metroLabel26.Text = metroTextBox9.Text; metroTextBox9.Text = ""; } D.SubmitChanges(); MessageBox.Show("Successfully Update"); show(); }
private void metroButton8_Click(object sender, EventArgs e) { BloodDataContext D = new BloodDataContext(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=G:\Blood\Blood Donation\Blood.mdf;Integrated Security=True;Connect Timeout=30"); var x = from a in D.DonorInfos where a.DonorId.Equals(Adminid) select a; x.First().Status = null; metroLabel20.Text = ""; D.SubmitChanges(); }
private void Requests_Load(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 join b in D.GuestInfos on a.Gid equals b.Gid where (a.DonorId == s && a.Status.Equals(null)) select new { a.GuestInfo.GName, a.GuestInfo.GPhone, a.GuestInfo.GAddress, a.GuestInfo.Gid }).ToList(); dataGridView1.DataSource = x; D.SubmitChanges(); }
private void button4_Click(object sender, EventArgs e) { BloodDataContext D = new BloodDataContext(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=C:\Users\MD. REZA UL KARIM\Documents\finalProject\Blood Donation\Blood.mdf;Integrated Security=True;Connect Timeout=30"); var x = from a in D.DonorInfos where a.Password.Equals(id) select a; x.First().Status = null; label13.Text = ""; D.SubmitChanges(); show(); }
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 metroButton1_Click(object sender, EventArgs e) { BloodDataContext D = new BloodDataContext(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=G:\Blood\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 == m select a; if (metroTextBox1.Text != "") { x.First().DName = metroTextBox1.Text; metroLabel14.Text = metroTextBox1.Text; metroTextBox1.Text = ""; } if (metroTextBox2.Text != "") { x.First().DAddress = metroTextBox2.Text; metroLabel19.Text = metroTextBox2.Text; metroTextBox2.Text = ""; } if (metroTextBox4.Text != "") { x.First().Password = metroTextBox4.Text; metroLabel2.Text = metroTextBox4.Text; metroTextBox4.Text = ""; } if (metroTextBox3.Text != "") { x.First().DPhone = metroTextBox3.Text; metroLabel11.Text = metroTextBox3.Text; metroTextBox3.Text = ""; } D.SubmitChanges(); MessageBox.Show("Successfully Update"); }
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(); }
private void Donor_Load(object sender, EventArgs e) { BloodDataContext D = new BloodDataContext(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=G:\Blood\Blood Donation\Blood.mdf;Integrated Security=True;Connect Timeout=30"); var x = from a in D.DonorInfos where id == a.Password select a; metroLabel4.Text = x.First().DName; metroLabel5.Text = Convert.ToString(x.First().DonorId); metroLabel7.Text = x.First().BloodGroup; metroLabel9.Text = x.First().DAddress; metroLabel11.Text = x.First().DPhone; this.m = Convert.ToInt32(x.First().DonorId); metroLabel2.Text = x.First().Password; metroLabel15.Text = x.First().UserID; metroLabel13.Text = x.First().Status; dshow(); D.SubmitChanges(); }
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.AdminInfos where a.AdminId.Equals(s) select a; string st = textBox1.Text; if (st[0] == '$') { if (donornam.Text != "") { //var a = x.First().Name; // donornam.Text =x.First().Name; x.First().Name = donornam.Text; } if (textBox1.Text != "") { x.First().Username = textBox1.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"); ad.Show(); ad.show(); this.Hide(); } else if (s.Equals(null)) { if (donornam.Text != "") { //var a = x.First().Name; // donornam.Text =x.First().Name; x.First().Name = donornam.Text; } if (pass.Text != "") { x.First().Password = pass.Text; } if (ph.Text != "") { x.First().Phone = ph.Text; } D.SubmitChanges(); MessageBox.Show("Successfully Update"); ad.Show(); ad.show(); this.Hide(); } else { MessageBox.Show("Update user name with $"); } }
private void Confirm_Click(object sender, EventArgs e) { BloodDataContext D = new BloodDataContext(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=G:\Blood\Blood Donation\Blood.mdf;Integrated Security=True;Connect Timeout=30"); string a = Passwordbox.Text; string b = Confirmpasswordbox.Text; DonorInfo pr = new DonorInfo(); try { if (Namebox.Text != "" && Ad.Text != "" && Passwordbox.Text != "" && Confirmpasswordbox.Text != "" && textBox1.Text != "" && BloodGroup.Text != "" && PhoneNo.Text != "") { if (a == b) { pr.Password = Passwordbox.Text; pr.DName = Namebox.Text; pr.DAddress = Ad.Text; pr.DPhone = Ph.Text; pr.UserID = textBox1.Text; pr.BloodGroup = bgroup.Text; pr.identity = "Donor"; D.DonorInfos.InsertOnSubmit(pr); D.SubmitChanges(); MessageBox.Show("Congratulation as Member in our Family"); Start l = new Start(); l.Show(); this.Hide(); } else { MessageBox.Show("Password not match"); } } else { if (Namebox.Text == "") { Namebox.BackColor = Color.Red; } else { Namebox.BackColor = Color.White; } if (Passwordbox.Text == "") { Passwordbox.BackColor = Color.Red; } else { Passwordbox.BackColor = Color.White; } if (bgroup.Text == "") { bgroup.BackColor = Color.Red; } else { bgroup.BackColor = Color.White; } if (Ad.Text == "") { Ad.BackColor = Color.Red; } else { Ad.BackColor = Color.White; } if (Confirmpasswordbox.Text == "") { Confirmpasswordbox.BackColor = Color.Red; } else { Confirmpasswordbox.BackColor = Color.White; } if (PhoneNo.Text == "") { PhoneNo.BackColor = Color.Red; } else { PhoneNo.BackColor = Color.White; } if (textBox1.Text == "") { textBox1.BackColor = Color.Red; } else { textBox1.BackColor = Color.White; } MessageBox.Show("Please fillup markable box"); } } catch (Exception) { MessageBox.Show("Please fillup all information"); } }
private void metroButton7_Click(object sender, EventArgs e) { BloodDataContext D = new BloodDataContext(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=G:\Blood\Blood Donation\Blood.mdf;Integrated Security=True;Connect Timeout=30"); if (metroLabel20.Text.Equals("")) { int rowIndex = metroGrid5.CurrentCell.RowIndex; string did = Convert.ToString(metroGrid5.Rows[rowIndex].Cells[1].Value); string am = Convert.ToString(metroGrid5.Rows[rowIndex].Cells[3].Value); int id = Convert.ToInt32(metroGrid5.Rows[rowIndex].Cells[0].Value); if (did == "Guest") { MessageBox.Show(am); var x = from a in D.RequestInfos where a.Gphone == am select a; x.First().Status = "Donated"; //MessageBox.Show("no"); var z = from a in D.allrequests join b in D.RequestInfos on a.requestid equals b.RequestId select a; z.First().Status = "Donated"; MessageBox.Show("no"); var y = from a in D.DonorInfos where a.DonorId == Adminid select a; y.First().Status = "Donated"; MessageBox.Show("Confirm Request"); metroLabel20.Text = "Donated"; D.SubmitChanges(); } else { var x = from a in D.Rs where a.Phone == am select a; x.First().Status = "Donated"; var z = from a in D.allrequests join b in D.Rs on a.Rid equals b.Rid where (a.reqid == id) select a; z.First().Status = "Donated"; D.SubmitChanges(); var y = from a in D.DonorInfos where a.DonorId == Adminid select a; y.First().Status = "Donated"; MessageBox.Show("Confirm Request"); metroLabel20.Text = "Donated"; D.SubmitChanges(); } show(); } else { MessageBox.Show("Already Donated"); } }
private void metroButton3_Click(object sender, EventArgs e) { BloodDataContext D = new BloodDataContext(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=G:\Blood\Blood Donation\Blood.mdf;Integrated Security=True;Connect Timeout=30"); string a = metroTextBox8.Text; DonorInfo pr = new DonorInfo(); try { if (metroTextBox5.Text != "" && metroTextBox10.Text != "" && metroTextBox8.Text != "" && metroTextBox7.Text != "" && metroComboBox1.Text != "" && metroTextBox6.Text != "" && metroComboBox2.Text != "") { if (metroComboBox2.Text.Equals("Admin")) { if (metroTextBox7.Text[0].Equals("$")) { pr.Password = metroTextBox8.Text; pr.DName = metroTextBox5.Text; pr.DAddress = metroTextBox10.Text; pr.DPhone = metroTextBox6.Text; pr.identity = metroComboBox2.Text; pr.UserID = metroTextBox7.Text; pr.BloodGroup = metroComboBox1.Text; D.DonorInfos.InsertOnSubmit(pr); D.SubmitChanges(); MessageBox.Show("Congratulation as Member in our Family"); Start l = new Start(); l.Show(); this.Hide(); } else { MessageBox.Show("Username start with $"); } } else if (metroComboBox2.Text.Equals("Donor")) { if (metroTextBox7.Text[0] != '$') { pr.Password = metroTextBox8.Text; pr.DName = metroTextBox5.Text; pr.DAddress = metroTextBox10.Text; pr.DPhone = metroTextBox6.Text; pr.identity = metroComboBox2.Text; pr.UserID = metroTextBox7.Text; pr.BloodGroup = metroComboBox1.Text; D.DonorInfos.InsertOnSubmit(pr); D.SubmitChanges(); MessageBox.Show("Congratulation as Member in our Family"); Start l = new Start(); l.Show(); this.Hide(); } else { MessageBox.Show("Username start without $"); } } } else { if (metroTextBox5.Text == "") { metroTextBox5.BackColor = Color.Red; } else { metroTextBox5.BackColor = Color.White; } if (metroTextBox8.Text == "") { metroTextBox8.BackColor = Color.Red; } else { metroTextBox8.BackColor = Color.White; } if (metroComboBox1.Text == "") { metroComboBox1.BackColor = Color.Red; } else { metroComboBox1.BackColor = Color.White; } if (metroTextBox10.Text == "") { metroTextBox10.BackColor = Color.Red; } else { metroTextBox10.BackColor = Color.White; } if (metroTextBox6.Text == "") { metroTextBox6.BackColor = Color.Red; } else { metroTextBox6.BackColor = Color.White; } if (metroTextBox7.Text == "") { metroTextBox7.BackColor = Color.Red; } else { metroTextBox7.BackColor = Color.White; } MessageBox.Show("Please fillup Text box"); } } catch (Exception) { MessageBox.Show("Please fillup all information"); } }