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