public bool updateTreatment(TreatmentDTO t) { try { string query = "update Treatment set cost=" + t.Cost + " where name='" + t.Name + "'"; c.sqlComm = new SqlCommand(query, c.sqlConn); c.sqlConn.Open(); c.sqlComm.ExecuteNonQuery(); c.sqlConn.Close(); return(true); } catch (Exception e) { c.sqlConn.Close(); return(false); } }
public bool addTreatment(TreatmentDTO t) { try { string query = "insert into Treatment (Name, Cost) values ('" + t.Name + "'," + t.Cost + ")"; c.sqlComm = new SqlCommand(query, c.sqlConn); c.sqlConn.Open(); c.sqlComm.ExecuteNonQuery(); c.sqlConn.Close(); query = "CREATE TABLE " + t.Name + " (tID int primary key identity, pID int, dID int, tooth varchar(50), quantity int, cost int, paid int, date varchar(50));"; c.sqlComm = new SqlCommand(query, c.sqlConn); c.sqlConn.Open(); c.sqlComm.ExecuteNonQuery(); c.sqlConn.Close(); return(true); } catch (Exception e) { c.sqlConn.Close(); return(false); } }