string GetUser() { db.OpenConnection(); String sqlSelectQuery = "select COUNT(PaniUser.Username) as 'Username' from PaniUser where PaniUser.Username = '******';"; SqlCommand cmd = new SqlCommand(sqlSelectQuery, DAL.clsDAL.db); SqlDataReader dr = cmd.ExecuteReader(); if (dr.Read()) { return(dr["Username"].ToString()); } return("0"); }
public DataTable EnlistCentro() { DataTable dataTable = new DataTable(); db.OpenConnection(); command.Connection = DAL.clsDAL.db; command.CommandText = "EXECUTE ENLISTCENTRO"; SqlDataReader reader = command.ExecuteReader(); dataTable.Load(reader); return(dataTable); db.CloseConnection(); }
public DataTable EnlistSubModalities() { DataTable dataTable = new DataTable(); db.OpenConnection(); command.Connection = DAL.clsDAL.db; command.CommandText = "EXECUTE ENLISTSUBMODALITIES"; SqlDataReader reader = command.ExecuteReader(); dataTable.Load(reader); return(dataTable); db.CloseConnection(); }
void LoadGender() { DAL.clsDAL db = new DAL.clsDAL(); SqlCommand command = new SqlCommand(); try { db.OpenConnection(); command.Connection = DAL.clsDAL.db; command.CommandText = "Select Gender from Gender;"; SqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { comboBoxgGender.Items.Add(reader["Gender"].ToString()); } } catch { MessageBox.Show("Error "); } }
void LoadSubModilty() { DAL.clsDAL db = new DAL.clsDAL(); SqlCommand command = new SqlCommand(); try { db.OpenConnection(); command.Connection = DAL.clsDAL.db; command.CommandText = "select Sub_Modality.Sub_Modality_Name from Sub_Modality where Sub_Modality.Modality_ID = 5"; SqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { comboBoxSubmodality.Items.Add(reader["Sub_Modality_Name"].ToString()); } } catch { MessageBox.Show("Error "); } }
void LoadRegions() { DAL.clsDAL db = new DAL.clsDAL(); SqlCommand command = new SqlCommand(); try { db.OpenConnection(); command.Connection = DAL.clsDAL.db; command.CommandText = "Select * from Region"; SqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { comboBoxRegion.Items.Add(reader["Region_Name"].ToString()); } } catch { MessageBox.Show("Error "); } }
void LoadModalities() { DAL.clsDAL db = new DAL.clsDAL(); SqlCommand command = new SqlCommand(); try { db.OpenConnection(); command.Connection = DAL.clsDAL.db; command.CommandText = "select Modality.Modality_Name from Modality order by Modality.Modality_ID asc;"; SqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { comboBoxModality.Items.Add(reader["Modality_Name"].ToString()); } } catch { MessageBox.Show("Error "); } }
public DataTable EnlistIntervencion() { DataTable dataTable = new DataTable(); db.OpenConnection(); command.Connection = DAL.clsDAL.db; command.CommandText = "EXECUTE ENLISTINTERVENCION"; SqlDataReader reader = command.ExecuteReader(); dataTable.Load(reader); return(dataTable); db.CloseConnection(); }