public bool DeleteSessions(SessionMember sessionMember) { return(_sessionRepository.DeleteSession(new SessionMemberDAO { SessionId = sessionMember.SessionId })); }
public bool InsertSessions(SessionMember sessionMember) { return(_sessionRepository.InsertSession(new SessionMemberDAO { FilmId = sessionMember.FilmId, Date = sessionMember.Date, Time = sessionMember.Time, HallId = sessionMember.HallId })); }
public ValidationResultString UpdateSessions(SessionMember sessionMember) { if (sqlConnect.GetConnect) { sqlConnect.OpenConn(); } ValidationResultString result = new ValidationResultString() { IsValid = true }; try { string commPart = " UPDATE maindb.\"Session\" " + " SET \"FilmId\" = @1, \"Date\" = @2, \"Time\" = @3::time without time zone, \"HallId\" = @4 " + " WHERE \"SessionId\" = @5;"; NpgsqlCommand command = new NpgsqlCommand(commPart, sqlConnect.GetNewSqlConn().GetConn); command.Parameters.AddWithValue("@1", Convert.ToInt32(sessionMember.FilmId)); command.Parameters.AddWithValue("@2", Convert.ToDateTime(sessionMember.Date)); command.Parameters.AddWithValue("@3", sessionMember.Time); command.Parameters.AddWithValue("@4", Convert.ToInt32(sessionMember.HallId)); command.Parameters.AddWithValue("@5", Convert.ToInt32(sessionMember.SessionId)); NpgsqlDataReader readerTable = command.ExecuteReader(); readerTable.Close(); } catch (Npgsql.PostgresException exp) { return(new ValidationResultString { Errors = new List <string> { exp.SqlState } }); } finally { if (!sqlConnect.GetConnect) { sqlConnect.CloseConn(); } } return(result); }
public ValidationResultString DeleteSessions(SessionMember sessionMember) { if (sqlConnect.GetConnect) { sqlConnect.OpenConn(); } ValidationResultString result = new ValidationResultString() { IsValid = true }; try { string commPart = "DELETE FROM maindb.\"Session\" WHERE \"SessionId\"=@1"; NpgsqlCommand command = new NpgsqlCommand(commPart, sqlConnect.GetNewSqlConn().GetConn); command.Parameters.AddWithValue("@1", Convert.ToInt32(sessionMember.SessionId)); NpgsqlDataReader readerTable = command.ExecuteReader(); readerTable.Close(); } catch (Npgsql.PostgresException exp) { return(new ValidationResultString { Errors = new List <string> { exp.SqlState } }); } finally { if (!sqlConnect.GetConnect) { sqlConnect.CloseConn(); } } return(result); }
public bool InsertSession(SessionMember sessionMember) { var res = InsertSessions(sessionMember); return(res.IsValid); }
public bool UpdateSession(SessionMember sessionMember) { var res = UpdateSessions(sessionMember); return(res.IsValid); }
public bool DeleteSession(SessionMember sessionMember) { var res = DeleteSessions(sessionMember); return(res.IsValid); }