public CourseDomain get(int id) { CourseDomain courseDomain = null; sqlConnection.Open(); sqlCommand = new SqlCommand(courseQuery.getCourseByid(id), sqlConnection); try { sqlDataReader = sqlCommand.ExecuteReader(); while (sqlDataReader.Read()) { id = sqlDataReader.GetInt32(0); string name = sqlDataReader.GetString(1); courseDomain = new CourseDomain(name, id); } sqlDataReader.Close(); } catch (InvalidCastException invalid) { Console.WriteLine(invalid.Message); } catch (SqlException sql) { Console.WriteLine(sql.Message); } catch (InvalidOperationException invalid) { Console.WriteLine(invalid.Message); } sqlConnection.Close(); return(courseDomain); }
public bool insert(CourseDomain courseDomain) { bool check = false; sqlConnection.Open(); string query = courseQuery.insertQuery(courseDomain.coursename); sqlCommand = new SqlCommand(query, sqlConnection); try { sqlCommand.ExecuteNonQuery(); check = true; } catch (InvalidCastException invalid) { Console.WriteLine(invalid.Message); } catch (SqlException sql) { Console.WriteLine(sql.Message); } catch (InvalidOperationException invalid) { Console.WriteLine(invalid.Message); } sqlConnection.Close(); return(check); }
static private void courseOperationFullStack() { Course.Course course = new Course.Course(); Course.CourseDomain c1 = new Course.CourseDomain("OOP"); Course.CourseDomain c2 = new Course.CourseDomain("ASP"); if (course.insert(c1) && course.insert(c2)) { Console.WriteLine("******************* Done insert *******************"); } Course.CourseDomain courseDomain = course.get("OOP"); courseDomain.coursename = "C++"; if (course.update(courseDomain)) { Console.WriteLine("******************* Done insert *******************"); } }