private void btnSearch_Click(object sender, EventArgs e)
{
string qury = txtqury.Text;
dt = dal.SelectDataWithQuery(qury);
dataGridView1.DataSource = dt;
}
public DataTable SelectAllUsers()
{
DAL.DataAccessLayer Dal = new DAL.DataAccessLayer();
dt = Dal.SelectDataWithQuery("SelectAllUsers");
return(dt);
}
public DataTable git_max_SurgeryPrices()
{
DAL.DataAccessLayer Dal = new DAL.DataAccessLayer();
DataTable dt = new DataTable();
dt = Dal.SelectDataWithQuery("git_max_SurgeryPrices");
return(dt);
}
public DataTable NameSurgreyGeneral()
{
DataTable dt = new DataTable();
DAL.DataAccessLayer Dal = new DAL.DataAccessLayer();
dt = Dal.SelectDataWithQuery("NameSurgreyGeneral");
return(dt);
}
public DataTable SelectAllPatient()
{
DataTable dt = new DataTable();
DAL.DataAccessLayer Dal = new DAL.DataAccessLayer();
dt = Dal.SelectDataWithQuery("SelectAllPatient");
return(dt);
}
public DataTable select_all_SurgeryPrices()
{
DAL.DataAccessLayer Dal = new DAL.DataAccessLayer();
DataTable dt = new DataTable();
// dt = Dal.SelectDataWithQuery("SelectAllBondBookType");
dt = Dal.SelectDataWithQuery("select_all_SurgeryPrices");
return(dt);
}
public DataTable SelectAllChecked_Patient()
{
DataTable dt = new DataTable();
DAL.DataAccessLayer Dal = new DAL.DataAccessLayer();
Dal.CheckIsOpen();
dt = Dal.SelectDataWithQuery("SelectAllChecked_Patient");
Dal.CheckIsClosed();
return(dt);
}
public DataTable SeletAllcLocal_Narcosis()
{
DataTable dt = new DataTable();
DAL.DataAccessLayer Dal = new DAL.DataAccessLayer();
Dal.CheckIsOpen();
dt = Dal.SelectDataWithQuery("SeletAllcLocal_Narcosis");
Dal.CheckIsClosed();
return(dt);
}
public DataTable SelectAllBondBook()
{
DataTable dt = new DataTable();
DAL.DataAccessLayer Dal = new DAL.DataAccessLayer();
// Dal.CheckIsOpen();
dt = Dal.SelectDataWithQuery("SelectAllBondBook");
// Dal.CheckIsClosed();
return(dt);
}
public DataTable Select_All_Post_Operative_Follow_up()
{
DataTable dt = new DataTable();
DAL.DataAccessLayer Dal = new DAL.DataAccessLayer();
Dal.CheckIsOpen();
dt = Dal.SelectDataWithQuery("Select_All_Post_Operative_Follow_up");
Dal.CheckIsClosed();
return(dt);
}
public DataTable selectList()
{
DataTable dt = new DataTable();
DAL.DataAccessLayer Dal = new DAL.DataAccessLayer();
Dal.CheckIsOpen();
dt = Dal.SelectDataWithQuery("selectList");
Dal.CheckIsClosed();
return(dt);
}
public int Get_max_id_Surgery()
{
DAL.DataAccessLayer Dal = new DAL.DataAccessLayer();
int id;
Dal.CheckIsOpen();
dt = Dal.SelectDataWithQuery("Get_max_id_Surgery");
Dal.CheckIsClosed();
id = Convert.ToInt32(dt.Rows[0][0]);
return(id);
}
public int Git_Max_id_For_Checked_Patient()
{
DAL.DataAccessLayer Dal = new DAL.DataAccessLayer();
int id;
Dal.CheckIsOpen();
dt = Dal.SelectDataWithQuery("Git_Max_id_For_Checked_Patient");
Dal.CheckIsClosed();
id = Convert.ToInt32(dt.Rows[0][0]);
return(id);
}
public int Git_Max_id_For_Post_Operative_Follow_up()
{
DAL.DataAccessLayer Dal = new DAL.DataAccessLayer();
int id;
Dal.CheckIsOpen();
dt = Dal.SelectDataWithQuery("Git_Max_id_For_Post_Operative_Follow_up");
Dal.CheckIsClosed();
id = Convert.ToInt32(dt.Rows[0][0]);
return(id);
}