private List <Timetable> ReadTables(DataTable dataTable) { List <Timetable> timetables = new List <Timetable>(); try { foreach (DataRow dr in dataTable.Rows) { Activity_DAO activity_dao = new Activity_DAO(); Timetable timetable = new Timetable() { timetable_id = (int)dr["timetable_id"], activity = activity_dao.GetById((int)dr["activity_id"]), startTime = (DateTime)dr["start_time"], endTime = (DateTime)dr["end_time"], }; timetable.nrOfSupervisors = timetable.activity.nrOfSupervisors; timetables.Add(timetable); } return(timetables); } catch { ErrorDAO error = new ErrorDAO("Application couldn't read the timetable table"); } return(null); }
private List <Activity> ReadTables(DataTable dataTable) { List <Activity> activities = new List <Activity>(); try { foreach (DataRow dr in dataTable.Rows) { Activity activity = new Activity() { activity_id = (int)dr["activity_id"], activity_name = (dr["activity_name"].ToString()), nrOfStudents = (int)dr["nrOfStudents"], activity_Date = (DateTime)dr["activity_date"], nrOfSupervisors = (int)dr["nrOfSupervisors"] }; activities.Add(activity); } return(activities); } catch { ErrorDAO error = new ErrorDAO("Application couldn't read the activity table"); } return(null); }
/* For Insert/Update/Delete Queries with an auto_increment id value*/ protected int ExecuteEditQueryAutoIncrement(String query, SqlParameter[] sqlParameters) { SqlCommand command = new SqlCommand(); int autoIncrementedId = -1; try { command.Connection = OpenConnection(); command.CommandText = query; command.Parameters.AddRange(sqlParameters); adapter.InsertCommand = command; autoIncrementedId = int.Parse(command.ExecuteScalar().ToString()); } catch { ErrorDAO error = new ErrorDAO("ChapeauApp couldn't execute the query"); throw; } finally { CloseConnection(); } return(autoIncrementedId); }
/* For Select Queries */ protected DataTable ExecuteSelectQuery(String query, params SqlParameter[] sqlParameters) { SqlCommand command = new SqlCommand(); DataTable dataTable; DataSet dataSet = new DataSet(); try { command.Connection = OpenConnection(); command.CommandText = query; command.Parameters.AddRange(sqlParameters); command.ExecuteNonQuery(); adapter.SelectCommand = command; adapter.Fill(dataSet); dataTable = dataSet.Tables[0]; } catch { string exp = "SomerenApp couldn't execute the select query"; ErrorDAO error = new ErrorDAO(exp); return(null); } finally { CloseConnection(); } return(dataTable); }
private void CloseConnection() { try { conn.Close(); } catch { ErrorDAO error = new ErrorDAO("ChapeauApp couldn't close the connection"); } }
private void CloseConnection() { try { conn.Close(); } catch { string exp = "SomerenApp couldn't close the connection"; ErrorDAO error = new ErrorDAO(exp); } }
/* For Insert/Update/Delete Queries with transaction */ protected void ExecuteEditTranQuery(String query, SqlParameter[] sqlParameters, SqlTransaction sqlTransaction) { SqlCommand command = new SqlCommand(query, conn, sqlTransaction); try { command.Parameters.AddRange(sqlParameters); adapter.InsertCommand = command; command.ExecuteNonQuery(); } catch { ErrorDAO error = new ErrorDAO("ChapeauApp couldn't execute the query"); } }
protected SqlConnection OpenConnection() { try { if (conn.State == ConnectionState.Closed || conn.State == ConnectionState.Broken) { conn.Open(); } return(conn); } catch { ErrorDAO error = new ErrorDAO("ChapeauApp Couldn't open the connection"); return(null); } }
/* For Insert/Update/Delete Queries with transaction */ protected void ExecuteEditTranQuery(String query, SqlParameter[] sqlParameters, SqlTransaction sqlTransaction) { SqlCommand command = new SqlCommand(query, conn, sqlTransaction); try { command.Parameters.AddRange(sqlParameters); adapter.InsertCommand = command; command.ExecuteNonQuery(); } catch { string exp = "SomerenApp couldn't execute query"; ErrorDAO error = new ErrorDAO(exp); // showmethod throw; } }
protected SqlConnection OpenConnection() { try { if (conn.State == ConnectionState.Closed || conn.State == ConnectionState.Broken) { conn.Open(); } } catch { string exp = "SomerenApp couldn't open the connection"; ErrorDAO error = new ErrorDAO(exp); } return(conn); }
/* For Insert/Update/Delete Queries */ protected void ExecuteEditQuery(String query, SqlParameter[] sqlParameters) { SqlCommand command = new SqlCommand(); try { command.Connection = OpenConnection(); command.CommandText = query; command.Parameters.AddRange(sqlParameters); adapter.InsertCommand = command; command.ExecuteNonQuery(); } catch { ErrorDAO error = new ErrorDAO("ChapeauApp couldn't execute the query"); throw; } finally { CloseConnection(); } }