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 *******************");
}
}
