public bool insertSession(SessionDomain sessionDomain)
{
bool check = false;
sqlConnection.Open();
sqlCommand = new SqlCommand(sessionQuery.saveSessionQuery(sessionDomain), 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);
}
public bool updateSession(SessionDomain sessionDomain)
{
bool ret = false;
sqlConnection.Open();
string query = sessionQuery.updateSessionQuery(sessionDomain);
sqlCommand = new SqlCommand(query, sqlConnection);
try {
sqlCommand.ExecuteNonQuery();
ret = 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(ret);
}
public SessionDomain getSession(string title)
{
SessionDomain sessionDomain = null;
sqlConnection.Open();
string query = sessionQuery.getSessionQuery(title);
sqlCommand = new SqlCommand(query, sqlConnection);
try
{
sqlDataReader = sqlCommand.ExecuteReader();
while (sqlDataReader.Read())
{
sessionDomain = new SessionDomain(title, sqlDataReader.GetString(0),
sqlDataReader.GetInt32(1), sqlDataReader.GetInt32(2),
sqlDataReader.GetInt32(3), sqlDataReader.GetDateTime(4));
}
sqlDataReader.Close();
}
catch (InvalidCastException invalid)
{
Console.WriteLine(invalid.Message);
}
catch (SqlException sql)
{
Console.WriteLine("exception sql is :: " + sql.Message);
}
catch (InvalidOperationException invalid)
{
Console.WriteLine(invalid.Message);
}
catch (Exception exception) {
Console.WriteLine(exception.Message);
}
sqlConnection.Close();
return(sessionDomain);
}
static void sessionOperationFull()
{
Session.Session session = new Session.Session();
// date is already create with the date of today but make it auto create with today date
//Session.SessionDomain sessionDomain = new Session.SessionDomain("test2", "descrition", 1, 0, 0 , new DateTime());
Session.SessionDomain sessionDomain = new Session.SessionDomain("test2", "descrition", 1, 0, 0);
if (session.insertSession(sessionDomain))
{
Console.WriteLine("done saving");
}
sessionDomain = session.getSession("test2");
if (sessionDomain != null)
{
sessionDomain.printDate();
}
sessionDomain.description = "change desc";
if (session.updateSession(sessionDomain))
{
Console.WriteLine("******************* Done update *******************");
}
}
public string updateSessionQuery(SessionDomain session)
{
return("UPDATE [dbo].[Session] SET [description] = '" + session.description + "' ,[Date] = '" + session.date +
"',[classID] = '" + session.classID + "',[schedualID] = '" + session.schedualeID + "',[dateID] = '" + session.dateID +
"' WHERE title = '" + session.title + "'");
}
public string saveSessionQuery(SessionDomain session)
{
return("INSERT INTO [dbo].[Session] ([title] ,[description] ,[Date] ,[classID] ,[schedualID] ,[dateID]) " +
"VALUES ('" + session.title + "','" + session.description + "','" + session.date + "','" + session.classID +
"','" + session.schedualeID + "','" + session.dateID + "')");
}
