// Updates the database to approve/disaproove public void Approve(STENER c, int id, bool approve) { OleDbConnection con = new OleDbConnection(Connstring); OleDbCommand cmd = con.CreateCommand(); con.Open(); int value = 0; if (approve == false) { value = -1; } else { value = 1; } cmd.CommandText = "UPDATE STENER SET approval=@X WHERE s_id=@Y"; cmd.Parameters.AddWithValue("@X", value); cmd.Parameters.AddWithValue("@Y", id); cmd.Connection = con; cmd.ExecuteNonQuery(); OleDbDataReader read = cmd.ExecuteReader(); con.Close(); }
// Get a specific public List <string> GetSten(STENER c) { OleDbConnection con = new OleDbConnection(Connstring); OleDbCommand cmd = con.CreateCommand(); con.Open(); cmd.CommandText = "SELECT * FROM STENER WHERE s_id=X AND d_id=Y"; cmd.Parameters.AddWithValue("Y", c.D_id); OleDbDataAdapter adapter = new OleDbDataAdapter(cmd); cmd.Connection = con; cmd.ExecuteNonQuery(); OleDbDataReader read = cmd.ExecuteReader(); List <string> Arr = new List <string>(); while (read.Read()) { string Temp = ""; Temp += read[0].ToString() + ":\t\t" + read[1].ToString() + ":\t\t" + read[2].ToString(); Arr.Add(Temp); } con.Close(); return(Arr); }
// Get a list of steners to view public List <List <string> > ViewSS(STENER c) { OleDbConnection con = new OleDbConnection(Connstring); OleDbCommand cmd = con.CreateCommand(); con.Open(); cmd.CommandText = cmd.CommandText = "SELECT * FROM STENER "; OleDbDataAdapter adapter = new OleDbDataAdapter(cmd); cmd.Connection = con; cmd.ExecuteNonQuery(); OleDbDataReader read = cmd.ExecuteReader(); List <List <string> > Arr = new List <List <string> >(); while (read.Read()) { if (read[4].ToString() == "True") { List <string> Temp = new List <string>(); Temp.Add(read[0].ToString()); Temp.Add(read[1].ToString()); Arr.Add(Temp); } else { } } con.Close(); return(Arr); }
public void Sumbit(STENER c, int i) { OleDbConnection con = new OleDbConnection(Connstring); OleDbCommand cmd = con.CreateCommand(); cmd.CommandText = "UPDATE STENER SET status = TRUE WHERE s_id=( SELECT s_id FROM STENER WHERE d_id=@d_id) "; cmd.Connection = con; cmd.Parameters.AddWithValue("d_id", i); cmd.Connection = con; con.Open(); cmd.ExecuteNonQuery(); con.Close(); }
public void Iwish(STENER c) { OleDbConnection con = new OleDbConnection(Connstring); OleDbCommand cmd = con.CreateCommand(); cmd.CommandText = "DELETE FROM STENER WHERE s_id=@s_id"; cmd.Connection = con; cmd.Parameters.AddWithValue("@s_id", c.S_id); cmd.Connection = con; con.Open(); cmd.ExecuteNonQuery(); con.Close(); }
//creating a new STENER public void CreateS(STENER c) { OleDbConnection con = new OleDbConnection(Connstring); OleDbCommand cmd = con.CreateCommand(); try { cmd.CommandText = "INSERT INTO STENER(d_id) VALUES(@dept_id)"; cmd.Connection = con; //insert value cmd.Parameters.AddWithValue("@d_id", c.D_id); cmd.Connection = con; con.Open(); cmd.ExecuteNonQuery(); } catch (OleDbException ex) { string bad = "That dept already exists"; MessageBox.Show(bad); } con.Close(); }