private void btnFind_Click(object sender, EventArgs e)
{
String[] fields = { "id", "room_id", "date_booked" };
SqlConnection conn = DBUtils.GetDBConnection();
string sql = "SELECT id as ID, room_id as Room_ID, date_booked as Date, time_start as TimeStart, time_end as TimeEnd, members_qtt as Members FROM BookedRoom_table where user_id= " + DBUtils.currentUserID + " and " + fields[dropFields.selectedIndex] + " like '%" + txtValue.Text + "%'";
conn.Open();
SqlCommand cmd = new SqlCommand(sql, conn);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds);
dataGrid1.DataSource = ds.Tables[0];
cmd.Dispose();
conn.Close();
}
private void btnFind_Click(object sender, EventArgs e)
{
String[] fields = { "id", "user_id", "room_id", "date_booked" };
SqlConnection conn = DBUtils.GetDBConnection();
string sql = "SELECT * FROM BookedRoom_table where " + fields[dropFields.selectedIndex] + " like '%" + txtValue.Text + "%'";
conn.Open();
SqlCommand cmd = new SqlCommand(sql, conn);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds);
dataGrid1.DataSource = ds.Tables[0];
cmd.Dispose();
conn.Close();
}
public UserHistory()
{
InitializeComponent();
dropFields.selectedIndex = 0;
SqlConnection conn = DBUtils.GetDBConnection();
string sql = "SELECT id as ID, room_id as Room_ID, date_booked as Date, time_start as TimeStart, time_end as TimeEnd, members_qtt as Members FROM BookedRoom_table where user_id= " + DBUtils.currentUserID;
conn.Open();
SqlCommand cmd = new SqlCommand(sql, conn);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds);
dataGrid1.DataSource = ds.Tables[0];
cmd.Dispose();
conn.Close();
}
private bool checkLoginExist()
{
bool result = false;
if (!userDefaulLogin.Equals(txtLogin.Text))
{
SqlConnection conn = DBUtils.GetDBConnection();
conn.Open();
SqlCommand cmd;
SqlDataReader reader;
String sql = "";
sql = "Select * from user_table where login='******';";
cmd = new SqlCommand(sql, conn);
reader = cmd.ExecuteReader();
result = reader.HasRows;
cmd.Dispose();
conn.Close();
}
return(result);
}
public ManageRooms()
{
InitializeComponent();
conn = DBUtils.GetDBConnection();
dropFields.selectedIndex = 0;
}
