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