public void setgrid()
{
int a;
string s = DHome.dd.Rows[0]["Id"].ToString();
bool result = Int32.TryParse(s, out a);
string st = "select Pname , Padd , Hospital from Requests where Id = " + a + ";";
doct = db.Data(st);
if (doct.Rows.Count > 0)
{
dataGridViewdoc.DataSource = doct;
DataGridViewDisableButtonColumn btn = new DataGridViewDisableButtonColumn();
btn.HeaderText = " ";
btn.Name = "yesbtn";
btn.Text = "Accept";
btn.UseColumnTextForButtonValue = true;
dataGridViewdoc.Columns.Add(btn);
}
else
{
dataGridViewdoc.DataSource = doct;
DataGridViewDisableButtonColumn btn = new DataGridViewDisableButtonColumn();
btn.HeaderText = " ";
btn.Name = "yesbtn";
btn.Text = "Accept";
btn.UseColumnTextForButtonValue = true;
dataGridViewdoc.Columns.Add(btn);
}
}
private void dataGridView2_CellClick(object sender, DataGridViewCellEventArgs e)
{
if (e.ColumnIndex == 6)
{
//MessageBox.Show(c.ToString());
if (c == 'd')
{
int a;
//string s = dataGridView2.Rows[e.RowIndex].Cells["Id"].ToString();
string s = dt.Rows[e.RowIndex]["Id"].ToString();
bool result = Int32.TryParse(s, out a);
string st = "Delete from Doctor where Id=" + a + ";";
da.Execute(st);
dataGridView2.DataSource = null;
dataGridView2.Rows.Clear();
dataGridView2.Columns.Clear();
dt.Clear();
string query = "select * from Doctor";
da.readDatathroughAdapter(query, dt);
dataGridView2.DataSource = dt;
DataGridViewDisableButtonColumn btn = new DataGridViewDisableButtonColumn();
btn.HeaderText = "";
btn.Name = "yesbtn";
btn.Text = "Delete";
btn.UseColumnTextForButtonValue = true;
dataGridView2.Columns.Add(btn);
da.closeConn();
}
else if (c == 'p')
{
int a;
string s = dt.Rows[e.RowIndex]["Id"].ToString();
bool result = Int32.TryParse(s, out a);
string st = "Delete from Patient where Id=" + a + ";";
da.Execute(st);
dataGridView2.DataSource = null;
dataGridView2.Rows.Clear();
dataGridView2.Columns.Clear();
dt.Clear();
string query = "select * from Patient";
da.readDatathroughAdapter(query, dt);
dataGridView2.DataSource = dt;
DataGridViewDisableButtonColumn btn = new DataGridViewDisableButtonColumn();
btn.HeaderText = "";
btn.Name = "yesbtn";
btn.Text = "Delete";
btn.UseColumnTextForButtonValue = true;
dataGridView2.Columns.Add(btn);
da.closeConn();
}
}
}
private void searchbtn_Click(object sender, EventArgs e)
{
string hos = null, spe = null;
hos = searchhospital.Text;
spe = searchspecial.Text;
if (hos == "" || spe == "")
{
MessageBox.Show("Invalid request!!");
}
else
{
hos = hos.Replace(' ', '_');
string st = "Select * from " + hos + " where Specialist like '%" + spe + "%'";
dt = db.Data(st);
this.dataGridView1.DataSource = null;
this.dataGridView1.Rows.Clear();
this.dataGridView1.Columns.Clear();
this.dataGridView1.Refresh();
if (dt.Rows.Count > 0)
{
dataGridView1.DataSource = dt;
DataGridViewDisableButtonColumn btn = new DataGridViewDisableButtonColumn();
btn.HeaderText = "";
btn.Name = "yesbtn";
btn.Text = "Request";
btn.UseColumnTextForButtonValue = true;
dataGridView1.Columns.Add(btn);
hos = hos.Replace('_', ' ');
st = "Select * from Requests where Pname = '" + PHome.ds.Rows[0]["Name"].ToString() + "' and Hospital = '" + hos + "';";
dr = db.Data(st);
for (int i = 0; i < dr.Rows.Count; i++)
{
for (int j = 0; j < dataGridView1.Rows.Count; j++)
{
if (dr.Rows[i]["Dname"].ToString() == dataGridView1.Rows[j].Cells["Name"].Value.ToString())
{
((DataGridViewDisableButtonCell)dataGridView1.Rows[j].Cells[5]).Enabled = false;
}
}
}
dataGridView1.Refresh();
}
else
{
MessageBox.Show("No Results found!!");
}
}
}
private void btnPatient_Click(object sender, EventArgs e)
{
c = 'p';
dataGridView2.DataSource = null;
dataGridView2.Rows.Clear();
dataGridView2.Columns.Clear();
dt.Clear();
dataGridView2.Refresh();
string query = "select * from Patient";
da.readDatathroughAdapter(query, dt);
dataGridView2.DataSource = dt;
DataGridViewDisableButtonColumn btn = new DataGridViewDisableButtonColumn();
btn.HeaderText = "";
btn.Name = "yesbtn";
btn.Text = "Delete";
btn.UseColumnTextForButtonValue = true;
dataGridView2.Columns.Add(btn);
da.closeConn();
}
