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.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();
ada.showd();
}
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 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");
}
}
partial void DeleteDonorInfo(DonorInfo instance);
partial void UpdateDonorInfo(DonorInfo instance);
partial void InsertDonorInfo(DonorInfo instance);
