private void clientSearchButton_Click(object sender, EventArgs e)
{
string qer = "";
int cnt = 0;
if (nameText2.Text != "")
{
qer += "name like '%" + nameText2.Text + "%' ";
cnt++;
}
if (addText2.Text != "")
{
if (cnt > 0)
{
qer += "and address like '%" + addText2.Text + "%' ";
}
else
{
qer += "address like '%" + addText2.Text + "%' ";
}
cnt++;
}
if (phText2.Text != "")
{
if (cnt > 0)
{
qer += "and phone like '%" + phText2.Text + "%' ";
}
else
{
qer += "phone like '%" + phText2.Text + "%' ";
}
cnt++;
}
connection con = new connection();
if (qer != "")
{
qer = "select id as ID, name as Name, pro as Profession, address as Address, em as Email, ph as Phone, ABpos as AB_pos, ABneg as AB_neg, Apos as A_pos, Aneg as A_neg, Bpos as B_pos, Bneg as B_neg, Opos as O_pos, Oneg as O_neg, pd as Purchase_Date from client_info where " + qer;
DataSet ds = con.Search(qer);
dataGridView1.DataSource = ds.Tables[0];
}
else
{
qer = "select id as ID, name as Name, pro as Profession, address as Address, em as Email, ph as Phone, ABpos as AB_pos, ABneg as AB_neg, Apos as A_pos, Aneg as A_neg, Bpos as B_pos, Bneg as B_neg, Opos as O_pos, Oneg as O_neg, pd as Purchase_Date from client_info";
DataSet ds = con.Search(qer);
dataGridView1.DataSource = ds.Tables[0];
}
nameText2.Text = "";
addText2.Text = "";
phText2.Text = "";
}
private void storageSearchButton_Click(object sender, EventArgs e)
{
string qer = "";
int cnt = 0;
if (bgCombo2.Text != "")
{
qer += "bg = '" + bgCombo2.Text + "' ";
cnt++;
}
if (slText.Text != "")
{
if (cnt > 0)
{
qer += "and sl like '%" + slText.Text + "%' ";
}
else
{
qer += "sl like '%" + slText.Text + "%' ";
}
cnt++;
}
connection con = new connection();
if (qer != "")
{
qer = "select id as ID, bg as Blood_Group, roomNo as Room_No, sl as Serial_No, dd as Donation_Date from storage_info where " + qer;
DataSet ds = con.Search(qer);
dataGridView1.DataSource = ds.Tables[0];
}
else
{
qer = "select id as ID, bg as Blood_Group, roomNo as Room_No, sl as Serial_No, dd as Donation_Date from storage_info";
DataSet ds = con.Search(qer);
dataGridView1.DataSource = ds.Tables[0];
}
bgCombo2.Text = "";
slText.Text = "";
}
private void donorSearchButton_Click(object sender, EventArgs e)
{
string qer = "";
int cnt = 0;
if (nameText1.Text != "")
{
qer += "name like '%" + nameText1.Text + "%' ";
cnt++;
}
if (addText1.Text != "")
{
if (cnt > 0)
{
qer += "and addr like '%" + addText1.Text + "%' ";
}
else
{
qer += "addr like '%" + addText1.Text + "%' ";
}
cnt++;
}
if (phText1.Text != "")
{
if (cnt > 0)
{
qer += "and phone like '%" + phText1.Text + "%' ";
}
else
{
qer += "phone like '%" + phText1.Text + "%' ";
}
cnt++;
}
if (bgCombo1.Text != "")
{
if (cnt > 0)
{
qer += "and bg = '" + bgCombo1.Text + "'";
}
else
{
qer += "bg = '" + bgCombo1.Text + "'";
}
cnt++;
}
connection con = new connection();
if (qer != "")
{
qer = "select id as ID, name as Name, pro as Profession, dob as Date_of_Birth,addr as Address, email as Email, phone as Phone, bg as Blood_Group, dod as Date_of_Donation from donor_info where " + qer;
DataSet ds = con.Search(qer);
dataGridView1.DataSource = ds.Tables[0];
}
else
{
qer = "select id as ID, name as Name, pro as Profession, dob as Date_of_Birth,addr as Address, email as Email, phone as Phone, bg as Blood_Group, dod as Date_of_Donation from donor_info";
DataSet ds = con.Search(qer);
dataGridView1.DataSource = ds.Tables[0];
}
nameText1.Text = "";
addText1.Text = "";
phText1.Text = "";
bgCombo1.Text = "";
}