public Clas GetClass(int cId) { conn.Open(); string query = string.Format("SELECT * FROM Classes WHERE cId = '{0}'", cId); SqlCommand cmd = new SqlCommand(query, conn); SqlDataReader reader = cmd.ExecuteReader(); Clas clas = null; while (reader.Read()) { clas = new Clas(); clas.cId = reader.GetInt32(reader.GetOrdinal("cId")); clas.clas = reader.GetInt32(reader.GetOrdinal("class")); clas.classFee = reader.GetInt32(reader.GetOrdinal("classFee")); } conn.Close(); return(clas); }
public bool UpdateClass(Clas c, int cId) { try { conn.Open(); string query = String.Format("UPDATE Classes SET class ='{0}', classFee = '{1}' WHERE cId = '{2}'", c.clas, c.classFee, cId); SqlCommand cmd = new SqlCommand(query, conn); int r = cmd.ExecuteNonQuery(); conn.Close(); if (r > 0) { return(true); } return(false); } catch { MessageBox.Show("Update Class Failed, Class already exist"); return(false); } }
public bool AddClass(Clas c) { try { conn.Open(); string query = String.Format("INSERT INTO Classes VALUES ('{0}','{1}')", c.clas, c.classFee); SqlCommand cmd = new SqlCommand(query, conn); int result = cmd.ExecuteNonQuery(); conn.Close(); if (result > 0) { return(true); } return(false); } catch { MessageBox.Show("Failed to add Class"); return(false); } }